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

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

MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

How AI data privacy can help your enterprise

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

SearchBusinessAnalytics

Logi Analytics keeps focus on embedded app development

Kevin Greene is the new CEO of Logi Analytics after previously serving as the vendor's COO. In an interview, Greene discusses his...

Data literacy skills key to cost savings, revenue growth

As organizations develop data-driven cultures, they need to implement programs to teach employees how to work with and make ...

Yellowfin 9.3 features embedded app development upgrades

New application programming interfaces to help app designers build embedded BI apps are among more than 25 new features in the ...

SearchSAP

Decide on SAP S/4HANA Cloud: Single-tenant vs. multi-tenant edition

Understanding the benefits and limitations of S/4HANA Cloud versions is essential to making the right choice. Here are some ...

How 2 S/4HANA projects wrapped up remotely due to COVID-19

Here's how two SAP S/4HANA migration projects by De Nora Group and Vistaprint were completed on time after the COVID-19 crisis ...

Wookey returns to SAP to head Intelligent Spend unit

Industry veteran John Wookey is back at SAP to run the newly formed SAP Intelligent Spend and Business Network as SAP Ariba ...

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

3 ways to implement AI in software development

Further advancements to AI make it a more appealing and useful option for enterprise software development. Here are three ways to...

5 helpful tips to reduce webpage load time, improve performance

Nobody wants to wait for a webpage to load. Follow these tips to reduce website load time and improve the user experience for a ...

Is Apache Tomcat the right Java application server for you?

What is the best application server? The answer depends on what an enterprise is looking for. Compare Apache Tomcat to these four...

SearchDataCenter

IBM cloud revenues climb as hardware continues to decline

IBM cloud revenues continue to increase as hardware sales drop, sharpening the company's strategy to focus on hybrid cloud.

Figure out the differences of asset management vs. CMDB

There is no shortage of software options for change management tools. Operational goals can help IT teams decide if ITAM or CMDB ...

IBM partners with HBCUs to promote quantum computing

IBM is partnering with a group of historically Black colleges and universities to set up a quantum computing center in hopes of ...

SearchContentManagement

Choosing the right collaboration suite for business

Collaboration suites are an essential component of remote work, enabling teamwork throughout a distributed enterprise. Decide ...

Acquia Drupal, Marketing Cloud get feature boosts

Acquia users get Drupal migration tools and marketing automation features built with technology from recent acquisitions as the ...

How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

SearchHRSoftware

Tensions over politics at work have HR on guard

Politics at work may hurt productivity and office harmony. One strategy for defusing a charged atmosphere may be to get employees...

Top 9 tech skills HR professionals need for success

Today's HR departments are increasingly reliant on a range of technologies. That means human resources professionals must get ...

As contingent employee hiring rises, HR gives it focus

The use of contingent employees is increasing, Gartner said, and with it an interest from HR departments for better control over ...

Dig Deeper on Oracle database backup and recovery

audio content

hotword

Why won't TNS listener connect with Oracle Database 11g 32-bit?

Using the network to prevent an Oracle TNS Listener poison attack

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.