So what are your suggestions to this
Schekina Israel, March 04, 2008 - 11:37 am UTC
Thank you for answering so fast! I understand I cannot remove the LOCAL_LISTENER parameter from the spfile. Also We are not using the default listener configuration.
So what are your recommandations then.
How to reduce the amount of information registered in the generator.log file?
March 04, 2008 - 12:40 pm UTC
My recommendation:
o read the documentation
o figure out what level is appropriate for you - anywhere from "everything" to "nothing" is possible. Based on your system security policy, your desire (or lack thereof) to audit - what is right for you.
o implement that level.
You control it, you can turn it off, you can make it very verbose, you can make it less verbose. There is no 'recommended' setting - it depends on your needs only.
Rotation log
Deivid Bitti Padilha, March 04, 2008 - 2:53 pm UTC
Hi,
If you're using a Unix system you can create a rotation script to compress the listener.log file daily or weekly and keep how many files you desire (e.g listener.log.1.gz). Linux has the logrotate utility I use it and works perfectly, to cleanup a log file on line the command is:
"> listener.log "
I use the same solution to alert.log without problem.
Deivid
Schekina Israel, March 04, 2008 - 4:08 pm UTC
Unfortunately, we are on windows
March 04, 2008 - 7:46 pm UTC
well, you know how to limit the amount of logging or even disable it - so now you can act.
For windows
A reader, March 07, 2008 - 1:52 pm UTC
you can do a
lsnrctl>set log listener2.log
Issue resolved
Schekina Israel, March 10, 2008 - 9:51 am UTC
LSNRCTL> set current_listener xxxxx
LSNRCTL> SET LOG_STATUS OFF
Additionally, you can edit the LISTENER.ORA file and add this line: LOGGING_<listener_name> = OFF. This will do the same thing.
Please also use the below Note for further refference on this
Note 162675.1 How to disable Oracle Net Logging
March 10, 2008 - 11:46 am UTC
(well, that documentation I pointed you to read - that, that too would have taught you all of this. I see you decided "no log" is the best for you - that was left rather unstated as well....)
I give up on trying to get people to actually read the documentation so they are able to see what is available to them.
Issue resolved
Schekina Israel, March 10, 2008 - 9:51 am UTC
LSNRCTL> set current_listener xxxxx
LSNRCTL> SET LOG_STATUS OFF
Additionally, you can edit the LISTENER.ORA file and add this line: LOGGING_<listener_name> = OFF. This will do the same thing.
Please also use the below Note for further refference on this
Note 162675.1 How to disable Oracle Net Logging
Schekina Israel, March 10, 2008 - 12:29 pm UTC
Thanks for all
Windows Server 2008 update
Allen, February 26, 2013 - 2:03 pm UTC
Note: if you try " set log_file listener2.log " and get "user is not authorized to perform this task" then go to the start button, righ click on MS DOS window and left click on "Run As Administrator"
Yea just learned that one the hard way. My user ID is in the "local admin group" on the server. This is just an extra step to open MS DOS window with full admin authority.
This also applies to " set log_file listener2.log " as well.