raccheck OS Check Warning -- tnsname alias
---------------------------------------------------------------------------------------------------------------------------------------------------------
WARNING OS Check tnsname alias should not be defined as scanname:port All Database Servers
Benecit/Impact
There should be local tnsnames alias defined in $ORACLE_HOME/network/admin/tnsnames.ora same as scan name : port.
Risk:
it might disturb instance registration with listener services and you may not be able to achieve fail over and load balancing.
Action / Repair:
rename scan name:port tnsalias to some different name.
------------------------------------------------------------------------------------------------------------------------------------------------------
tnsnames.ora entry:
TIMSWST.WSTCLUSTER.FAA.GOV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wst-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = timswst.wstcluster.faa.gov)
)
)
We would like to use the SCAN for the alias to get server-side load balancing.