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)))