Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center