Re: ERROR: ORA-01034: ORACLE not available

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 - 13:46:13 CST