Oracle and OCI & JDBC Connection Strings

[code language=”sql”] <b>Sample for tnsnames.ora</b> ======================= culpdbs = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = your-primary-host-name)(PORT = 49130)) (ADDRESS = (PROTOCOL = TCP)(HOST = your-standby-host-name)(PORT = 49130)) (LOAD_BALANCE = no) (FAILOVER = yes) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mydbs) (failover_mode = (type = select) (method = preconnect) (retries = […]