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

Frank Seuberth wrote:

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

I had a similar problem trying to connect form a unix box to a server on an NT box. I had to connect using _at_SID.world, rather than @SID.

>
>
>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 Tue Apr 23 2002 - 06:38:33 CEST