New Portal Logins Fail At Busy Times - 10g OID MR Database Locks Occurring
(Doc ID 1299268.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Internet Directory - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]Information in this document applies to any platform.
Symptoms
Oracle Internet Directory (OID) 10g.
In busy times, even after a complete bounce of the components/processes, about 10 to 20 minutes later no more users are able to log in to Portal. The issue usually starts occurring when the load is high.
When the issue occurs, the Metadata Repository (MR) Database (DB) always shows the following delete as a blocker:
And the waiters want to execute the following:
On the Portal DB, when a blocking / locking situation arises, the blocker is executing the following sql:
rc__ number;
simple_list__ owa_util.vc_arr;
complex_list__ owa_util.vc_arr;
begin
owa.init_cgi_env(:n__,:nm__,:v__);
htp.HTBUF_LEN := 63;
null;
null;
simple_list__(1) := 'sys.%';
simple_list__(2) := 'dbms\_%';
simple_list__(3) := 'utl\_%';
simple_list__(4) := 'owa\_%';
simple_list__(5) := 'owa.%';
simple_list__(6) := 'htp.%';
simple_list__(7) := 'htf.%';
simple_list__(8) := 'wpg_docload.%';
if ((owa_match.match_pattern(p_string =>
'portal.wwsec_app_priv.process_signon'
/* */,p_simple_pattern =>
simple_list__
,p_complex_pattern =>
complex_list__
,p_use_special_chars =>
false)))
then
rc__ := 2;
else
null;
PORTAL.wpg_session.init();
portal.wwsec_app_priv.process_signon(urlc=>:urlc);
if (wpg_docload.is_file_download) then
rc__ := 1;
wpg_docload.get_download_file(:doc_info);
PORTAL.wpg_session.deinit();
null;
null;
commit;
else
rc__ := 0;
PORTAL.wpg_session.deinit();
null;
null;
commit;
owa.get_page(:data__,:ndata__);
end if;
end if;
:rc__ := rc__;
end;
And the following is the sql the waiter is trying to execute:
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 |
Cause |
Solution |
References |