Load balancing not working through tnsnames.ora scan names or IPs
Hi
Oracle database 19.16 RAC
Client 19
I have tried putting to tnsnames.ora a single scan name or all the scan IP-s and I do not get any load balancing.
tnsnames.ora entry
SCANALIAS = (DESCRIPTION = #(ADDRESS = (PROTOCOL = TCP)(HOST = dc1-test-db2-scan.domain.com)(PORT = 1521)) # OR (ADDRESS = (PROTOCOL = TCP)(HOST = 70.51.30.2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 70.51.30.7)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 70.51.30.8)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dc1s.domain.com) ) )
I only get second instance (this last number from instance_name is 2)
PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2 PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2 PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2 PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2 PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2 PS C:\Users\raulk2> echo 'select INSTANCE_NAME from v$instance;' | sqlplus -silent raulkaubi/*********@SCANALIAS INSTANCE_NAME ---------------- dc1t2