Skip to main content
All CollectionsSettings
Connection via VPN with Oracle RAC
Connection via VPN with Oracle RAC
Pablo Brunetti avatar
Written by Pablo Brunetti
Updated over 3 months ago


The architecture of Oracle RAC (Real Application Cluster) offers several benefits in database computing, such as scalability, availability, load balancing, redundancy and monitoring. However, when we want to connect a pipeline to a database through a VPN, the network topology involved in this process doesn't allow us to see the nodes behind the Oracle SCAN-LISTENER. This prevents the JDBC driver from connecting to the node that the listener returned as available to receive a connection.

It's necessary to avoid using the SCAN-LISTENER mapping in the process and inform the Digibee Support team, via Intercom, of the IPs of each node in this cluster's database. This way, you can use a connection string with multiple hosts to ensure traffic, as well as redundancy between them, which can be handled via the connection string.



Example:

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS= (PROTOCOL = TCP)(HOST = 10.158.xx.xxx)(PORT = 1111))(ADDRESS= (PROTOCOL = TCP)(HOST = 10.158.xx.xxx)(PORT = 2222))(ADDRESS= (PROTOCOL = TCP)(HOST = 10.158.xx.xxx)(PORT = 3333))(FAILOVER = on)(LOAD_BALANCE = on))(CONNECT_DATA=(SERVICE_NAME = NOMEDOSERVICO)))

Did this answer your question?