Database - RAC/Scalability (MOSC)

MOSC Banner

Enable SQL Trace in RAC listeners

edited Feb 4, 2019 9:53PM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Hi,

We need to enable SQL Trace in our 2 Node RAC 12.2.0.1 environment. My question is do we have to enable this tracing for all the listeners? We are using scan listeners as follows:

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3))))
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2))))
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))

This doc id (Doc ID 1325284.1)) gives good instruction to enable it and I feel comfortable doing it  from within lsnrctl. So my question is since you have to make each of them a default listener based on this

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center