Re: HELP- SQL*PLUS on PC could NOT connect to Oracle on Sun

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Thu, 25 Apr 2002 10:02:06 +0000 (UTC)
Message-ID: <fdd9be1813cc4c9bfa61c7e034435180.20305@mygate.mailgate.org>

"Mario King" <hliji_at_usa.net> wrote in message news:1ba32e56.0204220750.754e7e11_at_posting.google.com...

> Hi,
>
> I installed Oracle client software on my PC (including ODBC, Net8 and
> SQL*PLUS). My oracle server is on Sun. I could make ODBC and Net8 working
> - from ODBC testing tool, I could send query to Oracle. BUT the SQL*PLUS
> could NOT connect to Oracle. It gave me error saying "Service Name is
> not recognized". On ODBC, I set up a data source using right SID and
> Service Name. It seems that SQL*PLUS didn't use this data source. How
> do you configure it to accept SID and Service Name of Oracle server?

Hi,

perhaps you have two versions of Net8/SQL-Net, search for tnsnames.ora, if there are more of them, because the ODBC might use another sqlnet/net8 as yozur SQL*Plus

If there is only one tnsnames.ora:

See your ODBC-aliases, what is the value for the sid-entry (not the odbc-alias !)

Then: tnsping sid_entry

Hth
Thomas

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Thu Apr 25 2002 - 05:02:06 CDT