Manage

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.

Brian Peasland

By

Brian Peasland

Published: 05 Jun 2009

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.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

The pros and cons of big data outsourcing
More companies are seeking outside help to capitalize on data's value. Examine the benefits and drawbacks that come with ...
7 data modeling techniques and concepts for business
Three types of data models and seven data modeling techniques are available to data management teams to convert mountains of ...
Couchbase NoSQL database adds relational capabilities
With its latest update, Couchbase introduced features that bring the equivalent of tables and schema to its database to reduce ...

SearchBusinessAnalytics

SAS planning an IPO after rumored acquisition talks end
The longtime independent analytics vendor, which just two weeks ago was in negotiations to get acquired, revealed plans to, ...
Successful digital transformation strategies start with data
Data has become a natural resource essential to business ops. Companies need to consider four digital transformation elements ...
Sisense unveils Extense Framework to enable embedded BI
After rebranding its platform early in 2021 to reflect a heightened focus on embedded analytics, Sisense introduced a set of new ...

SearchSAP

IT complexity slows S/4HANA migration pace
Most S/4HANA projects are being held up by the complexity of SAP system environments, and organizations need to fully understand ...
Deloitte SAP Industry Cloud apps aim to fill ERP gaps
The head of Deloitte's $4 billion SAP practice explains the consultancy's role in SAP's new industry applications and how Kinetic...
Rise with SAP won't move S/4HANA needle for large customers
Rise with SAP is good for smaller companies, but if Rise is going to be a success, SAP will need to figure out how to attract its...

SearchSQLServer

SQL Server database design best practices and tips for DBAs
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...
SQL Server in Azure database choices and what they offer users
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

Introduction to Docker quiz
These Docker questions and answers will test your knowledge of the fundamentals of Docker, but it won't be easy. Take this quiz ...
Library vs. framework: How these software artifacts differ
Libraries are low-level components that deliver a specific function, such as establishing a network connection. A framework is a ...
Java naming conventions, explained
You could start a Java variable with a dollar sign, but no one does. When you write Java code, always follow these standard Java ...

SearchDataCenter

IBM z/OS V2.5 integrates mainframes with hybrid clouds, AI
Bringing mainframes deeper into the hybrid cloud mix, IBM delivered an updated version of z/OS that makes it easier for IT pros ...
Explore the benefits of data center as a service
For organizations that might struggle to purchase and maintain their own data centers, they can turn to DCaaS, which enables them...
Data center contactless tech beyond the pandemic
No-touch tech like haptics and LiDAR became commonplace during the coronavirus pandemic, but such technology can increase demands...

SearchContentManagement

7 Microsoft Power Apps benefits for content managers
Microsoft Power Apps can improve the speed of app development and enable easier app creation, which can benefit organizations and...
What are the top Microsoft Power Apps limitations?
Organizations should understand the limitations of Microsoft Power Apps, such as licensing constraints and connection ...
Box Sign gives business users built-in digital signature tool
Box's $55 million acquisition of SignRequest in February yields a native digital signatures feature for Box Business and ...

SearchHRSoftware

Benefits and challenges of a hybrid workplace
Employees' desire for flexibility may lead organizations to explore a hybrid workplace, but hybrid work has strengths and ...
U.S. lawmaker seeks national four-day workweek
The four-day workweek could become law under legislation introduced by U.S. Rep. Mark Takano. It would require firms to pay ...
Badmouthing of federal gov hurts cybersecurity recruiting
Government and businesses are struggling with cybersecurity recruiting because of a skills shortage. The federal government's ...

Close