The SID specified in the connect string in your local tnsnames.ora does not
match the SID specified in the listener.ora of the remote machine.
Posting both definitions would help to diagnose ...
Also check the port numbers.
> ----------
> From: Veera Prasad[SMTP:vprasad_at_olf.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, May 30, 2000 19:46
> To: Multiple recipients of list ORACLE-L
> Subject: listener.ora and tnsnames.ora
>
>
>
> oracle_at_oracle: sqlplus vprasad/vprasad_at_taj
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Tue May 30 12:17:00 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12505: TNS:listener could not resolve SID given in connect descriptor
>
> CAN anybody tell me why am I getting this ? I did check listener.ora and
> tnsnames.ora files everything look good to me , but still I get the above
> error.
>
Received on Tue May 30 2000 - 12:16:45 CDT
