Hi Guy's,
Last week all the users are not able to connect the RAC-database.
Scan
Listener Services are Down After Firewall Restart
Because of
this issue users are not able to connect, when I check the status, I saw scan listener was down.
C:\Users\oracle>
crsctl status res -t
ora.LISTENER.lsnr
ONLINE OFFLINE
oradb1
ora.LISTENER_SCAN2.lsnr
1
ONLINE OFFLINE
ora.scan2.vip
1
ONLINE OFFLINE
>>>>>> <<<<<>>>>>>>>>>>>>><<<<<<<<<<<<<
C:\Users\oracle>
srvctl start scan_listener
C:\Users\oracle>
srvctl status scan
SCAN VIP
scan1 is enabled
SCAN VIP
scan1 is running on node oradb2
SCAN VIP
scan2 is enabled
SCAN VIP
scan2 is not running
SCAN VIP
scan3 is enabled
SCAN VIP
scan3 is running on node oradb2
C:\Users\oracle>
srvctl start scan_listener
PRCC-1014 :
LISTENER_SCAN1 was already running
PRCR-1004 :
Resource ora.LISTENER_SCAN1.lsnr is already running
PRCR-1079 :
Failed to start resource ora.LISTENER_SCAN1.lsnr
CRS-5702:
Resource 'ora.LISTENER_SCAN1.lsnr' is already running on 'oradb2'
PRCC-1014 :
LISTENER_SCAN3 was already running
PRCR-1004 :
Resource ora.LISTENER_SCAN3.lsnr is already running
PRCR-1079 :
Failed to start resource ora.LISTENER_SCAN3.lsnr
CRS-5702:
Resource 'ora.LISTENER_SCAN3.lsnr' is already running on 'oradb2'
Still Node1
Listener Down
C:\Users\oracle>srvctl
status listener
Listener
LISTENER is enabled
Listener
LISTENER is running on node(s): oradb2
C:\Users\oracle>srvctl
status listener -n oradb1
Listener
LISTENER is enabled on node(s): oradb1
Listener
LISTENER is not running on node(s): oradb1
Now Check Listener Again
C:\Users\oracle>srvctl
start listener -n oradb1
C:\Users\oracle>srvctl
status listener -n oradb1
Listener LISTENER
is enabled on node(s): oradb1
Listener
LISTENER is running on node(s): oradb1
C:\Users\oracle>
srvctl status scan_listener
SCAN
Listener LISTENER_SCAN1 is enabled
SCAN
listener LISTENER_SCAN1 is running on node oradb2
SCAN
Listener LISTENER_SCAN2 is enabled
SCAN
listener LISTENER_SCAN2 is running on node oradb1
SCAN
Listener LISTENER_SCAN3 is enabled
SCAN
listener LISTENER_SCAN3 is running on node oradb2
> Now all the Listeners are Up.
Happy Learning.
> Now all the Listeners are Up.
Happy Learning.
No comments:
Post a Comment