Xref: alice comp.databases.oracle.server:83108
From: "Joe D" <joed@icoms.com>
Newsgroups: comp.databases.oracle.server
References: <38988b55$1@News.Destek.net> <38988eba@defiant.btitelecom.net>
Subject: Re: need help please
Date: Wed, 2 Feb 2000 15:10:01 -0500
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <38989027$1@News.Destek.net>
X-Trace: 2 Feb 2000 20:14:31 GMT, backdev.icoms.com
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!News.Destek.net!backdev.icoms.com

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

Thank you,

Joey D


Jeff Hunter <jeffh@btitelecom.net> wrote in message
news:38988eba@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@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
> >
> >
> >
>
>