My DBA upgraded my development DB from 12.1 to 12.2.0.1, and APEX from 4.2 to 19.1, and a REST request that used to work successfully is now failing with ORA-28860 Fatal SSL error.
The original function was using apex_web_services.make_rest_request to get back data, but I simplified the problem function down to the following code which just attempts a connection:
declare
req UTL_HTTP.req;
res UTL_HTTP.resp;
BEGIN
UTL_HTTP.set_wallet ('file:/oracle/admin/wallet', 'xxwallet');
req := UTL_HTTP.BEGIN_REQUEST ( 'https://blox-lab-01.net.local.cmu.edu/wapi/v2.2.2/' );
utl_http.set_authentication( req, 'xxusername', 'xxpassword', 'Basic' );
res := UTL_HTTP.get_response (req);
end;
And get at error at "begin_request":
[Error] Execution (1: 1): ORA-29273: HTTP request failed
ORA-28860: Fatal SSL error
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1127
ORA-06512: at line 6
This exact procedure (same end server, same authentication, same wallet location, same ACLs in place) still works on our Test server (which is still 12.1)
I went through all the other posts like this I could find, and my DBA and I verified
- both the Oracle DB and the end server are using TLS1.2
- the patch 25734963 that supports SNI is installed.
- the server certificate was freshly reinstalled in the oracle wallet
What else can I do to debug this problem?