On-line processing method of Listener.log in Aix production system

Source: Internet
Author: User
Tags dba file system log sort

--found that/home/oracle/database space utilization is too high

$ df-g

File system GB blocks can be installed in%used iused%iused

/DEV/HD4 1.00 0.15 85% 7459 18%/

/DEV/HD2 6.00 3.35 45% 52805 7%/usr

/dev/hd9var 1.00 0.86 15% 1170 1%

/DEV/HD3 8.00 3.27 60% 64796 8%/tmp

/DEV/HD1 18.00 9.29 49% 86096 4%

/dev/hd10opt 4.00 3.85 4% 2934 1%

/dev/oraclelv 15.00 6.17 59% 23279 2%

/DEV/CRSLV 15.00 5.22 66% 150520 11%

--to see which directory space is the largest based on sort sorting

$ du-s/home/oracle/database/* | Sort-rn | Head

7691672/home/oracle/database/network

5684552/home/oracle/database/oc4j

3319464/home/oracle/database/bin

2278592/home/oracle/database/dbs

1171960/home/oracle/database/lib

880256/home/oracle/database/lib32

789696/home/oracle/database/p570a_zjport1

669512/home/oracle/database/jdk

629312/home/oracle/database/jre

250096/home/oracle/database/sysman

--The initial judgment is that the/home/oracle/database/network directory has too large a listening log

P550a:/home/oracle/database/network/log#ls-lt

Total 506536

-rw-r--r--1 Oracle DBA 168782267 February 02 10 o'clock Listener_p550a.log

-rw-r--r--1 Oracle DBA 17152616 February 01 22 O'Clock Sqlnet.log

-rw-r--r--1 Oracle DBA 73300223 October 08 08 O'Clock Listener.log

--Turn off listening logging

$ lsnrctl Set Log_status off

Lsnrctl for Ibm/aix RISC system/6000:version 10.2.0.3.0-production on 02-feb-2012 10:35:46

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (Address= (PROTOCOL=TCP) (host=) (port=1521))

LISTENER parameter "Log_status" set to Off

The command completed successfully

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.