- Locate the Ignite repository. It will be the database/instance where a table named COND exists in the Ignite schema (can be any name, but defaults to IGNITE).
- Determine all databases being monitored from the repository:
- select id, name from cond;
- The NAME field from the query is created from DBName_MachineName or InstanceName:port. For example, a NAME of PROD_ABC123 indicates the repository is monitoring the Oracle database named PROD on a machine named ABC123.
- Keep this list for later use.
- Login to the repository as the Ignite user (change passwords for the user if necessary).
- Stop all jobs in the repository using the following PL/SQL block:
begin
for j in (select job, what from user_jobs) loop
dbms_job.remove(j.job);
end loop;
end;
/
- Logout of the Ignite user and into a DBA user on the same repository database.
- Kill all existing Ignite sessions using the following PL/SQL block. It will prompt for the Ignite username.
begin
for s in (select sid, serial#
from v$session
where upper(username) = upper('&IgniteUser')) loop
execute immediate 'alter system kill session '''||s.sid||','||s.serial#||'''';
end loop;
end;
/
- Remove the Ignite user.
- drop user ignite cascade;
- Drop the Ignite user in each of the monitored databases. You may have to kill Ignite sessions in the monitored databases as well before dropping them.