-
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.
-
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
