1 Reply Latest reply: Jan 8, 2013 1:30 PM by Loc Nhan -Oracle RSS

    Failed to startup OEM

    Neo-b
      Hello All,

      I am using Oracle RAC 11.2.0.3 2 nodes

      I was facing a failure while trying to start up Oracle enterprise manager because of the below issue:
      Exceeded Max allowed Upload data - No of files:
      to solve this issue I did the below steps:

      1 stop the agent
      2 delete agntstmp.txt and lastupld.xml (under sysman/emd)
      3 Delete all the files under upload and collection directories
      4 start the agent

      and now i am facing the below errors while trying to start OEM:
      2013-01-08 10:47:23,120 Thread-515 <HTTP Listener> Agent Signaled to EXIT by emctl (00800)
      2013-01-08 10:47:24,120 Thread-1 EMAgent normal shutdown (00703)
      2013-01-08 10:48:52,148 Thread-1 Starting Agent 10.2.0.4.4 from /u01/app/oracle/product/11.2.0/db_1 (00701)
      2013-01-08 10:48:52,306 Thread-1 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__int
      ervalONNECT_DATA=(SID=%SID%)))
                   (00104)
      2013-01-08 10:48:52,307 Thread-1 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__int
      ervalCT_DATA=(SID=%SID%)))
                   (00104)
      2013-01-08 10:48:52,307 Thread-1 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__int
      ervalrvalCT_DATA=(SID=%SID%)))
                   (00104)
      2013-01-08 10:48:52,307 Thread-1 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__int
      ervalCT_DATA=(SID=%SID%)))
                   (00104)
      2013-01-08 10:48:52,307 Thread-1 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__int
      ervalATA=(SID=%SID%)))
                   (00104)
      2013-01-08 10:48:52,307 Thread-1 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/
      __intervalinterval=%SID%)))
                   (00104)
      2013-01-08 10:48:52,420 Thread-1 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
      2013-01-08 10:49:03,902 Thread-1 EMAgent started successfully (00702)
      2013-01-08 10:49:03,919 Thread-2850 <Upload Manager> Exceeded Max allowed Upload data - No of files: 246, Size of upload data: 20.177911MB, Pct() of Disk used
      : 35.03%, Disabling collections (00852)
      2013-01-08 10:49:03,919 Thread-2850 Disable collector (00406)
      Please can you help
        • 1. Re: Failed to startup OEM
          Loc Nhan -Oracle
          Hi,

          The trace/log file excerpts show that the agent stopped collecting metrics due to one of the following limits, which are set in the <agent_home>/sysman/config/emd.properties file, had been reached:

          - The total size of the of pending upload files in MB (UploadMaxBytesXML)
          - The number of files pending upload (UploadMaxNumberXML)
          - The percentage disk space used (UploadMaxDiskUsedPct)

          I suggest that you check the above parameters (in parentheses) in the emd.properties file and, if possible, increase their values to allow the agent to resume collecting metrics. Note that you may have to change to value of the parameter UploadMaxDiskUsedPctFloor if the disk used percentage of filesystem where the agent home resides has exceeded the limit set by the parameter. Bounce the agent or reload it (using the "emctl reload agent" command) for any agent parameter change to take effect. To find the agent home, issue command "emctl getemhome".

          After the agent resumes metric collection, investigate what caused the file backlog and take corrective actions. Log an SR to Support if you need help.

          Regards,
          - Loc