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" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >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@itsp, the connect works >fine. >But when I try to connect to that same database >from my windows client, >using user/pw@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
