Until 11g there is no option to rotate the alert/listener.log ( text format). ADRCI has purge option to housekeep the old listener/alert.xml file. infact *.log ( text format) is there for downward compatibility.
DBAs housekeep the listener.log using various methods like
1. cat /dev/null >listener.log ( after taking backup)
2. split the listener.log file and remove the old contents using text editor like vi....
3. temporarily off the log off and take backup of the file and cat /dev/null the listener.log
Sometime by mistake we remove the listener.log and oracle stop writting into the listener.log even if we create a file with the same name.It is because the listener process has the file descriptor open and it will keep open it even if we remove the file.Because of that you can notice the filesystem where the listener log resides doesnot release the space even afetr the removal of file.
There is a workaround to fix this without stop and start the listener. Just stop and start the log_status.
lsrnctl > set current_listener LISTENER_ABC1
LSNRCTL> set current_listener LISTENER_ABC1
Current Listener is LISTENER_ABC1
LSNRCTL> set current_listener LISTENER_ABC1
Current Listener is LISTENER_ABC1
LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ABC1))
LISTENER_ABC1 parameter "log_status" set to OFF
The command completed successfully
LSNRCTL> set log_status on
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ABC1))
LISTENER_ABC1 parameter "log_status" set to ON
The command completed successfully
now you can see the listener.log will be updated by listener process.
Dear Friends, The content in this blog are purely based on my own opinion ,it is not reflecting any of my current or previous employers materials or official documents. All my posts here are not warranted to be free of errors. Please use at your own risk and after thorough testing in your environment. If you feel that i am violating any of the company's policies or documents, kindly mail me at jeyaseelan.hi@gmail.com,I am happy to take out those content from this blog.
Subscribe to:
Post Comments (Atom)
-
We may not be able to disable the logtransport when the database is in maximum availabilty mode. We may get the below error DGMGRL...
-
Error Messages: We may get the following error messages while doing ASM operations ORA-15137: The ASM cluster is in rolling patch state....
-
MIRA - Multi Instance Redo Apply - 12cR2 onwards/18C With Oracle 12c Release 2, We can enable Multi Instance Redo apply ( MIR...
Simply desire to say your article is as amazing.
ReplyDeleteThe clearness in your post is just spectacular and i could
assume you are an expert on this subject. Fine with your permission let
me to grab your feed to keep up to date with forthcoming post.
Thanks a million and please keep up the enjoyable work.
Safe Garcinia
It's amazing in favor of me to have a web page, which is useful in favor of my know-how. thanks admin
ReplyDeletebuy Dermallo
Nice blog here! Also your website loads up fast!
ReplyDeleteWhat host are you using? Can I get your affiliate link to your host?
I wish my website loaded up as fast as yours lol
Goji Berry Reviews