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 10.1.2.3 to 10.1.2.3 [Release 10gR2]
Information in this document applies to any platform.
***Checked for relevance on 03-JUL-2014***

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


Symptoms

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.
e.g.,
-------------------
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 10.41.9.20] [ecid: 1265831136:10.41.9.20: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]

Changes

Upgrade path:
----------------
Upgraded IDM 10.1.2.0.2 to IDM 10.1.2.3
Upgraded 10.2.0.3 Repository database to 11.1.0.6 then to 11.1.0.7

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

Installed 64-bit WebLogic Server
Installed 11g IDM 11.1.1.2
Upgrade 10g IDM (OID and DIP only) to 11.1.1.2
- 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)

Cause

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