ORA-12505 When Connecting Using Jdbc.

[silkPK]

If the database is a pluggable database (PDB so Multi-Tenant functionality) the client connection fails with ORA-12505.

Error:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

According to the Oracle Doc ID 2926900.1, connections to a pluggable database use SERVICE_NAME and not SID.

To solve this problem, shall be used the Thin-style Service Name Syntax

@//host_name:port_number/service_name

For example:

jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename