Hi,
I installed oracle 11g and loaded with the data.When we try to connect with the toad its throughing ORA - 12154: TNS could not resolve service name error.Where as same toad gets connected when i modify the TNS net service name with .anything (eg orcl.com , orcl.11g, orcl.1 etc).My question is
Why toad is unable to connect when i dont use **net service name.anything?
where as same taod gets connected when i use .anything with connect string in tnsnames.ora file.
Its very urgent so i would be grateful for quick response with stepwise resolution.
Thanks,
S.Jamal**
Morning Safdar,
I installed oracle 11g and loaded with the data.When we try to connect
with the toad its throughing ORA - 12154: TNS could not resolve service
name error.
Can you please post the contents of the sqlnet.ora file located in
ORACLE_HOME for the client machine where you are running Toad. Also,
check for an environment variable named $TNS_ADMIN% on the client. If
that is set, then the sqlnet.ora and tnsnames.ora from that location is
what we need to see.
Please also post the tnsnames.ora entry for the database you are trying
to connect to. (Just the entry, not the whole tnsnames.ora.)
Where as same toad gets connected when i modify the TNS net
service name with*.anything* (eg orcl.com , orcl.11g, orcl.1 etc).My
question is
Why toad is unable to connect when i dont use *net service name.anything?
I suspect there's something in your sqlnet.ora file that is causing this.
Its very urgent so i would be grateful for quick response with stepwise
resolution.
This is not actually a Toad problem. It's an Oracle client problem. Your
client is not set up correctly by the sound of things. Toad is a tool
that sits on top of a correctly functioning sqlnet system.
Have you tried connecting with sqlplus, using the same Oracle client
etc? I rather suspect you will get the same problem.
--
Cheers,
Norm. [TeamT]