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
-------------------------------------------------------------------------------------------------
本文来自于我的技术博客
转载请标注源文链接,否则追究法律责任!