Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle RAC Listener Logs Maintenance

user10285Feb 5 2024

Hi All,

I have three questions

a)How do i disable the xml logs created in listener_scan3/2/1 and keep only the trace files generated

For eg:

-rw-r----- 1 oracle dba 314572933 Feb 3 00:18 log_69.xml
-rw-r----- 1 oracle dba 314572937 Feb 3 14:24 log_70.xml
-rw-r----- 1 oracle dba 314572959 Feb 4 04:37 log_71.xml
-rw-r----- 1 oracle dba 314572880 Feb 4 19:00 log_72.xml
-rw-r----- 1 oracle dba 230950329 Feb 5 06:02 log.xml

b) Where can i update the parameter LOG_FILE_NUM_listener=5?

c) By setting the parameter both local listener logs & scan listener logs will be impacted?

$ lsnrctl status LISTENER_SCAN3

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-FEB-2024 06:03:19

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN3
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 23-OCT-2023 07:44:50
Uptime 104 days 23 hr. 18 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/app/19.3.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ca2uodbrac101q/listener_scan3/alert/log.xml

Thanks!!

Comments
Post Details
Added on Feb 5 2024
1 comment
532 views