Guardium - How to connect to Oracle cluster that uses multiple IP addresses without using RAC SCAN-IP

Content

This procedure can be used in Guardium v9p200 and higher.

1. To connect to the Oracle cluster, use the syntax listed for the Oracle JDBC Driver. This is the driver that the customer uploaded. The syntax is used in the Custom URL section of the Guardium Datasource Builder. Test the connection and a successful connection message will appear. Then click Apply.

Reference:

http://www.drdobbs.com/jvm/jdbc-fast-connection-failover-with-oracl/222700353?pgno=2

Use the following syntax:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=rac1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rac2) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racvmva)))

2. To connect to the Oracle cluster, use the syntax listed for the DataDirect JDBC Driver. This is the driver that ships with the Guardium application. The syntax is used in the Custom URL section of the Guardium Datasource Builder. Test the connection and a successful connection message will appear. Then click Apply.

References:

https://www.progress.com/products/datadirect-connect/jdbc-drivers/jdbc-developer-center/jdbc-tutorials/using-datadirect-connect-for-jdbc-with-oracle-rac/load-balancing

https://www.progress.com/~/media/DataDirect/Documents/JDBC/Tutorials/jdbc-oracle-rac.pdf

Use the following syntax:

jdbc:guardium:oracle://rac1.guard.swg.usma.ibm.com:1521;ServiceName=racvmva;AlternateServers=(rac2:1521);LoadBalancing=true