6 Replies Latest reply: Dec 4, 2013 10:30 AM by Green-bit RSS

    ADDM report not generating in OEM

    Green-bit

      Database 11.2.0.2.0

      OEM 11G Grid Control

       

      Hello Guys,

       

      I am trying to generate an ADDM report in OEM.

       

      I chose the option of "Run ADDM to analyze past performance" and then I selected "Period Start Time" and "Period End Time" and clicked on the "OK" button.  The report is not getting generated. Are there any modification that need to be done in the OEM? Please let me know what all info you need.

       

      Thank You

        • 1. Re: ADDM report not generating in OEM
          sb92075

          968751 wrote:

           

          Database 11.2.0.2.0

          OEM 11G Grid Control

           

          Hello Guys,

           

          I am trying to generate an ADDM report in OEM.

           

          I chose the option of "Run ADDM to analyze past performance" and then I selected "Period Start Time" and "Period End Time" and clicked on the "OK" button.  The report is not getting generated. Are there any modification that need to be done in the OEM? Please let me know what all info you need.

           

          Thank You

           

          my car won't go

          tell me how to make my car go.

           

          How do I ask a question on the forums?

          https://forums.oracle.com/message/9362002#9362002

           

          what actual clues exist within EM log file?

          • 2. Re: ADDM report not generating in OEM
            Green-bit

            Hello sb92075,

             

            I went to "AGENT_HOME/sysman/log" there is no log file "emagent.log", there is only one file called "emagent_perl.trc"

             

            when I did "ls -al"  the out shows there are total of 17 files.

             

            fgh435her208:oracle:/clu01/oracle/product/agent11g/sysman/log>ls -al

            total 17

            drwxr-xr-x   2 oracle   oinstall       3 Jan  5  2012 .

            drwxr-xr-x  13 oracle   oinstall      14 Jan  5  2012 ..

            -rw-r-----   1 oracle   oinstall    4725 Jan 19  2012 emagent_perl.trc

            • 3. Re: ADDM report not generating in OEM
              Dallas Deeds

              What happens when you run ?/rdbms/admin/addmrpt.sql from the SQL*Plus command line on the database server?

              • 4. Re: ADDM report not generating in OEM
                Green-bit

                the addmrpt.sql gets stuck too. I enter the "begin_snap" and the "end_snap", after that it just hangs. the addmrpt works fine for other databases, it is only for the production that I am having trouble with.

                 

                the following is the output

                 

                Specify the Begin and End Snapshot Ids

                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                Enter value for begin_snap: 45827

                Begin Snapshot Id specified: 45827

                 

                 

                Enter value for end_snap: 45829

                End   Snapshot Id specified: 45829

                 

                 

                 

                 

                 

                 

                Specify the Report Name

                ~~~~~~~~~~~~~~~~~~~~~~~

                The default report file name is addmrpt_2_45827_45829.txt.  To use this name,

                press <return> to continue, otherwise enter an alternative.

                 

                 

                Enter value for report_name: addm_chpprd2

                 

                 

                Using the report name addm_chpprd2

                 

                 

                 

                 

                Running the ADDM analysis on the specified pair of snapshots ...    ---------> (gets stuck at this point)

                • 5. Re: ADDM report not generating in OEM
                  Dallas Deeds

                  Have you looked at v$session_wait or traced the run of addmrpt to see what it is getting stuck on?

                  • 6. Re: ADDM report not generating in OEM
                    Green-bit

                    when I query the v$session_wait, I see the event "gc cr multi block request",  but I can't make out how that wait event is related to the ADDMRPT.SQL hanging. Isn't "gc cr multi block request" an indication of "db file scattered read" on a table?

                     

                    can you please tell me how to run the trace on addmrpt? I will run the trace and will see what output is generated.

                     

                    Thank You.