Connecting Oracle Server using JDBC

There is a small difference of the connection string when the target is SID or SERVICE
jdbc:oracle:driver_type:[username/password]@//host_name:port_number:SID_NAME

jdbc:oracle:driver_type:[username/password]@//host_name:port_number/SERVICE_NAME

Colon means SID
Slash means Service name

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP