RSS Feed

Method R Discussion Group

I get the following when attempting the unit test:

no errors until...
==========================================================
HOTSOS_SYSUTIL Unit tests for version 2
==========================================================
*** Turn tracing on ***
declare
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SUPPORT.START_TRACE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "HOTSOS.HOTSOS_SYSUTIL", line 234
ORA-06512: at "HOTSOS.UT_HOTSOS_SYSUTIL", line 93
ORA-06512: at line 6

Package dropped.

Package dropped.

Package dropped.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

C:\HOTSOS_2.0\Unit_Tests>

Can you tell from this what am I missing?

Thanks,

Gary,

If you follow the Unit Test code through, on line 93 of UT_HOTSOS_SYSUTIL.PKB there is a call made to HOTSOS_SYSUTIL.TURN_TRACE_ON. This in turn looks at your database version and makes the appropriate call to DBMS_MONITOR or DBMS_SUPPORT for Version 10 or Versions 7 through 9 respectively.

The fact that the error states that it can't find DBMS_SUPPORT makes me think that the installation of ILO didn't work properly.

Can you look at the installation log and see if there were any errors? Also have a look and see if DBMS_SUPPORT is actually installed in your database and execute privileges  have been granted to the Owner of ILO.

No errors in the install...

Creating public synonym hotsos_ilo_task for hotsos.hotsos_ilo_task         
Creating public synonym hotsos_ilo_timer for hotsos.hotsos_ilo_timer       
Creating public synonym hotsos_sysutil for hotsos.hotsos_sysutil           
Granting EXECUTE privs on SYS.DBMS_MONITOR or SYS.DBMS_SUPPORT to hotsos
============================================
... Connecting as hotsos
Connected.
... Installing HOTSOS_SYSUTIL Package Spec
No errors.
... Installing HOTSOS_SYSUTIL Package Body
No errors.
... Installing HOTSOS_ILO_TASK Package Spec
No errors.
... Installing HOTSOS_ILO_TIMER Package Spec
No errors.
... Installing HOTSOS_ILO_TIMER Package Body
No errors.
... Installing HOTSOS_ILO_TASK Package Body
No errors.
... Granting EXECUTE privs on HOTSOS_* to PUBLIC

=======================================================
Installation of HOTSOS ILO complete.
=======================================================

I did...

GRANT EXECUTE, DEBUG ON  SYS.DBMS_SUPPORT TO HOTSOS;

I also had to...

GRANT EXECUTE, DEBUG ON  SYS.DBMS_RANDOM TO HOTSOS;

Might there be other privs that need to be explicitly granted to HOTSOS?

We have managed to overcome this temporary hurdle.  Apparently, the ILO install failed to create the public synonym for DBMS_SUPPORT.

The unit test now works.

Thanks,