JDBC URL for Oracle RAC

July 30, 2012 admin Oracle, Oracle RAC

Use this url:
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))

SECURITY CHECKS – scripts to check privileges and permissions. Statistics locked? ORA-20005: object statistics are locked (stattype = ALL)