Copy TNS file at following location and check.
I have already done this .. But still the same error.
Any other suggestions please ..
Look for all the places where tnsnames.ora is located on your PC - do a file search from Windows.
Replace all of them with your latest one. One of them is directing the connection, if you get them all then it cant escape you.
You may have environment variables like TNS_ADMIN set in your system or registry
Had tried everything but still couldn't figure it out.
ORA- 12154 :TNS : could not resolve the correct identifier specified.
This error is "local" to your Forms/Reports Home, that is a tnsnames.ora is not found where it should be, or there is some (syntax) error within it, or the connection string specified is not present in it.
My oracle is working fine both the 9i and 11g versions.
So you have 9i and 11g databases active on your machine ? Then I assume there is a 11g active listener, and both DBs are registered with it. To confirm this, post the result, from 11g DB Home, of
Also post your tnsnames.ora.
Apart from what you've already done, and what suggested by others, did you try the Easy Connect Naming Method ?