CRS-2527: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on 'ora.cluster_vip
来源:互联网 发布:淘宝达人机构申请 编辑:程序博客网 时间:2024/05/16 06:53
今天在做OCR以及VD盘恢复的时候,节点一的监听起不来:
[grid@rac1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JAN-2016 07:57:49Copyright (c) 1991, 2009, 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 Linux Error: 2: No such file or directory[grid@rac1 admin]$ srvctl start listenerPRCR-1079 : Failed to start resource ora.LISTENER.lsnrCRS-2527: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on 'ora.cluster_vip_net1.type'CRS-2525: All instances of the resource 'ora.rac2.vip' are already running; relocate is not allowed because the force option was not specified
集群状态:
[grid@rac2 rac2]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.FRA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr OFFLINE OFFLINE rac1 ONLINE ONLINE rac2 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 ora.rac2.vip 1 ONLINE ONLINE rac2
很幸运的,重启也没有把监听起来:
[grid@rac2 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE 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 rac2 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>[grid@rac1 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac2
看看网络:
[root@rac1 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 packets: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 (694.4 KiB) TX bytes:1035971 (1011.6 KiB)eth1 Link encap: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: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:97711630 (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)
[oracle@rac1 ~]$ srvctl config vip -n rac1PRKO-2310 : VIP does not exist on node rac1.没啥给啥: [root@rac1 bin]# ./srvctl add vip -n rac1 -A 192.168.56.12/255.255.255.0/eth0 -k 1
等一会[root@rac1 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 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 (783.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.12 Bcast:192.168.56.255 Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1eth1 Link encap: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 errors: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)
重启一下监听:
[grid@rac1 ~]$ srvctl stop listener[grid@rac1 ~]$ srvctl start listener
查看状态:
[grid@rac1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JAN-2016 10:07:18Copyright (c) 1991, 2009, 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 Parameter 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)))The listener supports no servicesThe command completed successfully
没服务?注册下下:
alter system register;
查看监听以及集群状态:
[grid@rac1 ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JAN-2016 10:09:28Copyright (c) 1991, 2009, 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. 18 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter 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, has 1 handler(s) for this service...Service "orcl" has 1 instance(s). Instance "orcl1", status READY, has 1 handler(s) for this service...Service "orclXDB" has 1 instance(s). Instance "orcl1", status READY, has 1 handler(s) for this service...The command completed successfully[grid@rac1 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.FRA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 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 ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2
看起来,everything is ok了。
0 0
- CRS-2527: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on 'ora.cluster_vip
- oracle crs中监听资源状态异常(ora.LISTENER.lsnr)
- CRS-0215: Could not start resource 'ora.rac3.LISTENER_RAC3.lsnr'
- ora.LISTENER.lsnr INTERMEDIATE 处理一例
- 红旗linux下的 CRS-2674: Start of 'ora.registry.acfs' on '4a' failed
- ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` has experienced an unrecoverable failure
- CRS-2800: Cannot start resource 'ora.DATADG.dg' as it is already in the INTERMEDIATE state on se
- ora.LISTENER.lsnr INTERMEDIATE Not All Endpoints Registered
- Oracle10gRAC error:'ora.o10n1.LISTENER_O10N1.lsnr' has placement error.
- rac1启动报错CRS-2674: Start of 'ora.rac.db' on 'rac1' failed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- 12c dbca CRS-2674: Start of 'ora.orcl.db' on 'rac1' failed ORA-01017: invalid username/password; log
- Referenced Assembly could not be resolved because it has a dependency conflict 解决方法
- RAC其中一个节点监听没有起来的解决方案【ora.LISTENER.lsnr INTERMEDIATE】
- 解决DGMGRL Unable to connect to database ORA-12541: TNS:no listener问题
- C++学习之继承篇(多继承与多重继承)
- 从零开始配置Jenkins(三)——用户权限管理
- 自定义html标签属性,并通过JQuery获取
- UOJ169. 【UR #11】元旦老人与数列
- 【 bzoj 3514 】Codechef MARCH14 GERALD07加强版 - LCT
- CRS-2527: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on 'ora.cluster_vip
- 开源监控软件ganglia安装手册
- java实现排序二叉树
- HTML5:组织内容
- CNN卷积神经网络的改进(15年最新paper)
- opencv图像处理基本操作
- java请求第三方接口
- 整合 spring 4(包括mvc、context、orm) + mybatis 3 示例
- const int **pp = &p;