Hi,
The search order for tnsnames.ora is the directory pointed to by TNS_ADMIN,
the directories in your PATH, and finally the directory
"ORACLE_HOME\network\admin". In your case, TNS_ADMIN points to it. Verify
this by renaming the other 2 and attempt to connect.
If you are in sqlplus on a client and connected, then to connect as another
user you must use "connect <username>/<password>@<service>". If you leave
off the <service> ("connect string" from tnsnames.ora), you are attempting
an "internal" connection which will not work on the client. This is the same
reason you must supply the <service> when initially starting sqlplus.
HTH,
~Dan.
-----Original Message-----
From: Thirumudi, Dhodduraj [mailto:Dhodduraj.[Email Address Removed] Thursday, May 31, 2001 4:13 AM
To: LazyDBA.com Discussion
Subject: Ora-12203 TNS Unable to Connect - Urgent
Hi DBA's,
One of my client has Oracle client 8.0.5 installed. When I execute
PLUS80.EXE, and enter the login,password and connect string I could logon to
sqlplus successfully. After loging on, if I use CONNECT to connect to other
user in the same instance I am getting ORA-12203 TNS unable to connect to
destination.
I have TNSNAMES.ORA under 2 folders
i.e. C:\ORANT\NETWORK
as well as in C:\ORANT\NET80.
Also we have a common share folder having TNSNAMES.ORA which is referred in
registry (TNS_ADMIN).Which TNSNAMES.ORA file among these will be used by
SQLPLUS.
How to resolve this issue. In what way SQLPLUS refer the TNSNAMES.ORA file.
What is the order of reference.
Thanks,
With Regards,
Thirumudi Dhodduraj .
Database Administrator - APD(GBS)
COMPAQ COMPUTER ASIA/PACIFIC PTE LTD
SINGAPORE.
Phone (65) 580 5245
Pager 580 5224
Fax (65) 580 5227
Dhodduraj.[Email Address Removed] documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page