Jobs Accessing DB2 Data Via Oracle Db2 Gateway Failed (Doc ID 2651619.1)

Last updated on AUGUST 02, 2024

Applies to:

Symptoms

A job using oracle gateway failed with below error:

Error
ODI-1228: Task INT_WC_SLS_V5STRMS_P2_TMP (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-12170: TNS:Connect timeout occurred

Following is the output of oracle gateway started task:

SDSF OUTPUT DISPLAY ORAORN4 STC19142 DSID 2 LINE 3 COLS 13- 92
COMMAND INPUT ===> SCROLL ===> CSR
C19142 ---- SATURDAY, 08 FEB 2020 ----
C19142 $HASP373 ORAORN4 STARTED
C19142 IEF403I ORAORN4 - STARTED - TIME=07.14.10
C19142 MIN0001I networking service ORN4 initializing in subsystem ORS4
C19142 MIN0002I net service ORN4 initialized. Version:1.2.1.5
C19142 MIN0713I I am listening on port 001526 socket 00000
C19142 MIN0307E bind to service ORG4 failed, RC = 08, RSN = 0108, INFO = 00
C19142 MIS0208E Requested service unavailable
C19142 MIN0307E bind to service ORG4 failed, RC = 08, RSN = 0108, INFO = 00
C19142 MIS0208E Requested service unavailable
C19142 MIN0307E bind to service ORG4 failed, RC = 08, RSN = 0108, INFO = 00
C19142 MIS0208E Requested service unavailable
C19142 MIN0307E bind to service ORG4 failed, RC = 08, RSN = 0108, INFO = 00
C19142 MIS0208E Requested service unavailable
C19142 MIN0307E bind to service ORG4 failed, RC = 08, RSN = 0108, INFO = 00
C19142 MIS0208E Requested service unavailable
Not sure if this will help but in the ord4 tasks you are receiving the following

OSDI process pid: 00050000, image: ORACLE

*** SERVICE NAME:(SYS$USERS) 2020-02-08 07:15:05.629
*** CLIENT ID:(MC04741) 2020-02-08 07:15:05.629
*** SESSION ID:(434.8) 2020-02-08 07:15:05.629
*** 2020-02-08 07:15:05.629
*** 2020-02-08 07:15:05.634
HS: Unable to establish RPC connection to HS Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=pr
), NCR error = 65535 Unable to retrieve text of NETWORK/NCR message 65535

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.