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/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!

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