listener log and disk space
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: listener log and disk space

  1. #1
    Join Date
    Jan 2005
    Posts
    10

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    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.

  3. #3
    Join Date
    Jan 2005
    Posts
    10

    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

  4. #4
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    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.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if lgging is turned off, nothing will be written

  6. #6
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    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.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    or just

    logging_LISTENER = off

    in the listener.ora
    Last edited by davey23uk; 02-20-2005 at 08:44 AM.

  8. #8
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    logging_LISTENER = off
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  9. #9
    Join Date
    Jan 2005
    Posts
    10

    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

  10. #10
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width