Unable to connect to the database, using SCAN in 11gR2
880047Sep 14 2011 — edited Sep 14 2011Hi ALL,
I am in big trouble, I am working on 11gR2 4 node RAC database, and 1hr ago i have bounce the database for some issue. It came up and working fine for me, when i am connecting from the server. but the users (Performance team) who are connecting from application, it is not able to connect with SCAN address. we haven't changed any thing at the DB level or at OS level. and even i is not connecting from SQLDeveloper. It is thronging error message saying that "IO Exception: The network adopter could not establish the connection"
What are the things i need to check, Please give me your valuable suggestions and all of the application team is waiting for this issue to be resolved.
2 days ago, we have added 4th node to the existing 3node RAC. Is that given any issues.
below are the things i checked.
$->srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node qysqalccoredb01
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node qysqalccoredb03
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node qysqalccoredb02
$->srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node qysqalccoredb01
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node qysqalccoredb03
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node qysqalccoredb02
why it is not running on 4th node.
Also i have updated the SCAN info by resetting the local_listener parameter to use the scan address.
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host-vip.ieptc.intuit.net)(PORT=1521))))' sid='sid1' scope=both;
do i need to do the below one as well.
alter system set remote_listener='scan-domain-name.example.com:1521' scope=both sid='*'
Please help me and thanks in advance.