TNS-01251:Cannotsettrace/logdirectoryunderADR
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了TNS-01251:Cannotsettrace/logdirectoryunderADR,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3720字,纯文字阅读大概需要6分钟。
内容图文
11204 RAC 环境报错 TNS-01251: Cannot set trace/log directory under ADR
首页 → 数据库技术
背景:
阅读新闻
TNS-01251: Cannot set trace/log directory under ADR
[日期:2015-01-29] 来源:Linux社区 作者:robo23 [字体:]
11204 RAC 环境报错 TNS-01251: Cannot set trace/log directory under ADR
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> set trc_level 16
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
listener parameter "trc_level" set to support
The command completed successfully
LSNRCTL> set trc_directory /home/Oracle
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-01251: Cannot set trace/log directory under ADR
LSNRCTL> set trc_directory /home/grid/trace
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
TNS-01251: Cannot set trace/log directory under ADR
解决办法:
确定监听器名称:
keeoradb001a:/home/grid$ps -ef | grep tns
grid 12058650 1 1 Sep 02 - 128:13 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
grid 14024914 1 0 Sep 02 - 32:48 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
添加以下三行至监听器配置文件 :
keeoradb001a:/home/grid$lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-OCT-2014 08:50:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
Start Date 02-SEP-2014 04:41:27
Uptime 50 days 4 hr. 8 min. 49 sec
Trace Level support
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/network/log/listener.log
--------------------------------
DIAG_ADR_ENABLED_LISTENER=OFF
DIAG_ADR_ENABLED_LISTENER_SCAN1=OFF
LOG_DIRECTORY_listener_name = /home/grid/trace
--------------------------------
keeoradb001a:/home/grid$lsnrctl reload
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-OCT-2014 08:51:15
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> set current_listener listener
LSNRCTL> set trc_level 16
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
listener parameter "trc_level" set to support
The command completed successfully
LSNRCTL> set trc_directory /home/oracle <<<oracle用户家目录没有写权限
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
SNL-00016: snlfohd: error opening file
NL-00231: error in file open
NL-00508: cannot open trace file
NL-00511: error opening trace file /home/oracle/listener.trc
LSNRCTL> set trc_directory /home/grid/trace <<<换成grid自己的家目录或其他有写权限的目录即可
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
listener parameter "trc_directory" set to /home/grid/trace
The command completed successfully
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
Oracle性能优化 之 共享池
本文永久更新链接地址:
ORA-21561:OID generation failed
Oracle 11.2.0.4 RAC日志记录的时间与操作系统时间不一致
相关资讯 TNS-01251
图片资讯
本文评论 查看全部评论 (0)
评论声明
最新资讯
本周热门
内容总结
以上是互联网集市为您收集整理的TNS-01251:Cannotsettrace/logdirectoryunderADR全部内容,希望文章能够帮你解决TNS-01251:Cannotsettrace/logdirectoryunderADR所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。