Oracle-L: Re: [Q] create seperate DBA account on 8.1.7 but does NOT work?

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Mon, 27 Jan 2003 09:24:43 -0800
Message-ID: <F001.0053B3F6.20030127092443@fatcity.com>

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 <mccdba_at_hotmail.com> 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: mccdba_at_hotmail.com
>
> 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: 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!?
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: barbarabbaker_at_yahoo.com

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: 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 Mon Jan 27 2003 - 11:24:43 CST