My Oracle Support Banner

TNS-12505 or ORA-12505 or I/O Exception Error Messages Signaled when Launching Processing with ODI (Doc ID 423752.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Oracle Data Integrator - Version and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


Either of the following messages may be signaled when launching processing from Oracle Data Integrator (ODI):

ORA-12505: TNS: listener could not resolve SID given in connection description.

TNS-12505 TNS:listener could not resolve SID given in connect descriptor

java.sql.SQLException: I/O Exception: The Network Adapter could not establish the connection




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
 Verify the Oracle database and Listener
 Verify the environment settings
 Verify the connection from ODI Topology Manager
 Verify the ODI odiparams.bat (.sh) configuration file
 Verify the ODI Master Repository URL
 Verify the ODI Work Repository URL
 Verify the ODI Datasources in WLS Administration Console

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