My Oracle Support Banner

Error WWC-00000 and Metadata Shown On Page After Implementing New Server Root Certificate On Load Balancer (Doc ID 2001591.1)

Last updated on JANUARY 07, 2021

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 9.2.0.3 to 11.2.0.2 [Release 9.2 to 11.2]
Portal - Version 10.1.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

In an Oracle Portal 11g environment with external SSL and non-SSL within the Fusion Middleware stack, the server root certificate has been replaced on the Load Balancer device. After implementation of the certificate, users are able to login but both a WWC-00000 errors and metadata is shown in the page :

 ;i=pls Forasso Forasso.wwsso_app_admin.fapp_process__login....


Portal repository tracing reveals an ORA-28857 from wwctx_api.get_sso_login_config() :

[02-APR-2015 14:06:35] [ERROR] id=1427976392770[ACTIVE] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)' ctx=wwctx_api.get_sso_login_config user=ORCLADMIN subscriberId=1 language=us userAgent="Mozilla/5.0 (Windows NT 5.1; rv:36.0) Gecko/20100101 Firefox/36.0 Oracle HTTPClient Version 10h" ip=<IP>
Failed to get sso login config info
[START-ERROR-STACK]
ORA-28857: Unknown SSL error
[END-ERROR-STACK]

Upon further investigation, all UTL_HTTP.REQUEST() calls in SSL mode referencing the server root certificate fail with error message ORA-28857: Unknown SSL error :

SQL> select utl_http.request('https://<DOMAINNAME>',null,'file:/app/oracle/product/11.2/dbhome1/admin/asdb/wallet/','<PASSWORD>') from dual ;
select utl_http.request('https://<DOMAINNAME>',null,'file:/app/oracle/product/11.2/dbhome1/admin/asdb/wallet/','<PASSWORD>') from dual
     *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-28857: Unknown SSL error
ORA-06512: at line 1

 

Changes

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.