Xref: alice comp.databases.oracle.server:83101
From: "Joe D" <joed@icoms.com>
Newsgroups: comp.databases.oracle.server
Subject: need help please
Date: Wed, 2 Feb 2000 14:49:35 -0500
Lines: 33
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: <38988b55$1@News.Destek.net>
X-Trace: 2 Feb 2000 19:53:57 GMT, backdev.icoms.com
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!newsfeed.cwix.com!News.Destek.net!backdev.icoms.com

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