1. If you are using .world in tnsnames or listner.ora remove .world and try.
2. Try checking the syntex, make sure there is no space after brackets in tnsnames.

Krishna


>>> "Kerber Andrew " <oracledba-ezmlmshield-x60474901.[Email address protected] 07/31/06 10:37 AM >>>
Looks like you have a problem with either tnsnames.ora or listener.ora on your database box. You need to check those over and make sure that the database you want to connect to is listed in both files. The directory is $ORACLE_HOME/tns/admin (if you are on a Unix server).



-----Original Message-----

From: si

[mailto:oracledba-ezmlmshield-x11717265.[Email address protected]

Sent: Monday, July 31, 2006 10:33 AM

To: LazyDBA Discussion

Subject: unable to connect using @<sid>





hello, all,



i have 2 10g instances on a single server. i can connect using sqlplus

with <user>/<password> but cannot using <user>/<password>@<sid>.

however, i can do so from an sqlplus session on a remote box. the error

message is as follows:



ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.



any leads to what i should look at would be appreciated.



regards,





--------

website: http://www.LazyDBA.com

Please don't reply to RTFM questions

Oracle documentation is here: http://tahiti.oracle.com

To unsubscribe: see http://www.lazydba.com/unsubscribe.html

To subscribe: see http://www.lazydba.com

By using this list you agree to these terms:http://www.lazydba.com/legal.html





-----------------------------------------

CONFIDENTIALITY NOTICE



This message and any attachments are from the NAIC and are intended

only for the addressee. Information contained herein is

confidential, and may be privileged or exempt from disclosure

pursuant to applicable federal or state law. This message is not

intended as a waiver of the confidential, privileged or exempted

status of the information transmitted. Unauthorized forwarding,

printing, copying, distribution or use of such information is

strictly prohibited and may be unlawful. If you are not the

addressee, please promptly delete this message and notify the

sender of the delivery error by e-mail or by calling the NAIC Help

Desk at (816)783-8500.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page