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.


Oracle LazyDBA home page