1 2 Previous Next 21 Replies Latest reply: Jul 18, 2011 3:14 PM by user11017933 RSS

    ORA-01034: ORACLE Not Available

    user11017933
      I am New to Oracle ,thanks first!

      The oracle 11g Database server(linux) was power off accidently, now try to restart it, but got errors:
      ora-01034 oracle not available
      ora-27101 shared memory realm does not exist

      Issued: lsnrctl start, (succesfully)
      What else need to startup the database?

      Any help appreciated!
        • 1. Re: ORA-01034: ORACLE Not Available
          sb92075
          user11017933 wrote:
          I am New to Oracle ,thanks first!

          The oracle 11g Database server(linux) was power off accidently, now try to restart it, but got errors:
          ora-01034 oracle not available
          ora-27101 shared memory realm does not exist

          Issued: lsnrctl start, (succesfully)
          What else need to startup the database?

          Any help appreciated!
          open Terminal Window & issue following commands EXACTLY as presented below

          id
          env | sort
          sqlplus
          / as sysdba
          shutdown abort
          startup
          exit

          COPY commands & results then PASTE all back here
          • 2. Re: ORA-01034: ORACLE Not Available
            user11017933
            [ehms@vbox1 ~]$ id
            uid=503(ehms) gid=503(ehms) groups=503(ehms) context=user_u:system_r:unconfined_t
            [ehms@vbox1 ~]$ env | sort
            _=/bin/env
            CVS_RSH=ssh
            G_BROKEN_FILENAMES=1
            HISTSIZE=1000
            HOME=/var/home/ehms
            HOSTNAME=vbox1.ttci.co
            INPUTRC=/etc/inputrc
            KDEDIR=/usr
            KDE_IS_PRELINKED=1
            KDE_NO_IPV6=1
            LANG=en_US.UTF-8
            LD_LIBRARY_PATH=/var/home/ehms/app/ehms/product/11.2.0/dbhome_1/lib
            LESSOPEN=|/usr/bin/lesspipe.sh %s
            LOGNAME=ehms
            LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
            MAIL=/var/spool/mail/ehms
            OLDPWD=/var/home/ehms/app/ehms/product/11.2.0/dbhome_1
            ORACLE_HOME=/var/home/ehms/app/ehms/product/11.2.0/dbhome_1
            ORACLE_SID=orcl
            ORAENV_ASK=NO
            PATH=/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/var/home/ehms/bin:/var/home/ehms/app/ehms/product/11.2.0/dbhome_1/bin
            PWD=/var/home/ehms
            QTDIR=/usr/lib64/qt-3.3
            QTINC=/usr/lib64/qt-3.3/include
            QTLIB=/usr/lib64/qt-3.3/lib
            SHELL=/bin/bash
            SHLVL=1
            SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
            SSH_CLIENT=150.195.11.229 40450 22
            SSH_CONNECTION=150.195.11.229 40450 150.195.8.47 22
            SSH_TTY=/dev/pts/2
            TERM=xterm
            USER=ehms
            [ehms@vbox1 ~]$ sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 15 10:56:45 2011

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

            Connected to an idle instance.

            SQL> shutdown abort
            ORACLE instance shut down.
            SQL> startup
            ORACLE instance started.

            Total System Global Area 3323752448 bytes
            Fixed Size          2217912 bytes
            Variable Size          2483030088 bytes
            Database Buffers     822083584 bytes
            Redo Buffers          16420864 bytes
            Database mounted.
            ORA-01172: recovery of thread 1 stuck at block 176 of file 3
            ORA-01151: use media recovery to recover block, restore backup if needed
            • 3. Re: ORA-01034: ORACLE Not Available
              user11017933
              SQL>shutdown immediate
              SQL>Startup mount
              SQL>ALTER DATABASE RECOVER;

              but the recover is lasting forever, any ideas?
              • 4. Re: ORA-01034: ORACLE Not Available
                sybrand_b
                What you need to do is in the last error message you posted earlier. You need to restore the database, at least you need to restore datafile 3. Only then alter database recover will work.

                -----------
                Sybrand Bakker
                Senior Oracle DBA
                • 5. Re: ORA-01034: ORACLE Not Available
                  user11017933
                  Then that's a problem, I do not have backup file(good lesson, thanks).

                  now what's next? Thanks!!
                  • 6. Re: ORA-01034: ORACLE Not Available
                    user11017933
                    Is there a way to solve the problem without backup?

                    sql> conn / as sysdba
                    onnected to an idle instance.

                    SQL> select * from dual;

                    ERROR at line 1:
                    ORA-01034: ORACLE not available
                    Process ID: 0
                    Session ID: 0 Serial number: 0

                    Thanks.

                    Edited by: user11017933 on Jul 18, 2011 9:28 AM

                    Edited by: user11017933 on Jul 18, 2011 9:30 AM
                    • 7. Re: ORA-01034: ORACLE Not Available
                      CKPT
                      user11017933 wrote:
                      Is there a way to solve the problem without backup?

                      sql> conn / as sysdba
                      onnected to an idle instance.

                      SQL> select * from dual;

                      ERROR at line 1:
                      ORA-01034: ORACLE not available
                      Process ID: 0
                      Session ID: 0 Serial number: 0
                      Error: ORA 1151
                      Text: use media recovery to recover block, restore backup if needed
                      -------------------------------------------------------------------------------
                      Cause: Crash recovery or instance recovery could not apply a change to a
                      block because it was not the next change.
                      This can happen if the block was corrupted and then repaired during
                      recovery.
                      This message is usually accompanied by ORA-01172.
                      Action: There is additional information for ORA-01172.
                      Perform a RECOVER datafile for the file containing the block.
                      If this does not resolve the problem, restore the file from a backup
                      and recover it again.
                      • 8. Re: ORA-01034: ORACLE Not Available
                        user11017933
                        Thanks so much for your help!

                        Could you show me how to restore, and I don't think there is a RMAN setup?

                        Edited by: user11017933 on Jul 18, 2011 9:54 AM
                        • 9. Re: ORA-01034: ORACLE Not Available
                          CKPT
                          Could you show me how to restore, and I don't think there is a RMAN setup?
                          do you have any User managed backup or RMAN backup?
                          then you can restore the database, until you have the archives.
                          • 10. Re: ORA-01034: ORACLE Not Available
                            user11017933
                            That's the problem, I do not have RMAN backup, no datafile backup.

                            Still, is there a way to get the database back? Thanks.

                            Could you tell me what is the best solution if recover does not work, how about drop the datafile, try to open the database, then create a new schema with the existing data structure?

                            Edited by: user11017933 on Jul 18, 2011 10:08 AM
                            • 11. Re: ORA-01034: ORACLE Not Available
                              CKPT
                              That's the problem, I do not have RMAN backup, no datafile backup.

                              Still, is there a way to get the database back? Thanks.

                              Could you tell me what is the best solution if recover does not work, how about drop the datafile, try to open the database, then create a new schema with the existing data structure?
                              by dropping the datafile you can open the database. There will be no lost for user, but the objects contain of that schema which exist in dropped datafile will be lost.
                              • 12. Re: ORA-01034: ORACLE Not Available
                                rajeysh
                                please post the output here,

                                SQL>startup mount

                                SQL> select name,status,enabled from v$datafile where file#=3;
                                • 13. Re: ORA-01034: ORACLE Not Available
                                  user11017933
                                  SQL> startup mount
                                  ORACLE instance started.

                                  Total System Global Area 3323752448 bytes
                                  Fixed Size          2217912 bytes
                                  Variable Size          2483030088 bytes
                                  Database Buffers     822083584 bytes
                                  Redo Buffers          16420864 bytes
                                  Database mounted.
                                  SQL> select name, status,enabled from v$datafile where file#=3;

                                  NAME
                                  --------------------------------------------------------------------------------
                                  STATUS     ENABLED
                                  ------- ----------
                                  /var/home/ehms/app/ehms/oradata/orcl/undotbs01.dbf
                                  ONLINE     READ WRITE
                                  • 14. Re: ORA-01034: ORACLE Not Available
                                    CKPT
                                    SQL> select name, status,enabled from v$datafile where file#=3;

                                    NAME
                                    --------------------------------------------------------------------------------
                                    STATUS     ENABLED
                                    ------- ----------
                                    /var/home/ehms/app/ehms/oradata/orcl/undotbs01.dbf
                                    ONLINE     READ WRITE
                                    how the status is ONLINE? if corrupted.

                                    try once again.

                                    SQL> alter database open;

                                    or you can drop the undo data file.
                                    1 2 Previous Next