listener log and disk space
Dear all,
I am new in the Oracle DBA administration field.
Recently when I run Linux command "df -k" to check the disk space, I found directory /opt is above 85%. Normally, it is the listerner.log file eating the space. I checked listener.log file and found that last time it was written is Jan 17,2005 and its size is pretty small.
Is there anybody can help me with the following question?
1. Why listener log file is not written currently?
(owner of listener log file is dba.)
2. How can I find the file that eating the disk space?
(I run Linux command "du -s /opt/*" and found that Data_Warehouse.dfj, Transaction_Processing.dfj and dba.idx have the largest size, but since we use DBCA to create database and dba.idx is system file, we should keep those files. I also checked slqnet.log and audit files, their size is ok. What else file would eat the disk space?)
thanks for your kind help in advance,
jwu1023
listener log and disk space
Hi KenCunningham,
Thanks for your suggestion.
I think the database is heavily used. Could you tell me how I can let the listener.log be written?
The /opt grows gradually. I used the command "find /opt -size +5000" to find the larger file, it gave me lots of files. Since I am not exactly sure the normal size of each displayed file and not know the function of some files either, would you please give me some clue which larger files I should check and base on what criteria? I will paste those file in the following.
by the way, I found one root file like this:
-rw-r--r-- 1 root root 159047 Feb 14 15:07 lls
should I doubt this file? I tail part of the file and open it, some of the code is unreadble.
thanks a lot,
jwu1023
**********************************************************************
**********************************************************************
[root@tr_db_active dba]# find /opt -size +5000
/opt/IBMJava2-131/jre/bin/classic/libjvm.so
/opt/IBMJava2-131/jre/bin/classic/libjvm_g.so
/opt/IBMJava2-131/jre/bin/libawt.so
/opt/IBMJava2-131/jre/bin/libjitc.so
/opt/IBMJava2-131/jre/bin/libawt_g.so
/opt/IBMJava2-131/jre/bin/libcmm_g.so
/opt/IBMJava2-131/jre/bin/libfontmanager_g.so
/opt/IBMJava2-131/jre/bin/libjavaplugin_oji_g.so
/opt/IBMJava2-131/jre/bin/libjitc_g.so
/opt/IBMJava2-131/jre/lib/i18n.jar
/opt/IBMJava2-131/jre/lib/rt.jar
/opt/IBMJava2-131/lib/tools.jar
/opt/IBMJava2-131/src.jar
/opt/oracle/oraInventory/logs/installActions2004-03-29_01-33-49PM.log
/opt/oracle/product/9.2.0/inventory/Components21/oracle.sysman.website/9.2.0.1.0/installlog.xml
/opt/oracle/product/9.2.0/jlib/oembase-9_2_0.jar
/opt/oracle/product/9.2.0/jlib/oemtools-9_2_0.jar
/opt/oracle/product/9.2.0/jlib/oemlt-9_2_0.jar
/opt/oracle/product/9.2.0/jlib/cvd.zip
/opt/oracle/product/9.2.0/jlib/aurora_client.jar
/opt/oracle/product/9.2.0/lib/libclient9.a
/opt/oracle/product/9.2.0/lib/libgeneric9.a
/opt/oracle/product/9.2.0/lib/libclntst9.a
/opt/oracle/product/9.2.0/lib/libpls9.a
/opt/oracle/product/9.2.0/lib/libn9.a
/opt/oracle/product/9.2.0/lib/libvdc.so
/opt/oracle/product/9.2.0/lib/libjox9.so
/opt/oracle/product/9.2.0/lib/libordsdo9.a
/opt/oracle/product/9.2.0/lib/libserver9.a
/opt/oracle/product/9.2.0/lib/liboraolap9.a
/opt/oracle/product/9.2.0/lib/libolapapi9.so
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
/opt/oracle/product/9.2.0/xdk/install/ncomp_so_xmlparserv2.jar
/opt/oracle/product/9.2.0/bin/wrap
/opt/oracle/product/9.2.0/bin/wrapO
/opt/oracle/product/9.2.0/bin/proc
/opt/oracle/product/9.2.0/bin/rman
/opt/oracle/product/9.2.0/bin/rmanO
/opt/oracle/product/9.2.0/bin/nmumigr8
/opt/oracle/product/9.2.0/bin/namesctl
/opt/oracle/product/9.2.0/bin/mig
/opt/oracle/product/9.2.0/bin/migO
/opt/oracle/product/9.2.0/bin/oracle
/opt/oracle/product/9.2.0/bin/oracleO
/opt/oracle/product/9.2.0/bin/nmumigr80
/opt/oracle/product/9.2.0/bin/onrsd0
/opt/oracle/product/9.2.0/bin/tnslsnr0
/opt/oracle/product/9.2.0/bin/lsnrctl0
/opt/oracle/product/9.2.0/rdbms/admin/xumuts.plb
/opt/oracle/product/9.2.0/rdbms/lib/libdbtools9.a
/opt/oracle/product/9.2.0/rdbms/mesg/oraus.msg
/opt/oracle/product/9.2.0/network/lib/libtcl.a
/opt/oracle/product/9.2.0/ldap/oidadmin/osdadminhelp.jar
/opt/oracle/product/9.2.0/ldap/oidadmin/osdadmin.jar
/opt/oracle/product/9.2.0/jdk/jre/lib/fonts/ALBANWTT.TTF
/opt/oracle/product/9.2.0/jdk/jre/lib/i386/client/libjvm.so
/opt/oracle/product/9.2.0/jdk/jre/lib/i386/server/libjvm.so
/opt/oracle/product/9.2.0/jdk/jre/lib/i386/libawt.so
/opt/oracle/product/9.2.0/jdk/jre/lib/rt.jar
/opt/oracle/product/9.2.0/jdk/jre/lib/i18n.jar
/opt/oracle/product/9.2.0/jdk/lib/tools.jar
/opt/oracle/product/9.2.0/olap/wrksht/wks.jar
/opt/oracle/product/9.2.0/olap/wrksht/lib/oembase.jar
/opt/oracle/product/9.2.0/olap/jars/vbjorb.jar
/opt/oracle/product/9.2.0/olap/admin/xumuts.plb
/opt/oracle/product/9.2.0/javavm/lib/ncomp.zip
/opt/oracle/product/9.2.0/javavm/admin/libjox9_ed74f7b712_sys_oracle_xml_parser_v2.so
/opt/oracle/product/9.2.0/javavm/admin/classes.bin
/opt/oracle/product/9.2.0/javavm/admin/libjox9java_text_resources.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9java_util.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9oracle_aurora_server_tools_loadjava.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9oracle_sql.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9oracle_gss_util.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9oracle_jdbc_driver.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9sqlj_mesg.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9sun_io.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9java_awt.so
/opt/oracle/product/9.2.0/javavm/admin/libjox9HTTPClient.so
/opt/oracle/product/9.2.0/sysman/jlib/master.jar
/opt/oracle/product/9.2.0/sqlj/lib/translator.jar
/opt/oracle/product/9.2.0/sqlj/lib/translator.zip
/opt/oracle/product/9.2.0/ord/jlib/ordimimg_depl.jar
/opt/oracle/product/9.2.0/ord/jlib/jai_core_depl.jar
/opt/oracle/product/9.2.0/ord/Annotator/lib/Annotator.jar
/opt/oracle/product/9.2.0/assistants/dbca/templates/Data_Warehouse.dfj
/opt/oracle/product/9.2.0/assistants/dbca/templates/Transaction_Processing.dfj
/opt/oracle/product/9.2.0/demo/schema/sales_history/sh_cust.dat
/opt/oracle/product/9.2.0/demo/schema/sales_history/sh_sales.dat
/opt/oracle/product/9.2.0/BC4J/lib/bc4jmt.jar
/opt/oracle/product/9.2.0/ultrasearch/lib/ultrasearch_db.jar
/opt/oracle/product/9.2.0/ultrasearch/lib/ultrasearch_midtier.jar
/opt/oracle/product/9.2.0/ultrasearch/webapp/ultrasearch_admin.ear
/opt/oracle/product/9.2.0/ctx/data/enlx/drofdUS.dat
/opt/oracle/product/9.2.0/ctx/data/enlx/drofiUS.dat
/opt/oracle/product/9.2.0/ctx/data/enlx/droldUS.dat
/opt/oracle/product/9.2.0/ctx/data/enlx/droliUS.dat
/opt/oracle/product/9.2.0/ctx/data/enlx/drolkUS.dat
/opt/oracle/product/9.2.0/ctx/data/frlx/drofdF.dat
/opt/oracle/product/9.2.0/ctx/data/frlx/droldF.dat
/opt/oracle/product/9.2.0/oem_webstage/java-plugin/jinit11818.exe
/opt/oracle/product/9.2.0/oem_webstage/oemStage2.jar
/opt/oracle/product/9.2.0/dbs/snapcf_ladb.f
/opt/oracle/jre/1.1.8/lib/i686/native_threads/libawt.so
/opt/oracle/jre/1.1.8/lib/i686/green_threads/libawt.so
/opt/oracle/jre/1.1.8/lib/i18n.jar
/opt/oracle/jre/1.3.1/lib/i386/server/libjvm.so
/opt/oracle/jre/1.3.1/lib/i386/client/libjvm.so
/opt/oracle/jre/1.3.1/lib/i386/libawt.so
/opt/oracle/jre/1.3.1/lib/rt.jar
/opt/oracle/jre/1.3.1/lib/i18n.jar
/opt/oracle/oui/bin/linux/libclntsh.so.9.0
/opt/oracle/doc/a96167.pdf
/opt/oracle/doc/a97297.pdf