Monday, October 20, 2014

Deleting Application Instances

Description: Oracle Identity Manager has a schedule job that cleanup application instances that have been soft-deleted.
Tested On: Oracle Identity Manager 11.1.2.2.0
ReferencesOracle® Fusion Middleware Administrator's Guide for Oracle Identity Manager 11g Release 2 (11.1.2.2.0): Managing Application Instances
Oracle® Fusion Middleware Administrator's Guide for Oracle Identity Manager 11g Release 2 (11.1.2.2.0): Managing the Scheduler


1. Log in to Identity System Administration.


2. On the left pane, click "Application Instances" under "Configuration".


3. Search for application instances and delete the application instance you want to remove. The application instance is removed from the user interface and marked as soft deleted in the back-end (Look at the <OIM_SCHEMA>.APP_INSTANCE.APP_INSTANCE_IS_SOFT_DELETE column).


4. On the left pane, click "Scheduler" under "System Management".



5. Search for "Application Instance Post Delete Processing Job" scheduled job. This schedule job only cleanup application instances that are soft-deleted. Ensure SOA managed server is running before running the scheduled job.

Application Instance Name:
Specify the application instance name (refer to APP_INSTANCE.APP_INSTANCE_NAME column) or ALL if deleting more than one application.

Mode:
-Revoke: Deletes the provisioned accounts from the target system. In OIM, the resource accounts are marked "Revoked" and the data still exist in the UD_<FORMNAME> table.

-Delete: Hard-deletes the accounts from all provisioning tasks and targets, and subsequently from Oracle Identity Manager (records from UD_<FORMNAME>, APP_INSTANCE, OIU tables are cleaned up).

-Decommission: Changes the account status to Revoke without keeping the accounts in Oracle Identity Manager in provisioned state


# Query to check resource account status
SELECT USR.USR_LOGIN, OST.OST_STATUS, OBJ.OBJ_NAME, OIU.ORC_KEY  FROM USR
INNER JOIN OIU ON USR.USR_KEY = OIU.USR_KEY
INNER JOIN OST ON OST.OST_KEY = OIU.OST_KEY
INNER JOIN OBI ON OBI.OBI_KEY = OIU.OBI_KEY
INNER JOIN OBJ ON OBI.OBJ_KEY = OBJ.OBJ_KEY


No comments:

Post a Comment