Tuesday, February 2, 2021

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

 When you were trying to connect to your Oracle database, you received the following errors.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3640

Additional information: 2007875791

Process ID: 0

Session ID: 0 Serial number: 0


Here are the steps to fix it.

SQL>sqlplus /NOLOG

SQL> connect / as sysdba;

SQL> SHUTDOWN IMMEDIATE

                 You may get the error message again. 

        ERROR:

         ORA-01034: ORACLE not available

        ORA-27101: shared memory realm does not exist

        Linux-x86_64 Error: 2: No such file or directory

        Additional information: 3640

        Additional information: 2007875791

        Process ID: 0

        Session ID: 0 Serial number: 0

SQL> STARTUP

ORACLE instance started.

-----------------------------------------------------------------------------------------------------------------


If you have ever asked the questions below, you will benefit from reading this book.
What is the meaning of life?
Why do I have to suffer?
How can I have the life I like to have?
How can I be the person I want to be?
How can I have good and harmonious relations with others?

What is the true meaning of spiritual practice?  Check it out here.