For several reasons, e.g. database refreshes, the Oracle user that Ignite utilizes for monitoring can be deleted.  The following script can be used to re-create that user with proper rights and privileges.  To run this script connect as SYS to the monitored database and it will prompt for everything it requires.

Save the following script to a file and execute on the monitored database.

REM connect as SYS on Mon DB
REM create Ignite user for Ignite for Oracle.

prompt Enter Ignite Username:
accept Ignite_Username
prompt Enter Ignite Password:
accept Ignite_Password
prompt Enter Ignite Tablespace:
accept TS
prompt Enter Ignite Temporary Tablespace:
accept TTS

rem drop user &Ignite_Username cascade;

create user &Ignite_Username identified by &Ignite_Password
default tablespace &TS temporary tablespace &TTS;

grant create table to &Ignite_Username;
grant create synonym to &Ignite_Username;
grant create session to &Ignite_Username;
grant create sequence to &Ignite_Username;
grant unlimited tablespace to &Ignite_Username;

grant select on dba_views to &Ignite_Username;
grant select on dba_objects to &Ignite_Username;
grant select on user_synonyms to &Ignite_Username;

REM For 8i the "select any dictionary" privilege does not exist
grant select_catalog_role           to &Ignite_Username;
grant select on v_$database         to &Ignite_Username;
grant select on v_$instance         to &Ignite_Username;
grant select on v_$active_instances to &Ignite_Username;
grant select on V_$parameter        to &Ignite_Username;
grant select on V_$latch            to &Ignite_Username;
grant select on V_$sqlarea          to &Ignite_Username;
grant select on V_$datafile         to &Ignite_Username;
grant select on V_$event_name       to &Ignite_Username;
grant select on V_$version to &Ignite_Username;


REM create views

create or replace view x_$KSUSE     as select * from x$ksuse;
create or replace view x_$ksusecst  as select * from x$ksusecst;
create or replace view X_$KCCCF     as select * from x$KCCCF;
create or replace view X_$KGLNA1    AS select * from x$kglna1;
create or replace view X_$KGLNA     AS select * from x$KGLNA;
create or replace view x_$KGLCURSOR AS select * from x$KGLCURSOR;

grant select on x_$ksuse to &Ignite_Username;
grant select on x_$ksusecst to &Ignite_Username;
grant select on x_$kcccf to &Ignite_Username;
grant select on x_$kglna1 to &Ignite_Username;
grant select on x_$kglna to &Ignite_Username;
grant select on x_$kglcursor to &Ignite_Username;

grant select on v_$parameter to &Ignite_Username;
grant select on v_$instance to &Ignite_Username;

create synonym &Ignite_Username..x$ksuse for sys.x_$ksuse;
create synonym &Ignite_Username..x$ksusecst for sys.x_$ksusecst;
create synonym &Ignite_Username..x$kcccf for sys.x_$kcccf;
create synonym &Ignite_Username..x$kglna for sys.x_$kglna;
create synonym &Ignite_Username..x$kglna1 for sys.x_$kglna1;
create synonym &Ignite_Username..x$kglcursor for sys.x_$kglcursor;

create table &Ignite_Username..confio (id number);
create table &Ignite_Username..mproc (id number);

-- Create utl_con package used for getting explain plan and block data
@"C:\Program Files\Confio\Ignite PI\iwc\tomcat\webapps\idc\WEB-INF\classes\resources\database\Oracle\utl_con_8iplus.plb"

grant execute on sys.utl_con to &Ignite_Username;
grant execute on sys.dbms_sql to &Ignite_Username;