Re: Antwort: ORA - 12560: TNS: protocol adapter error

The best advice!

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 13, 2001 3:00 AM

> Hire an Oracle DBA, I believe they are a few knocking about twiddling
their
> thumbs at the moment. :-)
>
>
>
> -----Original Message-----
> Sent: 13 November 2001 06:00
> To: Multiple recipients of list ORACLE-L
>
>
> Environment variable ORACLE_SID not defined is the message i get.
>
> What should i do?
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, November 13, 2001 10:40 AM
>
>
> > What OS r u using?
> >
> > If its Windows use the comman "set" and look for ORACLE_SID
> > If its Unix use the command "env | grep -i oracle_sid"
> >
> > Regards,
> >
> > Sujatha
> >
> > -----Original Message-----
> > Sent: Tuesday, 13 November 2001 2:50 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I am not sure if i have set ORACLE_SID, how could i check if it is set?
> >
> > If it is not set, how do i set it and i set it to what?
> >
> > Thanx in advance
> > Jyotinarayan
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, November 12, 2001 6:20 PM
> >
> >
> > >
> > > Hi
> > > did you set ORACLE_SID in your environment or registry?
> > > Ivo
> > >
> > >
> > >
> > >
> > > "S.Jyotinaray
> > > an" An: Multiple recipients
of
> > list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > <ncjyoti_at_yaho Kopie:
> > > o.com> Thema: ORA - 12560: TNS:
> > protocol adapter error
> > > Gesendet von:
> > > root_at_fatcity.
> > > com
> > >
> > >
> > > 11/12/2001
> > > 10:30 AM
> > > Bitte
> > > antworten an
> > > ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi,
> > > I have installed your Oracle 8i EE trial software.
> > >
> > > When i am trying to connect through SQLPLUS with username: SCOTT and
> > > password: TIGER i am getting the following error :-
> > > "ORA - 12560: TNS: protocol adapter error".
> > >
> > > Could you tell why i am getting this error?
> > >
> > > What other information should i provide you?
> > >
> > > Thanx in advance
> > > Jyotinarayan
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Ivo.Libal_at_knapp-systems.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).
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: S.Jyotinarayan
> > INET: ncjyoti_at_yahoo.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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sujatha Madan
> > INET: sujatha.madan_at_cmc.cwo.net.au
> >
> > 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).
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: S.Jyotinarayan
> INET: ncjyoti_at_yahoo.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).
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robertson Lee - lerobe
> INET: lerobe_at_acxiom.co.uk
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).