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

I normaly do the following Steps :
Try a tnsping
[Quoted] [Quoted] When this works all the other stuff works. [Quoted] Also look how the listner on the SUN is configured. Perhaps you should try it with a suffix behindthe SID like SID.world

Frank

RSH schrieb:
>
> 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 - 19:46:37 CEST