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

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

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/tnslsnrLISTENER -inherit
    grid 14024914        1   0   Sep 02      - 32:48 /u01/app/11.2.0/grid/bin/tnslsnrLISTENER_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            <<<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

 

-------------------------------------------------------------------------------------------------

本文來自於我的技術部落格 http://blog.csdn.net/robo23

轉載請標註源文連結,否則追究法律責任!