TNS-01251: Cannot set trace/log directory under ADR

11204 RAC 环境报错 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? ? ? ? ? ? <<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