SCAN (Single Client Access Name) not working properly
414763May 24 2011 — edited May 24 2011We are in the process of upgrading to 11.2.0.1.0 RAC (4 nodes) running Grid Infrastructure and SCAN via DNS. The setup went great as did the data pump. However when trying to connect to the SCAN address I am getting an ORA-12154 error. My TNS entry is as follows:
FMRQ=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=ncc1701rac-scan.dsd-k12.net)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=shared)
(SERVICE_NAME=fmrq)
)
)
If I change my Service_Name to be fmrq1, fmrq2, fmrq3, or fmrq4 which just so happen to be the SID's for each of my nodes I am able connect. I'm sure that I have missed something simple, but due to the lack of detailed documentation about how SCAN works I am not able to troubleshoot this on my own. Help is most definitely needed.