云数据库-oracle的rac的listener.ora-不能手工修改-是系统自动维护的-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

云数据库-oracle的rac的listener.ora-不能手工修改-是系统自动维护的

2016-09-30 16:29:09 6740 0
性能优化/故障排除/长期代维     云库管     www.yundba.com




有网友在oracle rac上,手工修改了listener.ora文件的内容,导致crs在启停时报错

现象如下:
"crsctl stop crs" fails stopping listener:
# crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racnode2'
CRS-2673: Attempting to stop 'ora.crsd' on 'racnode2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'racnode2'
......
CRS-2677: Stop of 'ora.racnode2.vip' on 'racnode2' succeeded
......
CRS-5014: Agent "/u01/app/grid/product/11.2.0.2/grid/bin/oraagent.bin" timed out starting process "/u01/app/grid/product/11.2.0.2/grid/bin/lsnrctl" for action "check": details at "(:CLSN00009:)" in "/u01/app/grid/product/11.2.0.2/grid/log/racnode2/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5017: The resource action "ora.LISTENER.lsnr check" encountered the following error:
(:CLSN00009:)Utils:execCmd aborted

CRS-2675: Stop of 'ora.LISTENER.lsnr' on 'racnode2' failed
CRS-2679: Attempting to clean 'ora.LISTENER.lsnr' on 'racnode2'
CRS-5014: Agent "/u01/app/grid/product/11.2.0.2/grid/bin/oraagent.bin" timed out starting process "/u01/app/grid/product/11.2.0.2/grid/bin/lsnrctl" for action "clean": details at "(:CLSN00009:)" in "/u01/app/grid/product/11.2.0.2/grid/log/racnode2/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5017: The resource action "ora.LISTENER.lsnr clean" encountered the following error:
(:CLSN00009:)Utils:execCmd aborted
......
CRS-2678: 'ora.LISTENER.lsnr' on 'racnode2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-2673: Attempting to stop 'ora.racnode1.vip' on 'racnode2'
CRS-2677: Stop of 'ora.racnode1.vip' on 'racnode2' succeeded
CRS-2799: Failed to shut down resource 'ora.LISTENER.lsnr' on 'racnode2'
CRS-2799: Failed to shut down resource 'ora.racnode2.LISTENER_racnode2.lsnr' on 'racnode2'
CRS-2794: Shutdown of Cluster Ready Services-managed resources on 'racnode2' has failed
CRS-2675: Stop of 'ora.crsd' on 'racnode2' failed
CRS-2799: Failed to shut down resource 'ora.crsd' on 'racnode2'
CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'racnode2' has failed
CRS-4687: Shutdown command has completed with errors.
CRS-4000: Command Stop failed, or completed with errors.



导致问题的原因是手工增加了
listener.ora in <Grid_Home> has the following entries for LISTENER:
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER =
   (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
        (ADDRESS = (PROTOCOL = TCP)(HOST =racnode2-vip)(PORT=1521))  
     )
   )



解决方法:

方法一、去掉手工加入部分 eg:
LISTENER =
   (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY =LISTENER))
     )
   )

方法二、(可选的方法)


用OCR中正确的定义重置重新生成listener.ora  endpoints_listener.ora 文件内容
1.  Stop the listener(s) on allnodes:
$ $GI_HOME/bin/srvctl stop listener
$ $GI_HOME/bin/srvctl stop scan_listener
2.  Remove the listener.or andendpoints_listener.ora from the $GI_HOME/dbs directory on ALL nodes
3.  Restart the listener on allnodes:
$ $GI_HOME/bin/srvctl start listener
$ $GI_HOME/bin/srvctl start scan_listener



具体可参看官方文档
GridInfrastructure 11gR2 "crsctl stop crs" Fails at Stopping Listener(Doc ID 1284916.1)







取消 提交回答
全部回答(0)
相关问答

1

回答

基于两台ECS云服务器和共享块存储部署Oracle RAC,如何在同可用区VPC内创建心跳地址?

2020-03-12 13:15:32 1285浏览量 回答数 1

1

回答

请教一下,我用pgpool-Ⅱ做PG的一主两从同步+高可用,替代oracle rac这个方案可行嘛

2019-01-27 17:45:01 3103浏览量 回答数 1

2

回答

[@徐雷frank][¥20]传统oracle rac+weblogic集群+客户端瓶颈怎么升级?

2018-12-14 12:00:51 1709浏览量 回答数 2

4

回答

阿里云目前支持oracle rac吗?

2018-09-05 11:15:01 4713浏览量 回答数 4

2

回答

请问ECS是否支持部署oracle rac

2018-08-13 16:57:04 2093浏览量 回答数 2

1

回答

阿里云能搭建Oracle RAC环境吗?

2017-07-14 00:09:09 3278浏览量 回答数 1

1

回答

oracle集群部署,比如rac,磁盘共享如何解决

2017-01-18 08:04:45 3929浏览量 回答数 1

0

回答

现在阿里云ECS可以实现安装oracle rac集群环境吗?

2015-12-24 20:25:17 9364浏览量 回答数 0

4

回答

ECS上能做Oracle的RAC集群吗?

2014-11-13 12:56:11 8824浏览量 回答数 4

1

回答

MaxCompute Spark中用Docker容器打包的作用是什么呢?

2021-12-12 17:12:54 388浏览量 回答数 1
+关注
oracle数据库技术支持www.yunDBA.com
oracle数据库技术支持服务 www.yundba.com 云库管
文章
问答
问答排行榜
最热
最新
相关电子书
更多
ORACLE 10g 数据库体系结构图
立即下载
迁移 ORACLE 最佳实践
立即下载
PolarDB的Oracle平滑迁移之路
立即下载