Instance Crashed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Instance Crashed

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    Hi Guys,

    Yesterday our database instance crashed due to the following error.

    Thu May 16 06:26:54 2002
    Shutting down instance (immediate)
    License high water mark = 41
    Thu May 16 06:26:54 2002
    Errors in file E:\Oracle8i\admin\pandaza\bdump\pandazaSNP1.TRC:
    ORA-12012: error on auto execute of job 226
    ORA-20000: ORU-10015: error:3 waiting for pipe message.
    ORA-06512: at "SYS.DBMS_ALERT", line 117
    ORA-06512: at "SYS.DBMS_ALERT", line 309
    ORA-06512: at "PANDAOWNER.BP_PANDAPRT_PRINT", line 37
    ORA-06512: at line 1

    This is the message logged in pandazaSNP1.trc:
    *** SESSION ID:(8.52028) 2002.05.16.06.26.54.921
    *** 2002.05.16.06.26.54.921
    ORA-12012: error on auto execute of job 226
    ORA-20000: ORU-10015: error:3 waiting for pipe message.
    ORA-06512: at "SYS.DBMS_ALERT", line 117
    ORA-06512: at "SYS.DBMS_ALERT", line 309
    ORA-06512: at "PANDAOWNER.BP_PANDAPRT_PRINT", line 37
    ORA-06512: at line 1
    error 1089 detected in background process
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-01089: immediate shutdown in progress - no operations are permitted

    Has any one faced a problem similar to this.

    Any help will be appreciated.

    Thanks.
    Vijay.

    Say No To Plastics

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    I guess this error might be caused due to job which is indicated in the trace file.Just try to re-examine the job and check it.
    It must have caused on the backgroud process to crash.
    Just restart the database.Oracle will perform auto recovery.
    But make sure u check the job once and try to fix the problem

    regards
    anandkl
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width