Senthil Rajendran's Blog: FMW 11g Portal and Discoverer Post Upgrade verification failed with ORA-7445

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

https://dev.server.com/pls/orasso/htp.p?cbuf=test

and login to