TNS-01251: Cannotsettrace/logdirectoryunderADR

Error TNS-01251: CannotsettracelogdirectoryunderADR

11204 RAC environment error TNS-01251: Cannot set trace/log directory under ADR

Homepage → Database Technology

Background:

Read News

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

[Date:] Source: Linux community Author: robo23 [Font:]

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 < 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 < <换成grid自己的家目录或其他有写权限的目录即可
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

0

ORA-21561: OID generation failed

Oracle 11.2.0.4 the time when RAC logs are recorded is inconsistent with the operating system time.

Information TNS-01251

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week