SCAN IP address in RAC not accessible by clients
I have a 2 node Oracle RAC configuration running on Solaris 10 update 10 x86 with Oracle 11.2.0.1 DB installed on each node in a lab environment.
I am having problems connecting to the SCAN IP address with clients (Microsoft Access client talking to the Oracle RAC). I can only connect with clients using the IP addresses of the individual nodes in the cluster. This is my first RAC install. We are NOT using DNS only the /etc/hosts file. I see the IP address that is used as the cluster IP address associated with only one node of my two which is correct I believe.
Here is some displays from the cluster:
oracle@mortlach srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node elijahcraig
oracle@mortlach srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node elijahcraig
oracle@mortlach lsnrct status
bash: lsnrct: command not found
oracle@mortlach lsnrctl status
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 27-APR-2011 18:35:57
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 27-APR-2011 13:33:40
Uptime 0 days 5 hr. 2 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/11.2.0/grid/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/mortlach/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.180.77)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.180.249)(PORT=1521)))
Services Summary...
Service "hsmtest" has 1 instance(s).
Instance "hsmtest2", status READY, has 1 handler(s) for this service...
Service "hsmtestXDB" has 1 instance(s).
Instance "hsmtest2", status READY, has 1 handler(s) for this service...
The command completed successfully