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

[Quoted] [Quoted] Good advice, also how are hostnames being resolved from a host name like "sun01" to 134.xxx.xxx.xxx IP addresses? I know, that "shouldn't" make a difference.

Also, try this at the SQL*PLUS SQL > prompt after your connect fails

connect username/password_at_aaa.bbb.ccc.ddd:SID

where the a/b/c/d stuff is the IP address of the server and the SID is the database you're trying to get to and see what happens.

If that works, it points more strongly at either a problem in your SQL*NET, er NET*8 files as Glen suggested, OR a goofy problem in HOST<--->IP resolution, which I've had from time to time myself, when the data center people insist on overcomplicating things. DNS, Oracle Names, Oracle's Automatic Discovery, ANS and so forth can all complicate things.

So I usually start off by checking if I have an accurate LMHOSTS (for NT) or /etc/hosts file, and PING (tcp/ip ping) by hostname, THEN do a tnsping to test the database layer (which sounds like you're through those woods already anyway).

But try that little trick with SQL*PLUS and see what it does. I'd be curious.

RSH.
"Glen A Stromquist" <gstromquist_at_nospamyahoo.com> wrote in message news:1zWw8.10413$n%4.564717_at_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 - 18:32:48 CEST