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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.