Enable SQL Trace in RAC listeners
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