| ORA-12154: TNS:could not resolve service name [message #54253] |
Thu, 07 November 2002 02:28  |
Silke Booms
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
I'm looking for the environment parameter that build the tns service name. If I call sqlplus fully qualified (for example sqlplus dummy/pq@server1) then nothing will go wrong. But if I only call sqlplus without any server defined I will get the above mentioned message.
Is there any possibility to see which service names has been used? (Log file, verbose mode or something like that?)
Thanks for help
Silke
|
|
|
|
|
|
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #54263 is a reply to message #54253] |
Thu, 07 November 2002 10:49  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You have to setup your environment variables:
ORACLE_SID=
TNS_ADMIN= (if you are using one tnsnames.ora file for multiple Oracle homes. by default is $ORACLE_HOMEnetworkadmin)
You have more than one Oracle instances on your machine and by not using the TNS service name, you are confising Oracle which one to use. It's OK to connect with BEQ protocol if you have only one db instance. For more use:
c:>set oracle_sid=
or
$ORACLE_SID= ; export ORACLE_SID
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
