Sitemap

Amicuk Programming Answers

Error in generating ADDM Report(Oracle 11g 64 bit EE on linux RHEL 5)

2015-10-11   Views:15

Advertisement

I collected .dmp file from production using awrextr.sql and imported in our development side using awrload.sql . I am able to generate awr snapshots report out of it without any trouble. But When I try to generate addm report using addmrpti.sql I am

I collected .dmp file from production using awrextr.sql and imported in our development side using awrload.sql .
I am able to generate awr snapshots report out of it without any trouble.
But When I try to generate addm report using addmrpti.sql I am facing following error(Please see output pasted below)
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_7149_7156.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name addmrpt_1_7149_7156.txt
Running the ADDM analysis on the specified pair of snapshots ...
begin
ERROR at line 1:
ORA-13711: Some snapshots in the range [7149, 7156] are missing key statistics.
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at line 27
Generating the ADDM report for this analysis ...
ERROR:
ORA-13608: The specified name NULL is invalid.
ORA-06512: at "SYS.PRVT_ADVISOR", line 3122
ORA-06512: at "SYS.DBMS_ADVISOR", line 585
ORA-06512: at line 1
End of Report
Report written to addmrpt_1_7149_7156.txt
SQL>
Any clue or help will be really helpful for us.

The replay answer
Advertisement
hello,
have a look at this'
ORA-13711:Some snapshots in the range [string, string] are missing key statistics.
Cause:      Some AWR tables encountered errors while creating one or more
snapshots in the given range. The data present in one or more of these missing
tables is necessary to perform an ADDM analysis.
Action:      Look in DBA_HIST_SNAP_ERROR to find what tables are missing in
the given snapshot range. Use the ERROR_NUMBER column in that view
together with the alert log to identify the reason for failure and take necessary action to
prevent such failures in the future. Try running ADDM on a different snapshot range
that does not include any incomplete snapshots.thanks and regards
VD
Edited by: Dixit on Aug 31, 2009 1:52 AM
Edited by: Dixit on Aug 31, 2009 1:53 AM

Go to See the other 2 answers

Error in generating ADDM Report(Oracle 11g 64 bit EE on linux RHEL 5)

Category:DefaultRelease time:2015-10-11Views:130

I collected .dmp file from production using awrextr.sql and imported in our development side using awrload.sql . I am able to generate awr snapshots report out of it without any trouble. But When I try to generate addm report using addmrpti.sql I am[More]

Error while generating the report on Test env (for divide condition)

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am facing the below error while generating the report in test environment while the same report is working fine on Prod environment. Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 1[More]

Error when generating the report in Production Server

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have created one infoset query in Development server of my client. It is working fine there. I had transported the request containg this query to Production server. But whenever I am trying to generate report using this query in Production serv[More]

Error when generating the report (see long text), Message no. AQ_AD_HOC221

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am facing a peculiar problem while executing an infoset query.I have created 2 customized fields Compa-ratio and PIR in infotype 0008 in an infoset.I have coded in these additional fields. When I execute a query using 1 of these customized[More]

Error while generating  BI Reports with Formules From Oracle 10g reports

Category:DefaultRelease time:2015-10-11Views:130

Hi Team, I had a problem of viewing reports in Bi Publisher. I will explain what i am doing I an taking an example table emplyee to generate the reports create or replace package body tstPkg as I am creating Package Header as Below function check_rol[More]

Error in generating parameterized report in siebel 8.1.1.5

Category:DefaultRelease time:2015-10-11Views:130

Hi, we recently upgraded to siebel 8.1.1.5. My report displays the values selected by the user in the parameter applet. I have done the following as indicated in the Reports Guide: 1) Define parameters in Siebel UI Label: Report View Type Name: Repor[More]

REP-57000 Error When Generating a Report in EXCEL format

Category:DefaultRelease time:2015-10-11Views:130

Hello All, We're encountering an error that says "REP-57000: Oracle Reports API - Internal error: Item: oracle.reports.definition.RWReport;Prop:34; Attr: ]] ...". The report works fine and is able to generate an EXCEL file when it retrieves arou[More]

Hot
I want to move all of my music and videos to my new ipod touch via my computer, so how do I do this ? I currently have my songs on my old ipod classic.First: Recovering your iTunes library from your iPod or iOS device: Apple Support Communities The s [More]
I'm going crazy... I have been reading forums and troubleshooting pages for about 15 hrs and I do not know what else to try. I have 32-bit Win Vista and it will not let me download iTunes. I have run my anti-virus, my spyware remover, cleaned my regi [More]
it will not even make the *whoosh* sound anymore. My volume is up I checked the mail settings and the sound were all on, then I checked the system prefreces in the sounds menu and that appeared to be fine Any suggestions?So you checked Mail Preferenc [More]
hi all, one small rewquirement. if u run this test program it opens a excel sheet which contains signle tab. here tab name is not coming. i dont no hot to display tabname here.anybody can  make the changes and send me the code. i am sending my code b [More]
I recently upgraded my iPhoto to Version 9.1.5 which should be most recent version. When I now try to create a photo book a message pops up which says, that no themes are available. I bought my iPhoto online in the AppStore so I can´t just reinstall [More]
Hi - I recently bought an iPhone 5c, and when restoring the new phone from my last icloud back up I was prompted to enter the password's for 3 different apple ID's. One was my friend's apple ID, the other two were connected to really old email addres [More]
Hi ,       I did FPM application configuration and component configuration.  When I test from Application configuration it works perfectly. But when I run it from SE80 application->test it dumps. Below is the dump. Can some one help me please. The fo [More]
Hi, I am trying to generate the Java artifacts frm a wsdl file. I am using jaxws-ri_2.1.3 . When I run wsimport the process dies with the following message "Schema descriptor {http://www.w3.org/2001/XMLSchema}XmlDataDocument in message part "ret [More]
(Also posted on the nikeplus forum: http://forums.nike.com/message.jspa?messageID=238734#238734) I am trying to sync my workout data for the first time on iTunes....so far unsuccessfully. I have just one workout in my latest workouts folder. When try [More]
HELP!   I have looked at video sites, looked on here, to no avail.   Please dont talk negatively about my question (as I have seen some pretty mean responses to topics )   I am trying to copy my itunes music to an external hard drive.  Here is my sit [More]