Failure Of Server Apache Bridge and ORA-06512 Unhandled Exception in DEV_PORTAL.WWSEC_OID (Doc ID 1318987.1)

Last updated on JULY 19, 2016

Applies to:

Portal - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
Checked for relevance on 10-Feb-2015

Symptoms

After reinstalling Portal 11g the following error is seeing accessing Portal:

"Failure of server APACHE bridge:
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF."


The WLS_PORTAL-diagnostic.log shows errors like:

[2011-04-29T10:40:42.785-04:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 1666098637193,0:1:1:1] [APP: portal] [URI: /portal/pls/portal] ERROR: Repository Gateway error: Database Error: ORA=6510 ORA-06510: PL/SQL: unhandled user-defined exception[[
ORA-06512: at "DEV_PORTAL.WWSEC_OID", line 986
ORA-06512: at "DEV_PORTAL.WWSEC_OID", line 6509
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 15
]]
[2011-04-29T10:40:42.787-04:00] [WLS_PORTAL] [NOTIFICATION] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 1666098637193,0:1:1:1] [APP: portal] [URI: /portal/pls/portal] Oracle error: ORA-6510
[2011-04-29T10:40:42.790-04:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 1666098637193,0:1:1:1] [APP: portal] [URI: /portal/pls/portal] ERROR: oracle.webdb.repository.service.RepositoryServiceException: Portal session creation failed.
[2011-04-29T10:40:42.918-04:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 1666098637193,0:1:1:1] [APP: portal] [URI: /portal/pls/portal] ERROR: Repository Gateway error: Database Error: ORA=6510 ORA-06510: PL/SQL: unhandled user-defined exception[[
ORA-06512: at "DEV_PORTAL.WWSEC_OID", line 986
ORA-06512: at "DEV_PORTAL.WWSEC_OID", line 6509
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 15

 

After enabling "logcfg" logging for Portal, reference step 4 from <Note 436946.1> How To Diagnose/Debug a Portal UI Error?

Following error appears:

[03-MAY-2011 11:11:11] [ERROR] id=(null) ctx=wwsec_oid.get_last_error user=(null) subscriberId=(null) language=(null) userAgent="Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; GTB7.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.0450" ip=127.0.0.1
LDAP exception encountered
error=-11 - ldap_multiple_user_entries
[START-ERROR-STACK]
ORA-06510: PL/SQL: unhandled user-defined exception
[END-ERROR-STACK]
[START-CALL-STACK]
----- PL/SQL Call Stack -----
object line object
handle number name
0x24f8cf0b8 371 package body DEV_PORTAL.WWLOG_API_DIAG
0x24f8cf0b8 591 package body DEV_PORTAL.WWLOG_API_DIAG
0x24f8cf0b8 639 package body DEV_PORTAL.WWLOG_API_DIAG
0x253e0e208 1102 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 861 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6509 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6551 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6586 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6607 package body DEV_PORTAL.WWSEC_OID
0x24b7c9018 395 package body DEV_PORTAL.WPG_SESSION_PRIVATE
0x257dfbe70 6 anonymous block
[END-CALL-STACK]
[03-MAY-2011 11:11:11] [INFO] id=(null) ctx=wwsec_oid.get_user_entry user=PUBLIC subscriberId=1 language=us userAgent="Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; GTB7.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.0450" ip=127.0.0.1
Multiple matches were found for the specified criteria in the Oracle Internet Directory (error status: -11: Multiple user entries exist for the specified user nickname
Details
Operation: dbms_ldap_utl.get_user_dn
User: PUBLIC).
[START-CALL-STACK]
----- PL/SQL Call Stack -----
object line object
handle number name
0x24f8cf0b8 371 package body DEV_PORTAL.WWLOG_API_DIAG
0x24f8cf0b8 591 package body DEV_PORTAL.WWLOG_API_DIAG
0x24f8cf0b8 721 package body DEV_PORTAL.WWLOG_API_DIAG
0x24f8c9720 242 package body DEV_PORTAL.WWERR_API_ERROR
0x253e0e208 895 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6509 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6551 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6586 package body DEV_PORTAL.WWSEC_OID
0x253e0e208 6607 package body DEV_PORTAL.WWSEC_OID
0x24b7c9018 395 package body DEV_PORTAL.WPG_SESSION_PRIVATE
0x257dfbe70 6 anonymous block
[END-CALL-STACK]
[03-MAY-2011 11:11:11] [DEBUG] id=(null) ctx=wwsec_oid.handle_oid_errors user=PUBLIC subscriberId=1 language=us userAgent="Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; GTB7.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.0450" ip=127.0.0.1
Operation details 1
p_operation=dbms_ldap_utl.get_user_dn
p_user=PUBLIC
[START-CALL-STACK]

 

Changes

Uninstall and Reinstall the Portal 11g setup.

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