오라클 리스너 로그 경로 변경방법

OS환경 : Oracle Linux 7.6 (64bit)

DB 환경 : Oracle Database 19.3.0.0

방법 : 오라클 리스너 로그 경로 변경방법

리스너 로그가 저장되는 위치는 기본은 diag 경로 및 tnslsnr 경로임

하지만 로그 위치를 변경 해야하는 경우도 있기때문에 해당 게시글을 작성함

diag 경로 확인

SQL> show parameter diag
 
NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest              string     /oracle/app/oracle

기존 리스너 경로 확인

$ lsnrctl status
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-MAY-2020 00:59:08
 
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
 
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                24-APR-2020 22:59:24
Uptime                    11 days 1 hr. 59 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/ORACLE19/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE19)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "ORCL19" has 1 instance(s).
  Instance "ORCL19", status READY, has 1 handler(s) for this service...
Service "ORCL19XDB" has 1 instance(s).
  Instance "ORCL19", status READY, has 1 handler(s) for this service...
The command completed successfully

현재

리스너 파라미터 파일 경로는 /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/ 이고

리스너 로그 파일 경로는 /oracle/app/oracle/diag/tnslsnr/ORACLE19/listener/~ 임

리스너 종료

$ lsnrctl stop
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-MAY-2020 01:03:07
 
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
 
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

리스너 파일 수정

리스너 로그 파일을 /home/oracle/oratrace에 남기고 싶은 경우 아래처럼 ADR_BASE_LISTENER 파라미터를 추가해줌

$ vi /oracle/app/19.3/grid/network/admin/listener.ora
기존
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE19)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
 
변경
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE19)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
 
ADR_BASE_LISTENER=/home/oracle/oratrace

리스너 시작

$ lsnrctl start
 
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-MAY-2020 01:11:05
 
Copyright (c) 1991, 2018, Oracle.  All rights reserved.
 
Starting /oracle/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /home/oracle/oratrace/diag/tnslsnr/ORACLE19/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE19)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE19)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                06-MAY-2020 01:11:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /home/oracle/oratrace/diag/tnslsnr/ORACLE19/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLE19)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

리스너 로그 경로가 /home/oracle/oratrace/diag/tnslsnr/ORACLE19/listener/ 로 변경됨

참조 :