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

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 10.1.2.0.2 and later
Oracle Database - Enterprise Edition - Version 9.2.0.3 to 11.2.0.2 [Release 9.2 to 11.2]
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%20Forasso%20Forasso.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=10.11.100.187
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://www.acme.org',null,'file:/app/oracle/product/11.2/dbhome1/admin/asdb/wallet/','welcome1') from dual ;
select utl_http.request('https://www.acme.org',null,'file:/app/oracle/product/11.2/dbhome1/admin/asdb/wallet/','welcome1') 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

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