RE: Weird connection behavior

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 08 Feb 2002 05:21:54 -0800
Message-ID: <F001.00409F0D.20020208050823@fatcity.com>

You can get this message when the ORACLE_HOME is wrong in the listener.ora file; I am unsure about a wrong ORACLE_SID (CONNECT_DATA) in the tnsnames.ora file, it may be this message or another one.
FYI there is a fairly complete list of what can go wrong and why with SQL*Net in the 'SQL*Net primer' paper in the 'First Steps' section of the Oriole site (URL below).

>----- Original Message -----
>From: "Daiminger, Helmut"
><Helmut.Daiminger_at_KirchGruppe.de>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Fri, 08 Feb 2002 03:48:18
>
>Hi!
>
>I'm experiencing a weird behavior here: when I try
>to connect to an Instance
>- named ITSP - (I am locally on the server):
>user/pw_at_itsp, the connect works
>fine.
>But when I try to connect to that same database
>from my windows client,
>using user/pw_at_itsp, I get the message: Oracle not
>available.
>
>Any idea what is going on here?
>
>This is 8.1.7 on Sun Solaris.
>
>Thanks,
>Helmut
>

Stephane Faroult
Oriole Corporation
Performance Tools & Free Scripts

---

http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Feb 08 2002 - 07:21:54 CST