Connecting to 11g R2 RAC without using SCAN
hi
We have a 10g R2 client and we need to connect to the 11g R2 database without using SCAN entry and instead use the VIPs
when we try to execute tnsping <11gRACDB> , we get TNS-12541 - No Listener
We have the following in our tnsnames.ora
PRODTST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.31)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.33)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodtst)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
In above, the 2 IPs are the VIPs
what we could be missing here?
How can we verify if the listeners are listening on port 1521 for both the VIPs?
0