OraFAQ Forum: Enterprise Manager » Ash Analytics Fails to install

Home » RDBMS Server » Enterprise Manager » Ash Analytics Fails to install (EM cloud 12c, Oracle DB 11.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ash Analytics Fails to install [message #611945]

Thu, 10 April 2014 05:48

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Hi,

I'm trying to install ash analytics package in a DB and they are failing with

Error while executing the script : oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PLS-00201: identifier 'DBSNMP.ASHVIEWER' must be declared
Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PL/SQL: Statement ignored
 at line number - 2580
Driver SQL Script encountered errors.
Fail

The user has the required privs and I cant find and note in the docus that there is some sort of issue with 11.2

Anyone seen this before?

Report message to a moderator

Re: Ash Analytics Fails to install [message #611952 is a reply to message #611945]

Thu, 10 April 2014 07:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Everyone knows that I'm no good at EM. However, I did some googling and here's what it returned: a (Bulgarian?) page, here: http://cyclone.rssing.com/chan-1198591/all_p1030.html. Search for "ASHVIEWER". Basically, it says that installation mentions which scripts it will run. That SQL script is kind of wrong.

Scripts originally run at this order:

prvs_awr_data.sql 
prvt_awr_data.sql 
prvs_awr_data_cp.sql 
prvt_awr_data_cp.sql 
dbms_compare_period.sql 
prvt_compare_period.sql 
eaddm_pkgdef.sql 
eaddm_pkgbody.sql 
ashviewer_pkgdefs.sql     --> this 1
ashviewer_pkgbodys.sql    --> this 2

Try to reorder them so that they run as

prvs_awr_data.sql
ashviewer_pkgdefs.sql     --> move 1 here
ashviewer_pkgbodys.sql    --> move 2 here
prvt_awr_data.sql 
prvs_awr_data_cp.sql 
prvt_awr_data_cp.sql 
dbms_compare_period.sql 
prvt_compare_period.sql 
eaddm_pkgdef.sql 
eaddm_pkgbody.sql

It also mentions that files are on OEM APP server in "plugins/oracle.sysman.db.oms.plugin_12.1.0.3.0/sql/db/latest/instance/" (if it means anything to you).

Report message to a moderator

Re: Ash Analytics Fails to install [message #611968 is a reply to message #611952]

Thu, 10 April 2014 08:14

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

That seems plausible but in my case odd: I've managed to install it in loads of other places (and seeing as it's a prod box on something of a sprawling estate, I'm reluctant to mess with the script order on the main EM host Sad

)

I assume they come from main OEM box as I cant find the scripts in the agent dir(s)

[Updated on: Thu, 10 April 2014 08:21]

Report message to a moderator

Previous Topic:	Dashboard configuration in OEM 11g
Next Topic:	Job to Shutdown an Instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 08:22:31 CST 2025