ORA-03113 ORA-01041 ORA-07445

Hi Team,

Very Nice to C Erros nd Sol's --- next 2 each Other :) like best frds :)

Now, I'm gng to introduce one more Err-Sol frds...

Issue:

While applying a patch its failed compiling a pkb by worker with below error

SQL> @/appsdba_experts/applmgr/11510/pqp/11.5.0/patch/115/sql/pqpospfn.pkb

CREATE OR REPLACE PACKAGE BODY pqp_gb_osp_functions AS
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

ERROR:
ORA-01041: internal error. hostdef extension doesn't exist

-- Tired compiling from another session..it failed again..with same error
-- Checked the staus of pks,pkb both r invalid.
-- In alert logfile we found 'ORA-07445' when we r trying to compile.

ORA-07445: exception encountered: core dump [kgldtf()+8] [SIGSEGV] [ADDR:0x0] [PC:0x26412A4]


Sol:

Run DB revalidation.

- Stard DB in Upgrade Mode
- run utlirp.sql
- run utlrp.sql

- Compiled the package now. Got compiled.

Note : 1. to speed up the utlrp.sql process ( for us it took total 7 hrs for revalidation, which is not acceptable in most of the cases ) please set job_queue_processes to recommended values other than 0 , after compilation revert back to original value.
2. We tried lot of work arounds to avoid 7-8hrs loss but nothing worked. Finally we came to conclusion that this is the only way...even though its a long way ( Naa Daaari...Rahadari..Better c:)me in my Way :)... Tht's wat DB said )
3. Along with this we have few other packages failed with similar error

Cause : Error is raised due to inconsistencies in the data dictionary between objects and their dependencies and that likely the inconsistency exists before patching is started.

Will meet U again..with new Err-Sol frds's

Bye..

Key+Run ....