TNS-01251:Cannotsettrace/logdirectoryunderADR

11204 RAC 環境報錯 TNS-01251: Cannot set trace/log directory under ADR

首頁 → 數據庫技術

背景：

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

[日期：2015-01-29] 來源：Linux社區 作者：robo23 [字體：]

11204 RAC 環境報錯 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

解決辦法：

確定監聽器名稱:

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

添加以下三行至監聽器配置文件 :

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, 2013, 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, 2013, 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)))
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

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

Oracle性能優化 之 共享池

本文永久更新鏈接地址：

ORA-21561:OID generation failed

Oracle 11.2.0.4 RAC日志記錄的時間與操作系統時間不一致

相關資訊 TNS-01251

圖片資訊

本文評論 　　查看全部評論 (0)

評論聲明

最新資訊

本周熱門

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com