Welcome 微信登录

首页 / 数据库 / MySQL / TNS-01251: Cannot set trace/log directory under ADR

11204 RAC 环境报错 TNS-01251: Cannot set trace/log directory under ADRLSNRCTL> 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 statusLSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-OCT-2014 08:50:16Copyright (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 reloadLSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-OCT-2014 08:51:15Copyright (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) http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle性能优化 之 共享池 http://www.linuxidc.com/Linux/2012-02/54062.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址