When you bring up a database, a combination of the ORACLE_SID and ORACLE_HOME environment variables are hashed to a key and stored in memory. When you attempt to connect to the database, this hash key is verified.
Therefore your current environment for ORACLE_SID and ORACLE_HOME must match EXACTLY the environment of the user that brought up the database. Exactly down to every single slash and upper/lower case character. Check your current environment for these variables to insure that they matche exactly the environment when the database came up. Good luck! Barb --- dist cash <[EMAIL PROTECTED]> wrote: > we plan to upgrade ORACLE 8.1.7 to 9.2 on SUN > Solaris server. I plan to > upgade to 9.2 use "oracle" account and keep 8.1.7 on > "ora817" account. I > create user "ora817" and assign it to "dba" group. > I also setup ORACLE > environment similiar to "oracle" account. I tried > to startup > "sqlplus" but failed. > > > > %setenv ORACLE_SID db00 > %sqlplus > > SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jan > 27 10:49:41 2003 > > (c) Copyright 2000 Oracle Corporation. All rights > reserved. > > Enter user-name: user1 > Enter password: > ERROR: > ORA-01034: ORACLE not available > ORA-27101: shared memory realm does not exist > SVR4 Error: 2: No such file or directory > > > > Does anyone know why? > > > Thanks. > > > > > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months > FREE*. > http://join.msn.com/?page=features/virus > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).