Xref: alice comp.databases.oracle.server:83104
From: "Jeff Hunter" <jeffh@btitelecom.net>
Newsgroups: comp.databases.oracle.server
References: <38988b55$1@News.Destek.net>
Subject: Re: need help please
Date: Wed, 2 Feb 2000 15:07:47 -0500
Lines: 41
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <38988eba@defiant.btitelecom.net>
X-Trace: 2 Feb 2000 15:08:26 -0500, webpool.btitele.com
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!tank.news.pipex.net!pipex!uunet!ams.uu.net!ffx.uu.net!defiant.btitelecom.net!webpool.btitele.com

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@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@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
>
>
>