리스너 로그(Listener.log,log.xml)

11gR2 버전에서 파일시스템 용량이 90%가 넘게되서 확인결과, 로그 디렉토리의 용량때문이었습니다.

 

11gR2버전을 기준으로 로그가 쌓이는 디렉토리는 아래와 같습니다.

$ORACLE_BASE/diag/tnslsnr/hostname/listener/alert/log.xml

 

리스너 로그 확인 : Listener Log File의 경로를 확인합니다.

$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-DEC-2020 19:36:39

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                21-DEC-2020 18:27:43
Uptime                    8 days 1 hr. 8 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ysbae/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ysbae)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ysbae)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

 

listener.log와 log.xml파일 두가지가 크게 로그가 쌓이는 파일로 확인됩니다.

listener.log는 trace디렉토리 밑에 위치하고,  log.xml은 alert 디렉토리 밑에 위치합니다.

 

 

오라클 문서는 참고차 첨부합니다. 10g용입니다.

Oracle Database Net Services Administrator’s Guide.pdf

2.74MB

listener.log

리스너와 관련된 로그가 저장되며 자주 보이는 service_update * XE * 0 의 의미는 pmon이 인스턴스 정보를 주기적으로 리스너에 update한다는 의미로 쌓이는 로그입니다.

 

 

$ tail -100f listener.log
29-DEC-2020 17:21:20 * service_update * XE * 0
Tue Dec 29 17:22:14 2020
29-DEC-2020 17:22:14 * service_update * XE * 0
Tue Dec 29 17:31:21 2020
29-DEC-2020 17:31:21 * service_update * XE * 0
Tue Dec 29 17:31:33 2020
29-DEC-2020 17:31:33 * service_update * XE * 0
Tue Dec 29 17:32:24 2020
29-DEC-2020 17:32:24 * service_update * XE * 0
Tue Dec 29 17:40:31 2020
29-DEC-2020 17:40:31 * service_update * XE * 0
Tue Dec 29 17:41:22 2020
29-DEC-2020 17:41:22 * service_update * XE * 0
Tue Dec 29 17:45:31 2020
29-DEC-2020 17:45:31 * service_update * XE * 0
Tue Dec 29 17:51:23 2020
29-DEC-2020 17:51:23 * service_update * XE * 0
Tue Dec 29 17:52:20 2020
29-DEC-2020 17:52:20 * service_update * XE * 0
Tue Dec 29 18:00:17 2020
29-DEC-2020 18:00:17 * service_update * XE * 0
Tue Dec 29 18:00:32 2020
29-DEC-2020 18:00:32 * service_update * XE * 0
Tue Dec 29 18:01:23 2020
29-DEC-2020 18:01:23 * service_update * XE * 0
Tue Dec 29 18:05:03 2020
29-DEC-2020 18:05:03 * service_update * XE * 0
Tue Dec 29 18:05:33 2020
29-DEC-2020 18:05:33 * service_update * XE * 0
Tue Dec 29 18:11:24 2020
29-DEC-2020 18:11:24 * service_update * XE * 0
Tue Dec 29 18:14:42 2020
29-DEC-2020 18:14:42 * service_update * XE * 0
Tue Dec 29 18:15:33 2020
29-DEC-2020 18:15:33 * service_update * XE * 0
Tue Dec 29 18:18:18 2020
29-DEC-2020 18:18:18 * service_update * XE * 0
Tue Dec 29 18:20:01 2020
29-DEC-2020 18:20:01 * service_update * XE * 0
Tue Dec 29 18:20:34 2020
29-DEC-2020 18:20:34 * service_update * XE * 0
Tue Dec 29 18:21:25 2020
29-DEC-2020 18:21:25 * service_update * XE * 0
Tue Dec 29 18:30:31 2020
29-DEC-2020 18:30:31 * service_update * XE * 0
Tue Dec 29 18:31:25 2020
29-DEC-2020 18:31:25 * service_update * XE * 0
29-DEC-2020 18:31:31 * service_update * XE * 0
Tue Dec 29 18:35:02 2020
29-DEC-2020 18:35:02 * service_update * XE * 0
Tue Dec 29 18:35:32 2020
29-DEC-2020 18:35:32 * service_update * XE * 0
Tue Dec 29 18:36:44 2020
29-DEC-2020 18:36:44 * service_update * XE * 0
Tue Dec 29 18:41:26 2020
29-DEC-2020 18:41:26 * service_update * XE * 0
Tue Dec 29 18:45:32 2020
29-DEC-2020 18:45:32 * service_update * XE * 0
Tue Dec 29 18:50:33 2020
29-DEC-2020 18:50:33 * service_update * XE * 0
Tue Dec 29 18:51:27 2020
29-DEC-2020 18:51:27 * service_update * XE * 0
Tue Dec 29 18:55:33 2020
29-DEC-2020 18:55:33 * service_update * XE * 0
Tue Dec 29 19:00:33 2020
29-DEC-2020 19:00:33 * service_update * XE * 0
Tue Dec 29 19:01:27 2020
29-DEC-2020 19:01:27 * service_update * XE * 0
Tue Dec 29 19:05:31 2020
29-DEC-2020 19:05:31 * service_update * XE * 0
Tue Dec 29 19:11:28 2020
29-DEC-2020 19:11:28 * service_update * XE * 0
Tue Dec 29 19:15:31 2020
29-DEC-2020 19:15:31 * service_update * XE * 0
Tue Dec 29 19:21:29 2020
29-DEC-2020 19:21:29 * service_update * XE * 0
Tue Dec 29 19:25:32 2020
29-DEC-2020 19:25:32 * service_update * XE * 0
Tue Dec 29 19:30:32 2020
29-DEC-2020 19:30:32 * service_update * XE * 0
Tue Dec 29 19:31:30 2020
29-DEC-2020 19:31:30 * service_update * XE * 0
Tue Dec 29 19:35:33 2020
29-DEC-2020 19:35:33 * service_update * XE * 0
Tue Dec 29 19:36:36 2020
29-DEC-2020 19:36:36 * service_update * XE * 0
WARNING: Subscription for node down event still pending
29-DEC-2020 19:36:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ysbae)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
Tue Dec 29 19:38:24 2020
29-DEC-2020 19:38:24 * service_update * XE * 0
Tue Dec 29 19:40:36 2020
29-DEC-2020 19:40:36 * service_update * XE * 0
Tue Dec 29 19:41:30 2020
29-DEC-2020 19:41:30 * service_update * XE * 0
Tue Dec 29 19:45:34 2020
29-DEC-2020 19:45:34 * service_update * XE * 0
Tue Dec 29 19:48:36 2020
29-DEC-2020 19:48:36 * log_status * 0
Tue Dec 29 19:50:31 2020
29-DEC-2020 19:50:31 * service_update * XE * 0
Tue Dec 29 19:51:31 2020
29-DEC-2020 19:51:31 * service_update * XE * 0

 

 

log.xml

이 로그는 ADRCI용 로그입니다. XML형식으로 저장되고, log.xml은 현재 저장되고 있는 파일이고, log_n.xml은 이전 파일들이 아카이빙되서 저장된 파일들입니다. 자동적으로 삭제해주지 않으므로 용량이 커지면 수동으로 삭제를 해줘야 합니다.

 

$ tail -100f log.xml
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:15:31 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:21:29.430-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:21:29 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:25:32.663-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:25:32 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:30:32.974-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:30:32 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:31:30.051-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:31:30 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:35:33.429-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:35:33 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:36:36.496-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:36:36 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:36:39.082-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>WARNING: Subscription for node down event still pending
 </txt>
</msg>
<msg time='2020-12-29T19:36:39.082-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:36:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=ysbae)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
 </txt>
</msg>
<msg time='2020-12-29T19:38:24.602-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:38:24 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:40:36.737-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:40:36 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:41:30.784-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:41:30 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:45:34.045-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:45:34 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:48:36.843-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:48:36 * log_status * 0
 </txt>
</msg>
<msg time='2020-12-29T19:50:31.454-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:50:31 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:51:31.514-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:51:31 * service_update * XE * 0
 </txt>
</msg>
<msg time='2020-12-29T19:52:49.601-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='ysbae'
 host_addr='192.168.56.58'>
 <txt>29-DEC-2020 19:52:49 * service_update * XE * 0
 </txt>
</msg>

 

리스너 로그 기록하지 않게 파라미터 변경방법

 

출처 : positivemh.tistory.com/172

1.리스너 접속
$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-DEC-2020 19:48:12


2.가동중인 리스너로 변경(LISTENER에 사용중인 리스너 이름 넣기)
LSNRCTL> set current_listener LISTENER
Current Listener is LISTENER

3.log_status 를 OFF로 만들기
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
LISTENER parameter "log_status" set to OFF
The command completed successfully

4.삭제 or 백업작업 하기

5.log_status를 ON으로 만들기
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
LISTENER parameter "log_status" set to ON
The command completed successfully

 

리스너로그(listener.log) 파일 경로 변경방법

 

경로를 default에서 변경하려고 하면 listener.ora에 파라미터 추가 후 리스너를 재기동하면 됩니다.

$ vi listener.ora

--아래 내용 추가
LOG_FILE_LISTENER=listener_test.log
LOG_DIRECTORY_LISTENER=/tmp


--리스너 재기동

$ lsnrctl reload

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 29-DEC-2020 20:06:14

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
The command completed successfully


--/tmp 디렉토리에 listener_test.log로 생성되고 있는지 확인
$ ls -al listener_test.log
-rw-r----- 1 oracle dba 411 Dec 29 20:07 listener_test.log
$ pwd
/tmp