Steaming Tech: Oracle : Empty listener log

Tuesday 31 March 2009

Oracle : Empty listener log

http://boomslaang.wordpress.com/2007/11/07/ooops/

Temporarily stop logging

lsnrctl
set current_listener <ListenerName>
set log_status=off

Move and recreate log file

mv <logfile> <logfile>.old
touch <logfile>

Restart logging

lsnrctl
set current_listener <ListenerName>
set log_status=on

Check entries re-appearing in logfile

Fini

0 comments:

Subscribe to: Post Comments (Atom)