Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP- SQL*PLUS on PC could NOT connect to Oracle on Sun

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

From: Mario King <hliji_at_usa.net>
Date: 22 Apr 2002 08:50:54 -0700
Message-ID: <1ba32e56.0204220750.754e7e11@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 - 10:50:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US