OIM DataBase

  1. Tables OIM components.
  2. SQL Query.
  3. Query to get OIM Provsioned/provisioning Account details.
    4.
  4. Query to get usr keys For Rejected / Pending Tasks.
  5. Query To Get Rejected/Pending Count for MIL_NAME/ Status of Tasks.
  6. Manually Cleaning / Archiving Orchestration Tables.
  7. SQL Query to Update SCH table / Manual Update for Provisioning Status.
  8. CLEAN UP DUPLICATED INSTANCES IN PROVISIONED STATUS.
  9. oracle.iam.scheduler.vo.CronTrigger" Error With OIM Schedule Jobs After Upgrade to 11.1.2.3.
  10. SQL Query to get SDK_NAME / Table Name of Object using Object Name (App Instance).
  11. SQL Query to find process tasks in process definition of a Resource Object.
  12. SQL Logging mechanism to debug OIM DB PLSQL Blocks.
  13. SQL Queries to get Constraints and Indexes from OIM Tables.
  14. SQL Query to Create Lookup Values.
  15. How To Generate AWR report using Oracle DB from Console / UI.
  16. PLSQL/SQL to Convert from BLOB to TEXT of AUD_JMS table JMS_VALUE Column.
    17.
  17. PLSQL/SQL code to convert BLOB data To CLOB.
  18. Cleanup the 'Provisioning' Accounts without touching 'Provisioned' Accounts.
  19. How to increase value of open_cursors and processes in Oracle DB.
  20. How to open sqlplus in linux.
  21. Create auto increment field in Oracle database.
  22. Change character set in oracle database - AL32UTF8.
  23. Create and Configure a Database using Database Configuration Assistant(DBCA).
  24. Delete a Database using Database Configuration Assistant(DBCA).
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)