4 Replies Latest reply: Jun 28, 2013 6:56 PM by Bobby Durrett RSS

    ORA-01034: ORACLE not available

    HuaMin Chen

      Hi,

      I've got this error. How to resolve it?

       

      SQL> conn system

      Enter password:

      ERROR:

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

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

      Process ID: 0

      Session ID: 0 Serial number: 0

       

      Many Thanks & Best Regards,

      HuaMin

        • 1. Re: ORA-01034: ORACLE not available
          sybrand_b

          Consult the alert log.

           

          And, please, STOP asking these type of questions.

           

          This forum doesn't consist of babysitters and doesn't do your work for free,

           

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

          Sybrand Bakker

          Senior Oracle DBA

          • 2. Re: ORA-01034: ORACLE not available
            Ed Rudans

            Always check error description,. it will help you to with troubleshooting

            http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm

            Error:  ORA 1034

            Text:   Oracle not available

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

            Cause:  Oracle was not started up.

                    Possible causes include the following:

                    The SGA requires more space than was allocated for it.

                    The operating system variable pointing to the instance was improperly

                    defined.

            Action: Refer to accompanying messages for possible causes and correct the

                    problem mentioned in the other messages.

                    Retry after Oracle has been initialized.

                    If Oracle has been initialized, then on some operating systems, verify

                    that Oracle was linked correctly.

                    See the platform-specific Oracle documentation.

             

            Regards

            Ed

            • 3. Re: ORA-01034: ORACLE not available
              SANCHITGUPTA

              guru is asking this type of question.... may be there is any big issue,

               

              paste the last 20 lines of your alert log file.

              • 4. Re: ORA-01034: ORACLE not available
                Bobby Durrett

                $export ORACLE_SID=abc
                $sqlplus xyz/pdq

                SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jun 28 18:54:34 2013

                (c) Copyright 2000 Oracle Corporation.  All rights reserved.

                ERROR:
                ORA-01034: ORACLE not available
                ORA-27101: shared memory realm does not exist
                HP-UX Error: 2: No such file or directory


                Database is down or you have the wrong environment variables, probably the latter.

                 

                - Bobby