unable to connect using @

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,

Oracle LazyDBA home page