-
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
-
Is the database heavily used - it may be that the listener isn't shut down regularly, so there will be few entries in it?
How fast has /opt been growing? Was this a sudden leap to 85% or has it been occurring gradually? If the former, you might like to search for core files in opt which might have been dropped by a malfunctioning application. Use:
find /opt -name 'core'
to check. Usually (unless they're occurring every few minutes/hours), these can be deleted to release the space they occupy. If there are no core files, try:
find /opt -size +5000
to see the larger files (some of which you have already identified above). Decrement the +5000 to +4000, +3000 etc if that doesn't bring anything back. Let us know how you ge on.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
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
-
Sorry, I don't know why the listener.log doesn't appear to be written to, but you could monitor it and check when and why it is written to and take it from there. You could print or move /opt/oracle/oraInventory/logs/installActions2004-03-29_01-33-49PM.log
and then delete it if you wish.
I don't know what lls is either - I'll do some digging, but in the meantime perhaps you could advise whether it's a regular file (ie can you cat it and see it's contents?), or a binary. The command file lls should give you a clue there.
Apologies if this isn't much help at the moment, but we'll get there.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
if lgging is turned off, nothing will be written
-
Davey's quite correct - use:
lsnrctl set log_directory
lsnrctl set log_file
lsnrctl set log_status on
lsnrctl reload
to set logging on. Add LOG_DIRECTORY_LISTENER =
and LOG_FILE_LISTENER = LISTENER.log to your listener.ora too.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
or just
logging_LISTENER = off
in the listener.ora
Last edited by davey23uk; 02-20-2005 at 09:44 AM.
-
where LISTENER is the name of your listener in listener.ora
My 2 cents:
1. Leave logging off, and turn it on as needed. If you want it on, a good way to clean out the listener.ora is "echo > listener.ora"
2. Regularly archive (cyb) or remove (no coverage)
a) $OH/rdbms/audit/*.aud - sys and system logins are on by default
b) .trc files
c) core dumps
Unless you plan on creating canned instances with those djf's, I's wack 'em. They tend to be problematic once the system is patched anyways.
-
Listener no be written
Thanks for every people 's warm help, I deeply appreciate.
Sorry for the late response, I took two days off for personal issue.
Our Oracle database version is 9i.
1. Actually, I checked the listener log status as following before, everything looked fine.
> lsnrctl
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" set to ON
The command completed successfully
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" set to ON
The command completed successfully
LSNRCTL> show log_directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_directory" set to /opt/oracle/product/9.2.0/network/log/
The command completed successfully
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_file" set to listener.log
The command completed successfully
2. My listener.ora file is like the following:
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.222)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = ladb)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(GLOBAL_DBNAME = ladb)
)
)
3. Since my log is not written, does that mean I have to modify my listener.ora file rather than just "set log_status ON" ?
thanks a lot,
jwu1023
-
go to /opt/oracle/product/9.2.0 and
"find . -name listener.log -exec ls -l {} \;"
Make sure you're looking at the right log file.
3. Since my log is not written, does that mean I have to modify my listener.ora file rather than just "set log_status ON" ?
If it's in your listener.ora file, it'll be set the next time you start the listener and permanently thereafter. "set log_status ON" will set it on temporarily.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|