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

From: Glen A Stromquist <gstromquist_at_nospamyahoo.com>
Date: Mon, 22 Apr 2002 16:07:25 GMT
Message-ID: <1zWw8.10413$n%4.564717@news2.telusplanet.net>

check your tnsnames.ora file(s) for the correct entry - did you set it up with net8 config assistant?

hth

"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?
Received on Mon Apr 22 2002 - 11:07:25 CDT