RAC: 2 nodes with Oracle Single Client Access Name (SCAN)
OS: OEL 5.4 64 bits
Versión: 11.2.0.3
When I try to connect from the client to the RAC using the SCAN, I get ERROR: ORA-12541: TNS: no listenerOracle. I have noticed that the service is up and configured correctly (tnsnames client).
servicioBD = (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = scanvip.domain1.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = serviceBD) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )
serviceBD service
SQL> select name, failover_method, failover_type, failover_retries,goal, clb_goal,aq_ha_notifications from dba_services where service_id = 3;
NAME METHOD TYPE RETRIES GOAL CLB_GOAL AQNOT
---------------------------------------------------------------- ----------- ---------- -------- ---------- -------- -----
serviceBD BASIC SELECT 180 NONE LONG YES
But when I do not use the service created for the SCAN in tnsnames file, this is that if I set directly tnsnames to connect to any two nodes works fine.
Node 1
servicioBD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.2.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)
Or
Node 1
servicioBD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.2.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
)
I have also observed the following (cluvfy).
1 All LISTENER_SCAN are at node 1
2 There are not TCP connectivity
3 The error message is obtained PRVF-5713
[grid@rac1 ~]$ cluvfy comp scan -verbose
Verifying scan
Checking Single Client Access Name (SCAN)...
SCAN Name Node Running? ListenerName Port Running?
---------------- ------------ ------------ ------------ ------------ ------------
scanvip.domain1.local rac1 true LISTENER_SCAN1 1521 true
scanvip.domain1.local rac1 true LISTENER_SCAN2 1521 true
scanvip.domain1.local rac1 true LISTENER_SCAN3 1521 true
Checking TCP connectivity to SCAN Listeners...
Node ListenerName TCP connectivity?
------------ ------------------------ ------------------------
rac1 LISTENER_SCAN1 no
rac1 LISTENER_SCAN2 no
rac1 LISTENER_SCAN3 no
PRVF-5713 : Command "/u01/app/11.2.0/grid/bin/tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.210.2.17)(PORT=1521)))'" executed on node "rac1" produced no output
PRVF-5713 : Command "/u01/app/11.2.0/grid/bin/tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.210.2.19)(PORT=1521)))'" executed on node "rac1" produced no output
PRVF-5713 : Command "/u01/app/11.2.0/grid/bin/tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.210.2.18)(PORT=1521)))'" executed on node "rac1" produced no output
Checking name resolution setup for "scanvip.domain1.local"...
SCAN Name IP Address Status Comment
------------ ------------------------ ------------------------ ----------
scanvip.domain1.local 10.210.2.18 passed
scanvip.domain1.local 10.210.2.19 passed
scanvip.domain1.local 10.210.2.17 passed
Verification of SCAN VIP and Listener setup failed
Verification of scan was unsuccessful on all the specified nodes.
Could someone please help me.