Streamsets error connecting to Oracle PDB (JDBC_00 / ORA-12505)

JDBC_00 - Cannot connect to specified database: com.zaxxer.hikari.pool.HikariPool$

PoolInitializationException: Failed to initialize pool: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

We faced this issue connecting to Oracle 19C PDB using connection string format

jdbc:oracle:thin@<host_url>:<port>:<OracleSID>

Resolution: The fix required is to use a forward slash instead of colon.

jdbc:oracle:thin@<host_url>:<port>/<OracleSID>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.