My Oracle Support Banner

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

Last updated on MARCH 12, 2019

Applies to:

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

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://<SERVERNAME>:<PORT>/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 <IP_ADDRESS>] [ecid: 1265831136:<IP_ADDRESS>:31764:0:1,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)


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.