Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle RAC Listener log maintenance

edited Feb 7, 2024 6:26PM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center