1 2 Previous Next 18 Replies Latest reply: Jan 4, 2012 4:58 AM by Shivananda Rao RSS

    Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory

    Yasir Iqbal
      Dear All,
      I am a new DBA. I have installed the Oracle 11G database on Redhat 5.0. The database is running fine. But today suddenly the database stop working. When I logon on sqlplus start the database. It gives me the following error.

      ORA-03113:end-of-file on communication channel
      Process ID: 3045
      Session ID: 125 Serial number" 5

      More when i try to connect to the database through application server. It gives me the following error. Help is required.

      ORA-01034: Oracle not available ORA-27101:share memory realm does not exit Linux Error:2 No such file of Directory.

      Please help me
        • 1. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
          CKPT
          When database is not available, You wont get any connection from client machine also.

          Check the alert log file, and paste the contents here when you try to start database.
          • 2. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
            Shivananda Rao
            ORA-01034: Oracle not available
            Check if your database is up and running
            • 3. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
              Helios-GunesEROL
              Hi;

              1. Please check your system up or not. Run

              ps -ef|grep pmon

              If its bring something than be sure you set your ORACLE_HOME and ORACLE_SID before connecting sqlplus

              2. Also check your alert.log for any error&reboot message

              Regard
              Helios
              • 4. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                EdStevens
                user12185639 wrote:
                Dear All,
                I am a new DBA. I have installed the Oracle 11G database on Redhat 5.0. The database is running fine. But today suddenly the database stop working. When I logon on sqlplus start the database. It gives me the following error.

                ORA-03113:end-of-file on communication channel
                Process ID: 3045
                Session ID: 125 Serial number" 5

                More when i try to connect to the database through application server. It gives me the following error. Help is required.

                ORA-01034: Oracle not available ORA-27101:share memory realm does not exit Linux Error:2 No such file of Directory.

                Please help me
                While it's good that you showed us the actual error message (many people just give their interpretation of it) it would have been far more informative if you had shown us the actual command you used when starting and connecting with sqlplus, as well as the error response. Even more if you would also show the results of
                {code}
                env|sort
                {code}

                My guess is some key environment variables not properly set to get started with sqlplus. But we'd need to see all of what I've mentioned to make a better diagnosis.
                • 5. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                  Yasir Iqbal
                  Dear EdStevens .
                  Here is the output when i logon on the system and connect sqlplus.


                  SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 02:12:42 2011

                  Copyright (c) 1982, 2009, Oracle. All rights reserved.

                  Enter user-name: / as sysdba
                  Connected to an idle instance.

                  SQL> startup;
                  ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
                  ORACLE instance started.

                  Total System Global Area 610992128 bytes
                  Fixed Size          1338224 bytes
                  Variable Size          452986000 bytes
                  Database Buffers     150994944 bytes
                  Redo Buffers          5672960 bytes
                  Database mounted.
                  ORA-03113: end-of-file on communication channel
                  Process ID: 4967
                  Session ID: 125 Serial number: 5
                  • 6. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                    Yasir Iqbal
                    Dear EdStevens ,
                    When i connect to sqlplus and try to start the database. It gives me the following error. Help is required.

                    Copyright (c) 1982, 2009, Oracle. All rights reserved.

                    Enter user-name: / as sysdba
                    Connected to an idle instance.

                    SQL> startup;
                    ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
                    ORACLE instance started.

                    Total System Global Area 610992128 bytes
                    Fixed Size          1338224 bytes
                    Variable Size          452986000 bytes
                    Database Buffers     150994944 bytes
                    Redo Buffers          5672960 bytes
                    Database mounted.
                    ORA-03113: end-of-file on communication channel
                    Process ID: 4967
                    Session ID: 125 Serial number: 5


                    SQL> shutdown immediate;
                    ORA-24324: service handle not initialized
                    ORA-01041: internal error. hostdef extension doesn't exist
                    SQL> startup;
                    ORA-24324: service handle not initialized
                    ORA-01041: internal error. hostdef extension doesn't exist
                    SQL>
                    • 7. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                      Yasir Iqbal
                      Here is my aler.log file end part.


                      <txt>Errors in file /oracle/app/oracle/admin/udump/diag/rdbms/seecnust/seecnust/trace/seecnust_ora_4967.trc:
                      ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
                      ORA-01264: Unable to create archived log file name
                      ORA-19800: Unable to initialize Oracle Managed Destination
                      Linux Error: 13: Permission denied
                      </txt>
                      </msg>
                      <msg time='2011-12-30T02:13:00.427-05:00' org_id='oracle' comp_id='rdbms'
                      client_id='' type='UNKNOWN' level='16'
                      host_id='seecserpdb.edu.pk' host_addr='10.3.20.31' module='sqlplus@seecserpdb.edu.pk (TNS V1-V3)'
                      pid='4967'>
                      <txt>Errors in file /oracle/app/oracle/admin/udump/diag/rdbms/seecnust/seecnust/trace/seecnust_ora_4967.trc:
                      ORA-16038: log 1 sequence# 803 cannot be archived
                      ORA-00312: online log 1 thread 1: &apos;/oracle/app/oracle/oradata/seecnust/redo01.log&apos;
                      ORA-00312: online log 1 thread 1: &apos;/oracle/app/oracle/oradata/seecnust/redo04.log&apos;
                      ORA-00312: online log 1 thread 1: &apos;/oracle/app/oracle/oradata/seecnust/redo05.log&apos;
                      ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
                      ORA-01264: Unable to create archived log file name
                      ORA-19800: Unable to initialize Oracle Managed Destination
                      Linux Error: 13: Permission denied
                      </txt>
                      </msg>
                      <msg time='2011-12-30T02:13:00.427-05:00' org_id='oracle' comp_id='rdbms'
                      client_id='' type='UNKNOWN' level='16'
                      host_id='seecserpdb.edu.pk' host_addr='10.3.20.31' module='sqlplus@seecserpdb.edu.pk (TNS V1-V3)'
                      pid='4967'>
                      <txt>USER (ospid: 4967): terminating the instance due to error 16038
                      </txt>
                      </msg>
                      <msg time='2011-12-30T02:13:00.453-05:00' org_id='oracle' comp_id='rdbms'
                      msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
                      level='16' host_id='seecserpdb.edu.pk' host_addr='10.3.20.31'
                      pid='4973'>
                      <txt>ARC2 started with pid=22, OS id=4973
                      </txt>
                      </msg>
                      <msg time='2011-12-30T02:13:01.835-05:00' org_id='oracle' comp_id='rdbms'
                      client_id='' type='UNKNOWN' level='16'
                      host_id='seecserpdb.edu.pk' host_addr='10.3.20.31' module='sqlplus@seecserpdb.edu.pk (TNS V1-V3)'
                      pid='4967'>
                      <txt>Instance terminated by USER, pid = 4967
                      </txt>
                      </msg>
                      • 8. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                        Shivananda Rao
                        ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
                        ORA-01264: Unable to create archived log file name
                        ORA-19800: Unable to initialize Oracle Managed Destination
                        Linux Error: 13: Permission denied
                        The location specified in the log_archive_dest_1 is not having appropriate permissions which is preventing oracle to generate an archive and hence you are facing the issue.

                        Provide the write permission to the destination mentioned in the log_archive_dest_1
                        • 9. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                          Yasir Iqbal
                          Dear,
                          Can you tell me the location of the log_archive_dest_1 and procedure.
                          • 10. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                            Shivananda Rao
                            You would get the location in the pfile. If you do not have the pfile and if you are trying to start the database using spfile, then you can get the value using
                            show parameter log_archive_dest_1
                            • 11. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                              908220
                              Try creating pfile with the command:

                              create pfile from spfile

                              Once the pfile is created find the value of log_archive_dest_1 and modify it for a valid one (you need to give a location where the oracle user has permmisions of reading and writing).

                              And try starting up the instance with the pfile.

                              startup pfile='/u01/app/oracle/product/...'

                              Regards.

                              Gonzo
                              • 12. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                                Yasir Iqbal
                                Dear,
                                When i give the command create pfile from spfile. It gives me the following error.


                                SQL> create pfile from spfile;
                                create pfile from spfile
                                *
                                ERROR at line 1:
                                ORA-01565: error in identifying file '?/dbs/spfile@.ora'
                                ORA-27037: unable to obtain file status
                                Linux Error: 2: No such file or directory
                                Additional information: 3

                                Please tell me what to do next.
                                • 13. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                                  Shivananda Rao
                                  SQL> create pfile from spfile;
                                  create pfile from spfile
                                  *
                                  ERROR at line 1:
                                  ORA-01565: error in identifying file '?/dbs/spfile@.ora'
                                  ORA-27037: unable to obtain file status
                                  Linux Error: 2: No such file or directory
                                  You are trying to create a pfile when your database is down.

                                  If you have the pfile already created, then just change the location of log_archive_dest_1 to the path which has the read and write permission to oracle user.

                                  If you do not have a pfile, then
                                  sqlplus sys/<password>@<connect string> as sysdba
                                  startup nomount
                                  create pfile from spfile;
                                  shut immediate
                                  Once you get the pfile from the above execution, make changes in the pfile and later start the database using the new modified pfile
                                  sqlplus sys/<password>@<connect string> as sysdba
                                  startup pfile=<modified pfile location>
                                  • 14. Re: Database Server 11G ORA-01034: Oracle not available ORA-27101:share memory
                                    sb92075
                                    srp wrote:
                                    SQL> create pfile from spfile;
                                    create pfile from spfile
                                    *
                                    ERROR at line 1:
                                    ORA-01565: error in identifying file '?/dbs/spfile@.ora'
                                    ORA-27037: unable to obtain file status
                                    Linux Error: 2: No such file or directory
                                    You are trying to create a pfile when your database is down.
                                    Comments, after seeing below?
                                    bcm@bcm-laptop:~$ sqlplus
                                    
                                    SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 18:04:41 2011
                                    
                                    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                                    
                                    Enter user-name: / as sysdba
                                    
                                    Connected to:
                                    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                                    
                                    SQL> shutdown immediate
                                    Database closed.
                                    Database dismounted.
                                    ORACLE instance shut down.
                                    SQL> set time on
                                    18:05:10 SQL> create pfile from spfile;
                                    
                                    File created.
                                    
                                    18:05:20 SQL> startup
                                    ORACLE instance started.
                                    
                                    Total System Global Area 1553305600 bytes
                                    Fixed Size              2213656 bytes
                                    Variable Size            922749160 bytes
                                    Database Buffers       620756992 bytes
                                    Redo Buffers              7585792 bytes
                                    Database mounted.
                                    Database opened.
                                    18:05:35 SQL> 
                                    1 2 Previous Next