3 Replies Latest reply on Aug 27, 2013 3:03 AM by Loc Nhan -Oracle

    Issues on collection data (OEM 11g)

    905188
      Hi members,

      Environment OEM 11g :
      Red Hat Enterprise Linux Server release 5.4 (Tikanga) 2.6.18 164.el5 (64-bit)
      Oracle Database 11.2.0.1.0

      Databases target :
      Agent 11g
      Oracle Database 10.2.0.4 (with 7 instances)

      I'm trying to troubleshoot issue when generating reports.

      On "Reports" tab I select "Oracle Database Tablespace Monthly Space Usage" report and choose one of 7 instances. Period is "Last 31 days".

      Earliest Collection Time Unavailable
      Latest Collection Time Unavailable

      No data is currently available

      How to verify collection data is ok ?

      How to troubleshoot this issue ?

      Thanks for help.


      As below results on target db / status agent :


      [oracle@serverdb3 ~]$ emctl status agent
      Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
      Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
      ---------------------------------------------------------------
      Agent Version : 11.1.0.1.0
      OMS Version : 11.1.0.1.0
      Protocol Version : 11.1.0.0.0
      Agent Home : /home/agent11g/agent11g
      Agent binaries : /home/agent11g/agent11g
      Agent Process ID : 1951
      Parent Process ID : 11461
      Agent URL : https://serverdb3.customername.fr:3872/emd/main/
      Repository URL : https://servergrid1.customername.fr:4900/em/upload
      Started at : 2011-10-30 02:35:27
      Started by user : oracle
      Last Reload : 2011-12-14 09:20:59
      Last successful upload : 2011-12-14 10:06:30
      Total Megabytes of XML files uploaded so far : 4418.73
      Number of XML files pending upload : 0
      Size of XML files pending upload(MB) : 0.00
      Available disk space on upload filesystem : 74.09%
      Last successful heartbeat to OMS : 2011-12-14 10:12:11
      ---------------------------------------------------------------
      Agent is Running and Ready
        • 1. Re: Issues on collection data (OEM 11g)
          Loc Nhan -Oracle
          A few things to check:

          - Is the database in question is shown as up on the console?
          - From database target home page, follow the All Metrics link and check if there are values for the Table Allocation metrics?

          Regards,
          - Loc
          • 2. Re: Issues on collection data (OEM 11g)
            1035026


            Hi

             

            Is there a solution for this ? I am also facing the same issue.

             

            Loc

            I checked the All Metrics link, i do not see the Table Allocation Metrics available. What to do next. Please suggest.

            • 3. Re: Issues on collection data (OEM 11g)
              Loc Nhan -Oracle

              Run the following command from the <agent home>/bin directory to check if there is a scheduled data collection for the Tablespce Allocation metric.

              emctl  status agent scheduler | grep  tbspAllocation

               

              - If the metric collection is scheduled, you should see something like this:

              <date> <time> : oracle_database:<db_target_name>:tbspAllocation

               

              - If not, run the following to see if the database target is being monitored by the agent:

              emctl config agent listtargets

               

              Hopefully the above will give you sufficient hints to proceed with troubleshooting. If not, consider log an SR to get help from Support.