RSS Feed

Method R Discussion Group

Hi, the install gets the following:

Preparing to start. Hit enter to continue...
 
*** Please enter the sys password:
'... Connecting as SYS... '
Connected.
 
... Installing DBMS_SUPPORT or DBMS_MONITOR packages, if needed for current database version
SP2-0734: unknown command beginning "SP2-0640: ..." - rest of line ignored.
... Installing HOTSOS_SYSUTIL Package Spec
... Installing HOTSOS_SYSUTIL Package Body
... Granting EXECUTE privs on HOTSOS_SYSUTIL to PUBLIC
=========================================================================
 
and it would appear that the script is trying to execute:

PROMPT ... Installing DBMS_SUPPORT or DBMS_MONITOR packages, if needed for current database version
@hotsos_ilo_install_ver.sql

which doesn't exist.

I see that later on:

*** Granting EXECUTE privs on SYS.DBMS_MONITOR and SYS.DBMS_SUPPORT to HOTSOS
...
... NOTE: Depending upon your database version, one of the following may fail.
old  1: GRANT EXECUTE ON  SYS.DBMS_MONITOR TO &&h_user
new  1: GRANT EXECUTE ON  SYS.DBMS_MONITOR TO HOTSOS
old  1: GRANT EXECUTE ON  SYS.DBMS_SUPPORT TO &&h_user
new  1: GRANT EXECUTE ON  SYS.DBMS_SUPPORT TO HOTSOS
GRANT EXECUTE ON  SYS.DBMS_SUPPORT TO HOTSOS
                      *
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
 
 
*** Connecting as HOTSOS

and that makes sense.

The question is whether hotsos_ilo_install_ver.sql is missing?

Andy,

If you open the file named hotsos_ilo_install.sql you'll see that the first real piece of work that the script does is build the HOTSOS_ILO_INSTAL_VER.sql.

The idea is that it builds the script to install DBMS_SUPPORT or DBMS_MONITOR (depending on your database version) and then executes that script.

You can have a look at the script it generated and see if there are any errors in the script.

One thing that I do know is that you run the script as SYS, SYSTEM, or an account with "DBA" privs. If you don't the select statement that the dynamic script is built from won't execute correctly.