Re: ERROR: ORA-01034: ORACLE not available

That is great advice. I will try it right away.

John

Tommy wrote in message <3638C605.B555143A_at_yahoo.com>...
>Hi, John, you can try this :
>
>First, Check that there is not a subdirectory under $ORACLE_HOME
>with the same name as the SID.References
>
>Second, The ORACLE_PATH is being used to get the shared memory key instead
>of the
>ORACLE_HOME. You need to remove the ORACLE_PATH environment variable. To
>remove the variable:
>
> 1. Shutdown the database
> SVRMGR> shutdown immediate
>
> 2. Remove the ORACLE_PATH environment variable
> For C shell:
> % unsetenv ORACLE_PATH
>
> For Bourne or Korn shells:
> $ unset ORACLE_PATH
>
> 3. Start the database.
> SVRMGR> startup
>
> 4. Connect through SQL*Plus.
> % sqlplus <username>/<password>@<alias>
>
>Solution Explanation:
>=====================
>
>The solution allows the Oracle kernel to use ORACLE_HOME for the shared
>memory
>key. This is what SQL*Net also uses for the key.
>
>
>JMA wrote:
>
>> Date: October 28, 1998 02:59 PM
>> Author: John Arnott (jarnott_at_pdbs.com)
>> Subject: ORA-07429
>>
>> I receive the following error when calling sqlplus from a script.
>> ERROR: ORA-01034: ORACLE not available
>> ORA-07429: smsgsg: shmget() failed to get segment.
>> SVR4 Error: 2: No such file or directory
>>
>> When I make the same SQLplus call from the command line it works fine.
>>
>> I attempted to shutdown abort and restart, but it still fails. I also
>> completely recycled the server, but it still fails.
>>
>> Any ideas? Please email me with your thoughts.
>>
>> Thanks,
>>
>> John
>> jarnott_at_pdbs.com
>
>
>
Received on Thu Oct 29 1998 - 09:40:41 CST