Re: ORA-01034 and ORA-01034, if starting oracle from script

From: Thomas Gaines <Thomas.Gaines_at_noaa.gov>
Date: Thu, 08 Jul 2004 09:20:35 -0600
Message-ID: <ccjom5$631$1@boulder.noaa.gov>

cyril wrote:

>>What are you seeing in your spooled files?
>>
>>
>
>SQL> shutdown immediate;
>ORA-01034: ORACLE not available
>ORA-27101: shared memory realm does not exist
>Linux Error: 2: No such file or directory
>SQL> spool off
>
>
>

Yep, this certainly looks like an environmental variable issue to me. I saw a very similar (if not downright identical - I can't recall the exact error) just last week on Red Hat Enterprise Linux when the $ORACLE_HOME variable was set to a symbolic link that pointed to the real Oracle home. While I suppose that should've worked, it didn't. I set $ORACLE_HOME to the actual Oracle home directory and everything started up just fine. It appears that Oracle does not like $ORACLE_HOME being a symbolic link. Maybe that's written somewhere, but it's not worth pursuing, IMO. I've got other things that are more pressing.

Thanks,
TG Received on Thu Jul 08 2004 - 10:20:35 CDT