skip to main content

SAP NetWeaver Newbie

Turning Oracle Listener Logging Off

You might want to avoid performance overhead due to logging on listener. The following steps will show you how to disable logging.

1) Take a backup of the current listener.ora file in $ORACLE_HOME/network/admin as ora<SID> user
2) Update the listener.ora file with parameter as ora<SID> user.
LOGGING_<LISTENER NAME> = OFF
Replace <LISTENER NAME> with the current Listenername with match case.
e.g
LOGGING_LISTENER = OFF
save the listener.ora file
3) Enter the Listener control utility and reload the config as ora<SID> user.
lsnrctl
reload
4) In the Listener control utility run the stat command to ensure listener log entry is not visable
lsnrctl
stat
there should be no line entry starting
Listener Log File

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.