{"id":3595,"date":"2013-02-06T16:50:19","date_gmt":"2013-02-06T21:50:19","guid":{"rendered":"https:\/\/pitss.org\/us\/2013\/02\/06\/oracle-database-constantly-shuts-down-with-ora-00600-errors\/"},"modified":"2017-05-15T15:09:43","modified_gmt":"2017-05-15T19:09:43","slug":"oracle-database-constantly-shuts-down-with-ora-00600-errors","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2013\/02\/06\/oracle-database-constantly-shuts-down-with-ora-00600-errors\/","title":{"rendered":"Oracle Database Constantly Shuts Down with ORA-00600 Errors"},"content":{"rendered":"

After either a database, hardware, or power failure, there are some cases where the database is unable to perform normal functions due to errors such as ORA-01033 (See https:\/\/pitss.org\/us\/2013\/01\/11\/ora-01333-error-occurs-in-oracle-database-after-pc-crash\/<\/a> for more information). If the steps applied in the mentioned KB article as well as the traditional \u201cshutdown immediate\u201d and \u201cstartup\u201d DB commands fail and you receive the following error below when trying to log into your database:<\/p>\n

\"clip_image002\"<\/a><\/p>\n

Also, if the database instance constantly shuts down randomly with errors such as:<\/p>\n

\"image\"<\/a><\/p>\n

It is possibly that the UNDO tablespace may be corrupted. To fix the problem, you can follow the following steps:<\/p>\n

    \n
  1. Start up the database instance if it is not up (Run \u201cstartup;” in SQLPLUS).<\/li>\n
  2. Run in SQLPLUS:\n
      \n
    • create pfile from spfile;<\/li>\n<\/ul>\n<\/li>\n
    • Run in SQLPLUS:\n
        \n
      • shutdown immediate; (if you get an error, exit SQLPLUS and reconnect. Then run \u201cshutdown abort;\u201d)<\/li>\n<\/ul>\n<\/li>\n
      • Go to the location where your pfile is located. If using the default location, it should be in %ORACLE_HOME%\\product\\11.2.0\\dbhome_1\\database. The file is called INIT<SID>.ORA (Example: INITorcl.ORA).<\/li>\n
      • Make a backup of this .ORA file.<\/li>\n
      • Open INIT<SID>.ORA in a text editor.<\/li>\n
      • Make the following changes in the file:\n
          \n
        • *.undo_management = manual<\/li>\n
        • *.event = \u201810513 trace name context forever, level 2\u2019<\/li>\n<\/ul>\n<\/li>\n
        • Save and close the file<\/li>\n
        • Log into SQLPLUS and run:\n
            \n
          • startup restrict pfile=\u2019%PATH_TO_PFILE%\\INIT<SID>.ORA\u2019;<\/li>\n<\/ul>\n<\/li>\n
          • Run in SQLPLUS:\n
              \n
            • select tablespace_name, status, segment_name from dba_rollback_segs where status !=\u2019OFFLINE\u2019;<\/li>\n<\/ul>\n<\/li>\n
            • When running the command in step 10, make sure that only SYSTEM appears to be online. If any segments are \u201cPARTLY AVAILABLE\u201d or \u201cNEEDS RECOVERY\u201d, you will need to create an SR at Oracle Support (Metalink) for this. Otherwise, skip this step.<\/li>\n
            • Create a new tablespace in SQLPLUS:\n
                \n
              • create undo tablespace <name of new undo tablespace> datafile <name of new datafile> size <size of tablespace><\/li>\n
              • Example: create undo tablespace UNDOTBS02 datafile UNDOTBS02.DBF size 2000M;<\/li>\n<\/ul>\n<\/li>\n
              • (Optional): You may delete the old corrupted tablespace:\n
                  \n
                • drop tablespace <old undo tablespace> including contents and datafiles;<\/li>\n<\/ul>\n<\/li>\n
                • Shutdown the DB:\n
                    \n
                  • shutdown immediate;<\/li>\n<\/ul>\n<\/li>\n
                  • Startup the DB in mount mode:\n
                      \n
                    • startup mount;<\/li>\n<\/ul>\n<\/li>\n
                    • Return to the directory in step 4 and update the INIT<SID>.ORA file and specify the new undo tablespace created in step 12 in the *.undo_tablespace parameter. Alternatively, you can also run:\n
                        \n
                      • alter system set undo_tablespace='<new undo tablespace>\u2019 scope=pfile;<\/li>\n<\/ul>\n<\/li>\n
                      • Shut down the DB:\n
                          \n
                        • shutdown immediate;<\/li>\n<\/ul>\n<\/li>\n
                        • Start up the DB in open mode:\n
                            \n
                          • startup;<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

                            After the above steps are applied, the database should return to normal operations.<\/p>\n

                            Reference: Oracle Support Note 1428786.1<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

                            After either a database, hardware, or power failure, there are some cases where the database is unable to perform normal functions due to errors such as ORA-01033 (See https:\/\/pitss.org\/us\/2013\/01\/11\/ora-01333-error-occurs-in-oracle-database-after-pc-crash\/ for more information). If the steps applied in the mentioned KB article as well as the traditional \u201cshutdown immediate\u201d and \u201cstartup\u201d DB commands fail and you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[95,14],"tags":[55,11,16,12,27],"class_list":["post-3595","post","type-post","status-publish","format-standard","hentry","category-database","category-resolve-issues","tag-10gr2","tag-11g","tag-11gr2","tag-error","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=3595"}],"version-history":[{"count":5,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3595\/revisions"}],"predecessor-version":[{"id":9000,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/3595\/revisions\/9000"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=3595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=3595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=3595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}