I doubt your sid is "<PSOMTX>". I would try just "PSOMTX". Also, if you
are on a unix version, I remember something about the SID being case
sensitive. You might want to check that out...
J
Joe D wrote in message <38988b55$1_at_News.Destek.net>...
>I am trying to make a sqlplus connection from one machine to another.
>
>The client machine has the following tnsnames.ora entry:
>
>"psomtx =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= server1.icoms.com)(Port= 1521))
> (CONNECT_DATA = (SID = <PSOMTX>))
> ) "
>
>This should be correct as far as SID and Host. There is no database on the
>client. This is
>the error I get while on the client and trying to connect to server1:
>
>"bash-2.00$ bin/sqlplus username/pass_at_psomtx
>
>SQL*Plus: Release 3.3.4.0.1 - Production on Wed Feb 2 14:26:53 2000
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>ERROR: ORA-12505: TNS:listener could not resolve SID given in connect
>descriptor"
>
>There is no listener on the client. The SID is correct for server1.
>
>Any thoughts?
>
>TIA
>
>Joey D
>
>
>
Received on Wed Feb 02 2000 - 14:07:47 CST
