ORASSO DAD Fails After Upgrading Application Mid-tier and Repository DB to 11g

(Doc ID 1094047.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Application Server Single Sign-On - Version to [Release 10gR2]
Information in this document applies to any platform.
***Checked for relevance on 03-JUL-2014***

SSO Server Version
OID Version
11g AS PFRD MiddleTier
Infrastructure Database Version 11g Enterprise Edition Release
OWA toolkit version


Upgrading Oracle Application Server 10.1.2.x Infrastructure and Mid-tier environment to 11g
After running RCU 11.1.1.x to upgrade the schema for the mid-tier, ORASSO DAD is down.
Ping URL: http://ssoserver.au.oracle.com:7777/pls/orasso/htp.p?cbuf=test
HTTP response: 503 Service Temporarily Unavailable
/pls/orasso DAD is DOWN

Apache error_log.1265803200
[Wed Feb 10 11:45:37 2010] [error] [client] [ecid: 1265831136:,0] mod_plsql: /pls/orasso/htp.p HTTP-503 ORA-3113 Call to WPG_SESSION API Failed.

The PLSQL connection to the SSO DAD that is failing with ORA-3113 and ORA-7445 core dump in the Database alert log:
ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+54][SIGSEGV] [ADDR:0x1E] [PC:0xE9F4F14] [Address not mapped to object]


Upgrade path:
Upgraded IDM to IDM
Upgraded Repository database to then to

Created 11g schema for Discoverer (PFRD) using 11g RCU
OWA version is installed into the Oracle database

Installed 64-bit WebLogic Server
Installed 11g IDM
Upgrade 10g IDM (OID and DIP only) to
- Run Upgrade Assistant (Ignore warning that HTTP_Server and mod_plsql was not found in the target home)

Installed 64-bit 11g Fusion Middleware Mid-tier (PFRD)
Upgrade 10g AS Mid-Tier (PFRD) to 11g AS Mid-Tier (PFRD)


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms