Problem with Monitoring Oracle 9 (fix for Oracle 10 incl.)

Problem with Monitoring Oracle 9 (fix for Oracle 10 incl.)

Application Manager 7.2 running on 32bit Debian 3.1 Linux.

Monitoring Oracle 9 fails with:
oraclehost 1521
Fehlgeschlagen
�berwachung konnte nicht initiiert werden (monitoring could not be initialized)
null


Oracle 10 works find and I suggest the following patch as I do not want to enter the SYS-account password into the Application Manager and using a new account monitor/monitor for this:

Change all strings "v$" in file
/opt/appman/AppManager7/working/conf/application/Oracle.xml
to "sys.v_$" restart Application Manager and execute the following SQL statements after connecting to Oracle with "connect sys/yourpassword as sysdba":

create user monitor identified by monitor;
grant connect to monitor;
grant select on v_$database to monitor;
grant select on v_$rowcache to monitor;
grant select on v_$librarycache to monitor;
grant select on v_$sgastat to monitor;
grant select on v_$sqlarea to monitor;
grant select on v_$filestat to monitor;
grant select on v_$session_wait to monitor;
grant select on v_$sgastat to monitor;
grant select on v_$parameter to monitor;
grant select on v_$sesstat to monitor;
grant select on v_$statname to monitor;
grant select on v_$datafile to monitor;
grant select on v_$rollstat to monitor;
grant select on dba_data_files to monitor;
grant select on dba_rollback_segs to monitor;
grant select on dba_segments to monitor;































                New to ADSelfService Plus?