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


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



Leave a Reply

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

You are commenting using your 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.