暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

TNS-00525: Insufficient privilege for operation

修改配置监听端口

srvctl stop listener -l LISTENER
srvctl remove listener -l LISTENER
srvctl add listener -l LISTENER -p 1520

配置之后启动监听

srvctl start listener -l LISTENER 

启动报错如下[其中1节点上监听起不来]

PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-5016: Process "/oracle/app/11.2.0/grid/bin/lsnrctl" spawned by agent "/oracle/app/11.2.0/grid/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/oracle/app/11.2.0/grid/log/orcl1/agent/crsd/oraagent_grid//oraagent_grid.log"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'orcl1' failed

oraagent_grid.log 日志如下:

[ora.LISTENER.lsnr][start] (:CLSN00010:)Log messages written to /oracle/app/grid/diag/tnslsnr/orcl1/listener/alert/log.xml
[ora.LISTENER.lsnr][start] (:CLSN00010:)Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
[ora.LISTENER.lsnr][start] (:CLSN00010:)TNS-12555: TNS:permission denied
[ora.LISTENER.lsnr][start] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
[ora.LISTENER.lsnr][start] (:CLSN00010:)  TNS-00525: Insufficient privilege for operation
[ora.LISTENER.lsnr][start] (:CLSN00010:)   Linux Error: 1: Operation not permitted
[ora.LISTENER.lsnr][start] (:CLSN00010:)
[ora.LISTENER.lsnr][start] (:CLSN00010:)Listener failed to start. See the error message(s) above...

[ora.LISTENER.lsnr][check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
[ora.LISTENER.lsnr][check] (:CLSN00010:)TNS-12541: TNS:no listener
[ora.LISTENER.lsnr][check] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
[ora.LISTENER.lsnr][check] (:CLSN00010:)  TNS-00511: No listener
[ora.LISTENER.lsnr][check] (:CLSN00010:)   Linux Error: 111: Connection refused

解决方法:

# 1 提示权限不足,检查grid用户$TNS_ADMIN的权限
# 2 停掉节点1上的集群
crsctl stop crs
# 3 删除/tmp/.oracle和/var/tmp/.oracle
rm -rf /tmp/.oracle
rm -rf /var/tmp/.oracle
# 4 重启集群
crsctl start crs
# 5 查看监听 监听能正常起动
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论