Thanks GUYS …. I already identified the problem … the problem is none of the above . It is a cache problem. You know I had to download the datafiles from the live server to the local server .
After properly checking and changing all configurations and file paths; i forgot to clear the cache of the live server; so that the local webserver will start rebuilding a new cache . And when I lauch the site with the old server cache. It obstructed the server from properly reading in and writing datafiles based on its own config cache settings.
As soon as I cleared the CACHE folder in the themes directory, site starting working normal on local machine .
Thanks all for your time .