Instance Crashed

[oravijay]

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.

[anandkl]

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