TNS-01251: Cannot set trace/log directory under ADR, tns-01251adr
11204 RAC environment error 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
Solution:
Determine the listener Name:
Keeoradb001a:/home/grid $ ps-ef | grep tns
Grid 12058650 1 1 Sep 02-128:13/u01/app/11.2.0/grid/bin/tnslsnrLISTENER-inherit
Grid 14024914 1 0 Sep 02-32: 48/u01/app/11.2.0/grid/bin/tnslsnrLISTENER_SCAN1-inherit
Add the following three lines to the listener configuration file:
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,201 3, 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,201 3, 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 <The oracle user's home directory has no write permission
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER )))
The 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 <change to the home Directory of the grid or other directories with write permission.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER )))
Listener parameter "trc_directory" set to/home/grid/trace
The command completed successfully
Bytes -------------------------------------------------------------------------------------------------
This article comes from my technical blog http://blog.csdn.net/robo23
For reprinting, please mark the source text link; otherwise, you will be held legally responsible!