need help please

From: Joe D <joed_at_icoms.com>
Date: Wed, 2 Feb 2000 14:49:35 -0500
Message-ID: <38988b55$1@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

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 - 13:49:35 CST