OIM Bulkload Utility - "Utility is already running"

If the Bulkload Utility hasn't been run cleaning, you may got the "Utility is already running' while executing the oim bulk load utility.  The solution is to drop the temporary table "OIM_BLKLD_TMP".

After the bulkload, the following should be checked to see is there any indexes and constraints in DISABLED or UNUSABLE state.

Being a database-intensive operation by design, Bulk Load disables the constraints and indexes on the relevant Oracle Identity Manager entity tables during the start of the operation. Bulk Load operation failure towards the end of the load might at times render the indexes and constraints in disabled state. To identify and fix this issue, manually restore the indexes and constraints as follows:

1. Identify the unusable indexes and disabled constraints. To do so, the following SQL queries or similar mechanism can be used:

   SELECT TABLE_NAME, CONSTRAINT_NAME FROM user_constraints WHERE status = 'DISABLED';
   SELECT index_name FROM user_indexes WHERE status = 'UNUSABLE';
   

2. Enable the constraints and rebuild the indexes manually, as shown:

   ALTER TABLE TABLE_NAME ENABLE CONSTRAINT CONSTRAINT_NAME;
   ALTER INDEX INDEX_NAME REBUILD;