Re: need help please

Jeff,

    Thank you. I never saw the < > brackets. I looked and looked but never saw them.

Thank you,

Joey D

Jeff Hunter <jeffh_at_btitelecom.net> wrote in message news:38988eba_at_defiant.btitelecom.net...
> 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:10:01 CST