To find out what it is: In Windoze, type SET at the DOS prompt, in Unix, use the env command.
To set it, in Windoze type set ORACLE_SID=<WHATEVERYOU NAMEDYOURDATABASE>, in Unix, it depends on your shell, but you might try export ORACLE_SID =<WHATEVERYOUNAMEDYOURDATABASE>. Somehow, I think this will not completely solve your problems. To look up errors, as well as some troubleshooting guides, you might want to check out OTN (I'm not their flack - I was referred to it my a list member 5+ years ago and it's helped me immensely). http://otn.oracle.com It's free. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "S.Jyotinaraya n" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <ncjyoti@yahoo cc: .com> Subject: Re: Antwort: ORA - 12560: TNS: protocol adapter error Sent by: [EMAIL PROTECTED] om 11/12/2001 09:50 PM Please respond to 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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > <ncjyoti@yaho Kopie: > o.com> Thema: ORA - 12560: TNS: protocol adapter error > Gesendet von: > root@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: [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). _________________________________________________________ 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
