My Oracle Support Banner

Portal 11g Logout Fails with HTTP-503 - Service Temporarily Unavailable (Doc ID 1335738.1)

Last updated on MARCH 08, 2022

Applies to:

Portal - Version 10.1.2.3 to 11.1.1.6.0 [Release 10gR2 to FMW11g]
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]
Information in this document applies to any platform.

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):

[<TIMESTAMP>] [error] [client <IP_ADD>] [ecid: <ECID>] 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:

<TIMESTAMP>
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1E] [PC:0xE9F4F04, pfrinstr_BRNCNULL()+54]
Errors in file /<ORACLE_HOME>/diag/rdbms/asdb/asdb/trace/<TRACE_FILENAME>.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: /<ORACLE_HOME>/diag/rdbms/asdb/asdb/incident/incdir_42739/<TRACE_FILENAME>.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:
êx: 0x3e9ef2dc ëx: 0xb7de97c0 ìx: 0xb7de9800
íx: 0x3e9ef2e0 íi: 0x0000001e %esi: 0x00000001
%esp: 0xbfffa6b8 ëp: 0xbfffa6d0 %eip: 0x0e9f4f04
ïl: 0x00210246
pfrinstr_BRNCNULL()+43 (0xe9f4ef9) mov (íx,íi,4),íi
pfrinstr_BRNCNULL()+46 (0xe9f4efc) lea 0x4(êx),íx
pfrinstr_BRNCNULL()+49 (0xe9f4eff) mov íx,0xc(ëp)
pfrinstr_BRNCNULL()+52 (0xe9f4f02) jne 0xe9f4f2b
> pfrinstr_BRNCNULL()+54 (0xe9f4f04) mov (íi),%esi
pfrinstr_BRNCNULL()+56 (0xe9f4f06) movzw 0x6(%esi),íi
pfrinstr_BRNCNULL()+60 (0xe9f4f0a) test $0x6,íi
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

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
Symptoms
Changes
Cause
Solution
References

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