I know when you get this error message there should be something wrong with the tnsnames.ora file... But in this perticular case I cannot find whats wrong, can some one help please.
I have pasted below is the text from tnsnames.ora file..
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle816)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = ORACLE81))
I have 3 machines.
1. Oracle816 which is a oracle 816 server.
2. test1.. which has oracle 816 client installed
3. test2.. which has oracle 805 client installed
System User Id and password for server is ora/ora.
***I have done find all tnsnames.ora file on all of these machines and made sure that they all have the same text pasted above.
I can login to sql plus or worksheet using ora/ora@orcl81
from test2 machine but I cannot do the same from oracle816 and test1 machine.
It gives me error saying..
TNS:could not resolve service name.
Where else is it looking for service name ?
Why ? this has really puzzled me !
Has anyone had this problem before, does anyone knows the solution ?
Thanks for all your help in advance
05-10-2001, 02:54 PM
Double check the tnsnames.ora file present under $ORACLE_HOME/network/admin. You might have missed some info, like paranthesis or etc.
Check your sqlnet.ora file under the above directory and check the information with the working server.
I did they are same. As a matter of fact I have copied tnsnames.ora file from the machine test2 where it is working to all locations of tnsnames.ora on oracle816.
Here is the text from sqlnet file. It is also same on both machines.
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off
05-10-2001, 03:03 PM
try connecting as --
05-10-2001, 03:16 PM
Could you change the service_name to SID and try. Next try specifying the IP in the host. Compare it with this sample
I wished I would have read Rajeev's reply before...I just got it to work and reading all these replies...
What Rajeev said worked !! But not by setting it in tnsnames.ora file, but I had to do that using Oracle Net8 configuration assistant.
I changed orcl81.world to orcl81
One more thing , after I changed orcl81.world to orcl81
using oracle net8 configuration assistant, I did not find that change in any of the tnsnames.ora file. It works now. But where did my change got written ???
Whats the difference between using orcl81 and orcl81.world ??
All oracle examples show .world ...
Belive me I had tried everthing that SAM had mentioned... nothing was working !!
Thats why I use this forum and like it #@%
05-10-2001, 04:10 PM
See if your sqlnet.ora file was updated (check the timestamp)
I am not very clear about this but I think it's the combination of sqlnet.ora (names.default_domain = world) and tnsnames.ora that guide the whole thing.