Sunday, August 14, 2011

FMW 11g Portal and Discoverer Post Upgrade verification failed with ORA-7445

FMW 11g Upgrade Master Index

After upgrading Discoverer and Portal to 11g logging on the portal or discoverer results in ORA-7445 in the database.

Manual verification of the SSO component failed.

Fri May 06 09:19:16 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7573FFFFBF387C52] [PC:0x400000000429ED11, pfrinstr_BRNCNULL()+177] [exception issued by pid: -1086817198, uid: 0]
Errors in file /oracle/base/diag/rdbms/infdb/INFDB/trace/INFDB_ora_5858.trc  (incident=721877):
ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+177] [SIGSEGV] [ADDR:0x7573FFFFBF387C52] [PC:0x400000000429ED11] [Address not mapped to object] []
Fri May 06 09:19:19 2011
Sweep Incident[721877]: completed

The cause for this issue is seen as a Bug 9210925 - AFTER MANUAL UPGRADE TO PL/SQL CALLS INCORRECT FUNCTION

Incorrect fast-validation would happen when a parent of a library unit was modified in an incompatible way and the parent was referenced via a synonym. Symptoms could include wrong results and ORA-7445s.

Unfortunately the BUG is fixed in 11.2 and I am running 11.1 , so had to follow the workaround 

Workaround Solution
Connect to the INFDB Database as SYSTEM
            alter system set "_disable_fast_validate"=TRUE;
Connect to the INFDB Database as ORASSO User
alter package WWCTX_SSO compile;
alter package WWCTX_SSO compile body;
alter package WPG_SESSION_PRIVATE compile;
alter package WPG_SESSION_PRIVATE compile body;

Validate the ORASSO and OIDDAS Pages
and login to /pls/orasso/ /oiddas

Reference ORASSO DAD Fails After Upgrading Application Mid-tier and Repository DB to 11g (Doc ID 1094047.1)

Popular Posts