Q

How to trim the Oracle listener log in Unix/Linux

Want to trim your Oracle listener log? Oracle expert Brian Peasland explains how to do so in Unix/Linux servers without bouncing the listener.

How do I trim the Oracle listener log? My database is 24*7 and if I move the file I have to bounce the listener.
In Unix/Linux servers, I do the following:

cp listener.log listener_copy.log
cp /dev/null listener.log

The above makes a copy of the listener log and then overwrites the log with an empty file, thus zeroing out the log's contents. If you do not need the old copy, you can remove it, or skip the first copy command above.

This was first published in June 2009

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close