Portal 11g Logout Fails With HTTP-503 - Service Temporarily Unavailable

(Doc ID 1335738.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2.3 and later
PL/SQL - Version 10.2.0.5 to 11.1.0.6 [Release 10.2 to 11.1]
Portal - Version 10.1.2.3 to 11.1.1.6.0 [Release 10gR2 to FMW11g]
Information in this document applies to any platform.
Checked for relevance on 10-Feb-2015

Symptoms

After upgrading Portal to 11g and clicking on the Builder page logout link, the following is observed (the same will happen for OIDDAS logout application):


At the 10g Infrastructure, in the Apache error log, the following is seen ($ORACLE_HOME/Apache/Apache/logs):

[Mon Jul 4 09:43:57 2011] [error] [client XXX.XXX.XXX.XXX] [ecid: 1309787029:XXX.XXX.XXX.XXX:15552:0:20,0] mod_plsql: /pls/orasso/orasso.wwsso_app_admin.ls_logout HTTP-503 ORA-3113 Call to WPG_SESSION API Failed.


Within the Database alert_<sid>.log (UDUMP directory) the following is seen:

Mon Jul 04 09:25:15 2011
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1E] [PC:0xE9F4F04, pfrinstr_BRNCNULL()+54]
Errors in file /opt/product/1012/diag/rdbms/asdb/asdb/trace/asdb_ora_15592.trc (incident=42739):
ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+54] [SIGSEGV] [ADDR:0x1E] [PC:0xE9F4F04] [Address not mapped to object] []
Incident details in: /opt/product/1012/diag/rdbms/asdb/asdb/incident/incdir_42739/asdb_ora_15592_i42739.trc


Within the trace (inside UDUMP directory) the following is seen:

(...)
========= Dump for incident 42739 (ORA 7445 [pfrinstr_BRNCNULL()+54]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1E] [PC:0xE9F4F04, pfrinstr_BRNCNULL()+54]
Registers:
%eax: 0x3e9ef2dc %ebx: 0xb7de97c0 %ecx: 0xb7de9800
%edx: 0x3e9ef2e0 %edi: 0x0000001e %esi: 0x00000001
%esp: 0xbfffa6b8 %ebp: 0xbfffa6d0 %eip: 0x0e9f4f04
%efl: 0x00210246
pfrinstr_BRNCNULL()+43 (0xe9f4ef9) mov (%edx,%edi,4),%edi
pfrinstr_BRNCNULL()+46 (0xe9f4efc) lea 0x4(%eax),%edx
pfrinstr_BRNCNULL()+49 (0xe9f4eff) mov %edx,0xc(%ebp)
pfrinstr_BRNCNULL()+52 (0xe9f4f02) jne 0xe9f4f2b
> pfrinstr_BRNCNULL()+54 (0xe9f4f04) mov (%edi),%esi
pfrinstr_BRNCNULL()+56 (0xe9f4f06) movzw 0x6(%esi),%edi
pfrinstr_BRNCNULL()+60 (0xe9f4f0a) test $0x6,%edi
pfrinstr_BRNCNULL()+66 (0xe9f4f10) je 0xe9f4f19
pfrinstr_BRNCNULL()+68 (0xe9f4f12) mov $0x9,%esi
(...)
----- Current SQL Statement for this session (sql_id=g7uzjchftwrvb) -----
begin
owa.init_cgi_env(:n__,:nm__,:v__);
htp.htbuf_len := 63;
orasso.wpg_session.init();
WPG_SESSION_PRIVATE.CREATE_SESSION(:p_cookie_name);
WPG_SESSION_PRIVATE.GET_SESSION_INFO(:sesn__,:sesnm__,:sesv__);
orasso.wpg_session.deinit();
commit;
owa.get_page(:data__,:ndata__);
dbms_session.reset_package;
exception
when others then
rollback;
dbms_session.reset_package;
raise;
end;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x3f2024b0 28 package body SYS.OWA_UTIL
0x3f1c52fc 138 package body SYS.OWA_COOKIE
0x3f0db3d4 1686 package body ORASSO.WWCTX_SSO
0x3f0db3d4 2231 package body ORASSO.WWCTX_SSO
0x39378ec4 130 package body ORASSO.WPG_SESSION_PRIVATE
0x39387854 5 anonymous block
(...)


There is most likely to be invalid packages from the ORASSO schema, within the database:

set pagesize 9999
set lines 300
select owner, object_name, object_type from all_objects where status <> 'VALID';

-- You may attempt to recompile them (but may not solve the issue)

Changes

This has been found in the following scenario(s):

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