I have two Oracle home in my PC, 8.0.5 and 8.1.7 , connection to Databases from 8.0.5 sqlplus is fine.
I have copied the TNSNAMES.ORA from 8.0.5 network folder to 8.1.7 network\admin folder but still when I am trying to connect to Database by sqlplus version 8.1.7 it returns erro : Could not resolve servica name. I try change Oracle home with home selector also. Didn't help.
Can you elaborate how can I resolve this issue?
An ounce of prevention is worth a pound of cure
What I understand is there is two versions of networking and some conflicts with networking. Make sure you have only one version of networking enabled. Stop all the listener services and start only 817 listener. That should take care of your proble. If its unix make sure you TNS_ADMIN variable set to /817O_H/network/admin.
check sqlnet.ora files and made the the same
NAMES.DEFAULT_DOMAIN = ......
remove NAMES.DEFAULT_DOMAIN from both files
(8.0.5 and 8.1.7 has difference in using oracle domain names)
Click Here to Expand Forum to Full Width