TNS-01251: Cannot set trace/log directory under ADR
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/tnslsnr LISTENER-inherit
Grid 14024914 1 0 Sep 02-32: 48/u01/app/11.2.0/grid/bin/tnslsnr LISTENER_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
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Sharing pool for Oracle Performance Optimization