Today when doing OCR and VD disk recovery, node one of the listener does not come:
[Email protected] ~]$ lsnrctl statuslsnrctl for linux:version 11.2.0.1.0-production on 21-jan-2016 07:57:49copyright ( C) 1991, Oracle. All rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC) (Key=listener)) Tns-12541:tns:no LISTENER Tns-12560:tns:protocol Adapter Error Tns-00511:no Listener
Cluster Status:
[[email protected] rac2]$ crsctl Status Res- T--------------------------------------------------------------------------------NAME TARGET State SERVE R state_details--------------------------------------------------------------------------------Lo Cal Resources--------------------------------------------------------------------------------ORA.DATA.DG ONL INE online Rac1 Online online rac2 Ora. FRA.DG Online online Rac1 online online Rac2 Ora. Listener.lsnr OFFLINE OFFLINE Rac1 ONLINE onlin E rac2 ora.asm Online online Rac1 S tarted Online online rac2 Started ora.eons online Online Rac1 Online Online Rac2 ORA.GSD OFFLINE OFFLINE Rac1 OFFLINE Offli NE rac2 ora.net1.network Online online Rac1 Online online Rac2 ora.ons Online online rac1 Online online rac2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.orcl.db 1 ONLINE ONLINE Rac1 Open 2 online online rac2 Open ORA.RAC2 . VIP 1 Online Online RAC2
Fortunately, the reboot did not listen:
[[email protected] ~]$ crsctl Status Res- T--------------------------------------------------------------------------------NAME TARGET State SERVE R state_details--------------------------------------------------------------------------------Lo Cal Resources--------------------------------------------------------------------------------ORA.DATA.DG ONL INE online Rac1 Online online rac2 Ora. FRA.DG Online online Rac1 online online Rac2 Ora. Listener.lsnr <span style= "color: #FF0000;" >online OFFLINE rac1</span> Online online RAC 2 ora.asm Online Online RAC1 Started Online Online rac2 Started Ora.eons Online online Rac1 online online Rac2 ORA.GSD OFFLINE OFFLINE Rac1 OFFLINE OFFLINE Rac2 Ora.net1.network Online online rac1 Online online rac2 Ora.ons Online Online Rac1 Online online Rac2------------------------------------------- -------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.orcl.db 1 Online online Rac1 Open 2 online online RAC2 Open <span style= "color: #FF0000;" >ORA.RAC2.VIP 1 Online online rac2 </span>[[email protected] ~]$ srvctl status Listenerli Stener LISTENER is Enabledlistener LISTENER was running on node (s): RAC2
Look at the network:
[[email protected] bin]# ifconfigeth0 Link encap:ethernet HWaddr 08:00:27:40:4a:f0 inet addr:192.168 .56.10 bcast:192.168.56.255 mask:255.255.255.0 up broadcast RUNNING multicast mtu:1500 metric:1 RX p ackets:6071 errors:0 dropped:0 overruns:0 frame:0 TX packets:7816 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:711129 (6 94.4 KiB) TX bytes:1035971 (1011.6 KiB) eth1 Link encap:ethernet HWaddr 08:00:27:a7:8d:47 inet addr:10.16 8.56.10 bcast:10.168.56.255 mask:255.255.255.0 up broadcast RUNNING multicast mtu:1500 metric:1 RX p ackets:145263 errors:0 dropped:0 overruns:0 frame:0 TX packets:126107 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:9771163 0 (93.1 MiB) TX bytes:70769822 (67.4 MiB) lo Link encap:local Loopback inet addr:127.0.0.1 mask:255.0.0 .0 up LOOPBACK RUNning mtu:16436 metric:1 RX packets:63501 errors:0 dropped:0 overruns:0 frame:0 TX packets:63501 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:26623161 (25.3 MiB) TX bytes:26623161 (25.3 MiB)
[Email protected] ~]$ srvctl config vip-n rac1prko-2310:vip does not exist on node Rac1. Nothing to give: [[email protected] bin]# ./srvctl Add vip-n rac1-a 192.168.56.12/255.255.255.0/eth0-k 1
Wait a minute [[email protected] bin]# ifconfigeth0 Link encap:ethernet HWaddr 08:00:27:40:4a:f0 inet addr:192.1 68.56.10 bcast:192.168.56.255 mask:255.255.255.0 up broadcast RUNNING multicast mtu:1500 metric:1 RX packets:6838 errors:0 dropped:0 overruns:0 frame:0 TX packets:8611 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:802635 (78 3.8 KiB) TX bytes:1146546 (1.0 MiB) eth0:1 Link encap:ethernet HWaddr 08:00:27:40:4a:f0 inet addr:192.168.56 . bcast:192.168.56.255 mask:255.255.255.0 up broadcast RUNNING multicast mtu:1500 metric:1eth1 Link en Cap:ethernet HWaddr 08:00:27:a7:8d:47 inet addr:10.168.56.10 bcast:10.168.56.255 mask:255.255.255.0 Up broadcast RUNNING multicast mtu:1500 metric:1 RX packets:160605 errors:0 dropped:0 overruns:0 frame:0 Tx packets:138115 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 TXqueuelen:1000 RX bytes:110366405 (105.2 MiB) TX bytes:78901336 (75.2 MiB) lo Link encap:local Loopback inet addr:127.0.0.1 mask:255.0.0.0 up LOOPBACK RUNNING mtu:16436 metric:1 RX packets:66508 Err ors:0 dropped:0 overruns:0 frame:0 TX packets:66508 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:28270677 (26.9 MiB) TX bytes:28270677 (26.9 MiB)
Restart the monitor:
[[email protected] ~]$ srvctl stop listener[[email protected] ~]$ srvctl start listener
View Status:
[[email protected] ~]$ lsnrctl statuslsnrctl for linux:version 11.2.0.1.0-production on 21-JAN-2016 10:07:18Copyri Ght (c) 1991, Oracle. All rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC) (Key=listener)) STATUS of the LISTENER------------------------Alias listenerversion Tnslsnr for Linux:version 11. 2.0.1.0-productionstart Date 21-jan-2016 10:07:10uptime 0 days 0 hr. 0 min. 8 sectrace Level offsecurity on:local OS authenticationsnmp offlistener Paramet ER file/u01/app/11.2.0/grid/network/admin/listener.oralistener Log file/u01/app/11.2.0/grid/log/diag/tnslsnr/r ac1/listener/alert/log.xmllistening Endpoints Summary ... (Description= (address= (PROTOCOL=IPC) (Key=listener))) (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))) (Description= (address= (protocol=tcp) (host=192.168.56.12) (port=1521))) The ListenerSupports no servicesthe command completed successfully
No service? Register below:
alter system register;
View monitoring and Cluster status:
[[email protected] ~]$ lsnrctl statuslsnrctl for linux:version 11.2.0.1.0-production on 21-JAN-2016 10:09:28Copyri Ght (c) 1991, Oracle. All rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC) (Key=listener)) STATUS of the LISTENER------------------------Alias listenerversion Tnslsnr for Linux:version 11. 2.0.1.0-productionstart Date 21-jan-2016 10:07:10uptime 0 days 0 hr. 2 min. sectrac E level offsecurity on:local OS authenticationsnmp offlistener Parame ter File/u01/app/11.2.0/grid/network/admin/listener.oralistener Log file/u01/app/11.2.0/grid/log/diag/tnslsnr/ rac1/listener/alert/log.xmllistening Endpoints Summary ... (Description= (address= (PROTOCOL=IPC) (Key=listener))) (Description= (address= (protocol=tcp) (host=127.0.0.1) (port=1521))) (Description= (address= (protocol=tcp) (host=192.168.56.12) (port=1521))) Services SumMary ... Service "+asm" has 1 instance (s). Instance "+asm1", status ready, have 1 handler (s) for the This service ... Service "ORCL" has 1 instance (s). Instance "ORCL1", status ready, have 1 handler (s) for the This service ... Service "Orclxdb" has 1 instance (s). Instance "ORCL1", status ready, have 1 handler (s) for the This service ... The command completed successfully[[email protected] ~]$ crsctl Status Res- T--------------------------------------------------------------------------------NAME TARGET State SERVE R state_details--------------------------------------------------------------------------------Lo Cal Resources--------------------------------------------------------------------------------ORA.DATA.DG ONL INE online Rac1 Online online rac2 Ora. FRA.DG Online Online Rac1 Online online Rac2 Ora. Listener.lsnr Online online Rac1 online onlin E rac2 ora.asm Online online Rac1 S tarted Online online rac2 Started ora.eons Online online rac1 Online online rac2 ORA.GSD OFFLINE OFFLINE Rac1 OFFLINE OFFLINE rac2 ora.net1.network Online Online Rac1 Online Online Rac2 Ora.ons Online Online Rac1 Online Online RAC2------ --------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.orcl.db 1 ONLINE Online Rac1 Open 2 online online rac2 Ope N ora.rac1.vip 1 Online online Rac1 ORA.RAC2.VIP 1 Online Online Rac2
It looks like everything is OK.
crs-2527:unable to start ' Ora. Listener.lsnr ' because it had a ' hard ' dependency on ' ORA.CLUSTER_VIP