dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DBSNMP's NMI.LOG file growing too big

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    DBSNMP's NMI.LOG file growing too big

    Environment Windows 2000, Service Pack 3
    Oracle Version 8.1.7.0.0

    I inherited this oracle db where we are facing the issue of DBSNMP's NMI.LOG file growing too big.

    How can I remove/archive/shorten the nmi.log file. Is it safe?
    What is the best and easiest way to bring the nmi.log file to a small size. If we don't remove the actual cause, can it grow again to big size soon.
    The last time this file was changed (datestamp) was in April, 23, 2005


    I have a DBSNMP user in the database but do not see any similar name (agent's) in the windows services.

    I have 2 oracle homes one 8i and other 9i

    Here is my Listener.ora file
    ----------------------------
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = preprod)(PORT = 1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )

    CONNECT_TIMEOUT_LISTENER = 0

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = F:\oracle\ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = pilot.araccel)
    (ORACLE_HOME = F:\oracle\ora81)
    (SID_NAME = pilot)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = DCRI.Araccel)
    (ORACLE_HOME = F:\oracle\ora81)
    (SID_NAME = DCRI)
    )
    )
    ---------------------------

    Please advice. Thanks
    -D

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    whats in the log, first make sure you arent getting any errors.

    You can then shutthe agent down, remove log and restart - that is a 'clean' way

  3. #3
    Join Date
    Jul 2003
    Posts
    136
    Cannot open it straightforward. It says "Not enough memory available to complete this operation". When you say shut down the agent, which agent are you taking, I don't see any DBSNMP service running.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    agentctl stop agent from the command line
    agentctl start agent to stop it

  5. #5
    Join Date
    Jul 2003
    Posts
    136
    Thanks dave23uk. That worked. Appreciate your help.
    -D

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