Scheduler Job Through The Remote Scheduler Agent Fails With: ORA-29024

(Doc ID 2388243.1)

Last updated on APRIL 18, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Executing a Scheduler Job Through the Remote Scheduler Agent Fails With: ORA-29024. Alert log of of database will show error like below:

ORA-12537: TNS:connection closed
ORA-06512: at "SYS.DBMS_ISCHED", line 4966
ORA-06512: at "SYS.DBMS_ISCHED", line 6898
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3975
ORA-06512: at line 1

Scheduler log can show error like below:

2017.12.06 15:46:56 CET Thread: 2 Received connection from x.x.x.x:abcd
2017.12.06 15:46:56 CET Thread: 2 Using existing spare worker thread
2017.12.06 15:46:56 CET Thread: 12 Assigned connection to x.x.x.x:abcd
2017.12.06 15:46:56 CET Thread: 12 Incremented connections to 1
2017.12.06 15:46:56 CET Thread: 12 Error receiving request : javax.net.ssl.SSLHandshakeException: Received fatal alert: unknown_ca
2017.12.06 15:46:56 CET Thread: 12 Decremented connections to 0
2017.12.06 15:46:56 CET Thread: 12 Adding thread to spareThreads



Changes

 Customer applied Patch 26581376 - WINDOWS DB BUNDLE PATCH 11.2.0.4.171017

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