[ORACLE] 리스너 로깅 on/off 설정 방법

 

오라클은 리스너를 통해 접속하는 모든 세션에 대해 listener.log 라는 파일에 로깅합니다.
상황에 따라 로깅을 중지하거나 다시 시작해야 하는 경우가 있는데 리스너 로깅 on/off 방법에 대해 정리하였습니다

리스너 로깅 OFF

 
[oracle@svr1 ~]$ lsnrctl set log_status off

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-SEP-2021 20:34:18

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to OFF
The command completed successfully

-- 상태 확인
[oracle@svr1 ~]$ lsnrctl show log_status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-SEP-2021 20:34:21

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to OFF
The command completed successfully

리스너 로깅 ON

 
[oracle@svr1 ~]$ lsnrctl set log_status on

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-SEP-2021 20:34:39

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to ON
The command completed successfully

-- 상태 확인
[oracle@svr1 ~]$ lsnrctl show log_status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-SEP-2021 20:34:41

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter "log_status" set to ON
The command completed successfully
[oracle@svr1 ~]$