Skip to main content

Connection via VPN with Oracle RAC

Pablo Brunetti avatar
Written by Pablo Brunetti
Updated over a month ago

Find the latest version of this document on the Digibee Documentation Portal. On May 5, 2025, this Help Center will be deactivated, and this document will only be available on the Documentation Portal.

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?