Oracle® Fusion Middleware System Administrator's Guide for Oracle Identity Manager 11g Release 1 (11.1.1) Part Number E14308-05 |
|
|
View PDF |
This chapter describes how to use the various archival utilities in the following sections:
This section describes how to use the Reconciliation Archival utility. It contains the following topics:
Oracle Identity Manager stores reconciliation data from target systems in Oracle Identity Manager tables called active reconciliation tables:
During the reconciliation process, Reconciliation Manager reconciles data in the active reconciliation tables with the Oracle Identity Manager core tables. Because Reconciliation Manager does not remove reconciled data from the active reconciliation tables, they might eventually grow very large, resulting in decreased performance during the reconciliation process. You can use the Reconciliation Archival utility to archive data that has been reconciled with Oracle Identity Manager. The Reconciliation Archival utility stores archived data in the archive reconciliation tables, which have the same structure as the active reconciliation tables.
Table 22-1 lists the active reconciliation tables with the corresponding archive reconciliation tables in which data from the active reconciliation tables are archived.
Table 22-1 Active and Archive Reconciliation Tables
Active Reconciliation Tables (Oracle Identity Manager Tables) | Archive Reconciliation Tables |
---|---|
RECON_EVENTS |
ARCH_RECON_EVENTS |
RECON_JOBS |
ARCH_RECON_JOBS |
RECON_BATCHES |
ARCH_RECON_BATCHES |
RECON_EVENT_ASSIGNMENT |
ARCH_RECON_EVENT_ASSIGNMENT |
RECON_EXCEPTIONS |
ARCH_RECON_EXCEPTIONS |
RECON_HISTORY |
ARCH_RECON_HISTORY |
RECON_USER_MATCH |
ARCH_RECON_USER_MATCH |
RECON_ACCOUNT_MATCH |
ARCH_RECON_ACCOUNT_MATCH |
RECON_CHILD_MATCH |
ARCH_RECON_CHILD_MATCH |
RECON_ORG_MATCH |
ARCH_RECON_ORG_MATCH |
RECON_ROLE_MATCH |
ARCH_RECON_ROLE_MATCH |
RECON_ROLE_HIERARCHY_MATCH |
ARCH_RECON_ROLE_HIER_MATCH |
RECON_ROLE_MEMBER_MATCH |
ARCH_RECON_ROLE_MEMBER_MATCH |
RA_LDAPUSER |
ARCH_RA_LDAPUSER |
RA_MLS_LDAPUSER |
ARCH_RA_MLS_LDAPUSER |
RA_LDAPROLE |
ARCH_RA_LDAPROLE |
RA_MLS_LDAPROLE |
ARCH_RA_MLS_LDAPROLE |
RA_LDAPROLEMEMBERSHIP |
ARCH_RA_LDAPROLEMEMBERSHIP |
RA_LDAPROLEHIERARCHY |
ARCH_RA_LDAPROLEHIERARCHY |
All reconciliation horizontal tables |
"ARCH_" + substr(HTnames,1,25) |
You can use the Reconciliation Archival utility to perform the following tasks:
Archive all or specific data from the active reconciliation tables to the archive reconciliation tables
Delete all data from the active reconciliation tables
When you archive data by moving it from the active reconciliation tables to the archive reconciliation tables, you must specify the date in the YYYYMMDD format, such as all records before this date will be archived, and a reconciliation event status parameter value, which defines the data that you want to archive. For information about these archiving criteria, refer to "Archival Criteria".
If you choose to archive selective data, then the utility archives data that falls in the specified date range and event status.
When you archive all data from the active reconciliation tables to the archive reconciliation tables, the Reconciliation Archival utility archives all reconciliation data with event status of Event Linked or Event Closed.
The files that constitute the Oracle Database version of the Reconciliation Archival utility are located in the following directory:
OIM_HOME/db/oim/oracle/Utilities/Recon11gArchival
Before running the Reconciliation Archival utility, the OIM_RECON_ARCH tablespace must be created in the database. To do so, you can run the following sample command:
CREATE TABLESPACE OIM_RECON_ARCH LOGGING DATAFILE 'OIM_RECON_ARCH' SIZE 500M REUSE AUTOEXTEND ON NEXT 10M;
Note:
You must set LD_LIBRARY_PATH to start Oracle utilities such as SQL*Plus in the environment where you want to run Oracle Identity Manager utilities.
Data that has been archived from the active reconciliation tables to the archive reconciliation tables will no longer be available through Oracle Identity Manager. To access this data, you must query the archive reconciliation tables in your Oracle Identity Manager database.
To select reconciliation data to archive, provide the following criteria. Data with matching values will be archived.
Date must be in the format YYYYMMDD. All records before this date that match the specified reconciliation event parameter value will be archived.
Select Closed, Linked, Closed or Linked, or All for the reconciliation event parameter.
Closed describes events that have been manually closed in Reconciliation Manager.
Linked describes events that were reconciled in Oracle Identity Manager, including the following states:
Creation Succeeded
Update Succeeded
Delete Succeeded
Creation Failed
Update Failed
Delete Failed
Closed or Linked
All archives all events regardless of status
To run the Reconciliation Archival utility:
Ensure that the Oracle Identity Manager database is available and that no reconciliation processes are running. In addition, ensure that the Oracle Identity Manager database is not open to transactions for other sessions.
Note:
Oracle recommends that you run the Reconciliation Archival utility during off-peak hours.Stop the Oracle Identity Manager by following the instructions in the "Starting and Stopping Servers" chapter.
On Microsoft Windows platforms, you must specify the short date format as M/d/yyyy. In addition, you must specify the time format as H:mm:ss. To customize the date and time formats, use the Regional and Language Options command in Control Panel.
Note:
When you change the date and time format, the change is applied to all the applications running on the Microsoft Windows platform.
Minimal validation is done on date before calling the utility, and you can scan logs files for any ORA-18xx errors for invalid date-related errors.
On Linux or UNIX platforms, run the following commands to set execution permission for the oim_recon_archival.sh file and to ensure that the file is a valid Linux or UNIX text file:
chmod 755 path/oim_recon_archival.sh dos2unix path/oim_recon_archival.sh
On Linux or UNIX platforms, run the path/oim_recon_archival.sh file. On Microsoft Windows platforms, run the path\oim_recon_archival.bat file.
For Oracle Database installations, enter values for the following parameters when prompted:
Oracle home directory
Input for validating whether the Oracle Identity Manager database is running on a remote computer
For a remote database, a connection string is required as input, which is of the following format: //HOST_NAME:PORT/SERVICE_NAME
Oracle Identity Manager database user name and password
When prompted, select a reconciliation event status for the data that you want to archive:
Enter 1 for Closed
Enter 2 for Linked
Enter 3 for Closed or Linked
Enter 4 for All
Enter 5 for Exit
Enter the reconciliation creation date in the YYYYMMDD format. All records before this date with required status value will be archived.
Enter the batch size for processing.
The default batch size is 2000.
On Microsoft Windows platforms, reset the short date format to the date format for your region or locale after you run the utility. Use the Regional and Language Options command in Control Panel to reset the date format.
Because the data from active reconciliation tables are removed, your DBA must analyze the active reconciliation tables and their indexes in order to update the statistics. Perform this step only if you are using Oracle Database as the database for Oracle Identity Manager.
After running the Reconciliation Archival utility, the following log file is generated:
./logs/oim_recon_archival_summary_TIMESTAMP.log
If the running the utility fails, then the log file records the batch number at which the utility fails along with the error messages.
This section describes how to use the Task Archival utility. It contains the following topics:
In Oracle Identity Manager, a task refers to one or more activities that comprise a process, which handles the provisioning of a resource. For example, a process for requesting access to a resource may include multiple provisioning tasks. Oracle Identity Manager stores task data in the following tables, which are called active task tables:
OSI
OSH
SCH
By default, Oracle Identity Manager does not remove completed tasks from the active task tables. As the size of the active task tables increases, you might experience a reduction in performance, especially when managing provisioning tasks. After a task executes successfully, you can use the Task Archival utility to archive the task data and remove it from the active task tables. Archiving task data with the Task Archival utility improves performance and ensures that the data is safely stored.
The Task Archival utility stores archived task data in the following archive task tables, which have the same structure as the active task tables:
ARCH_OSI
ARCH_OSH
ARCH_SCH
You can use the Task Archival utility to archive the following types of tasks:
Provisioning tasks for resource instances that have been revoked for disabled or deleted users
Provisioning tasks for resource instances that have been revoked
When you archive tasks with the Task Archival utility, you can specify the type of archive operation, the user status, the task execution date, and the number of records above which to drop the indexes before archiving. The archive operation represents the type of task data to archive and the user status determines whether to archive data for users who have been deleted, disabled, or both. The task execution date represents the date on which a task is executed and must be in the format YYYYMMDD.
All executed tasks, up to the task execution date you specify, will be archived. To reduce the time that the archiving process takes, the utility drops the indexes on all active task tables when the number of records to be archived is greater than 200000. The indexes are re-created after the archived data is deleted from the active task tables. You can change the value 200000 to your preferred value. You can change the value in the following lines of code in the OIM_TasksArch.bat file or in the OIM_TasksArch.sh file:
In the .bat file, set INDXRESP=200000
In the .sh file, indxopt=200000
The files that constitute the Oracle Database version of the Task Archival utility are located in the following directory:
OIM_HOME/db/oim/oracle/Utilities/TaskArchival
Note:
Data that has been archived from the active task tables to the archive task tables will no longer be available through Oracle Identity Manager. To access this data, you must query the archive task tables in your Oracle Identity Manager database.Before you can use the Task Archival utility with Oracle Database, you must perform the following steps:
Start SQL*Plus and connect to Oracle Database as a SYS user.
Create a separate tablespace for the archival task tables by entering the following command. Replace DATA_DIR with the directory in which you want to store the data file and adjust the size and other parameters as necessary for your environment.
CREATE TABLESPACE TasksArch
DATAFILE 'DATA_DIR\tasksarch_01.dbf' SIZE 1000M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Note:
Oracle recommends that you allocate a large UNDO tablespace when archiving large amounts of data. In addition, turn on parallel execution by configuring the parallel_max_servers and parallel_min_servers initialization parameters. Parallel execution helps improve the performance of the archival process.Connect to Oracle Database as the Oracle Identity Manager database user.
Enter the following command to run the cr_taskarchival_ddl_table.sql script, which creates a table named OIM_TASK_ARCH_DDL. This table is used by the Task Archival utility.
@ path/cr_taskarchival_ddl_table.sql
Enter the following command to run the Create_TasksArch_Tables.sql script, which creates the archive task tables:
@ path/Create_TasksArch_Tables.sql
Enter the following command to run the OIM_SP_TASKS_ARCHIVAL.sql script, which creates a stored procedure that the Task Archival utility uses to archive and delete task data:
@ path/OIM_SP_TASKS_ARCHIVAL.sql
If your Oracle Database instance is running in ARCHIVELOG mode, you must switch to NOARCHIVELOG mode before running the Task Archival utility. See Oracle Database Administrator's Guide for information about changing the database archiving mode.
Note:
You must set LD_LIBRARY_PATH to start Oracle utilities such as SQL*Plus in the environment where you want to run Oracle Identity Manager utilities.Perform the following steps to run the Task Archival utility:
Ensure that the Oracle Identity Manager database is available and that no reconciliation processes are running. Also, ensure that the Oracle Identity Manager database is not open to transactions for other sessions.
Note:
Oracle recommends that you run the Task Archival utility during off-peak hours.Back up the OSI, SCH, and OSH tables.
Stop Oracle Identity Manager by following the instructions in the Oracle Identity Manager installation guide for your application server.
On Microsoft Windows platforms, you must specify the short date format as dddd M/d/yyyy. In addition, you must specify the time format as H:mm:ss. To customize the date and time formats, select the Regional and Language Options command in the Control Panel.
Note:
When you change the date and time format, the change is applied to all the applications running on the Microsoft Windows platform
Minimal validation is done on date before calling the utility, and you can scan logs files for any ORA-18xx errors for invalid date-related errors
On Linux and UNIX platforms, run the path/OIM_TasksArch.sh file. On Microsoft Windows platforms, run the path\OIM_TasksArch.bat
file.
For Oracle Database installations, enter values for the following parameters when prompted:
Oracle home directory
Oracle Identity Manager database name or TNS string if the Oracle Identity Manager database is running on a remote computer
For a remote database, a connection string is required as input, which is of the following format: //HOST_NAME:PORT/SERVICE_NAME
Oracle Identity Manager database user name and password
When prompted, select one of the following options:
Archive all provisioning tasks on resource instances that have been revoked for disabled or deleted users.
Archive all provisioning tasks on resource instances that have been revoked.
Exit.
If you chose to archive all provisioning tasks for resource instances that have been revoked for disabled or deleted users, select one of the following options:
Users at Deleted status
Users at Disabled status
Users at Deleted and Disabled status
Go back to Main Menu
Enter a task execution date in the format YYYYMMDD when prompted. All executed tasks, up to the task execution date you specify, will be archived. To archive all tasks that were executed on or before the current date, press Enter without entering a date.
Enter a value of y or Y when prompted to archive the tasks. Otherwise, enter a value of n or N to exit the utility.
Note:
You must enter the value of Y or N when prompted. If you press Enter without selecting a value, then the utility again counts the number of tasks to be archived and prompts you without beginning the archive.On Microsoft Windows platforms, reset the short date format to the date format for your region or locale after the Task Archival utility finishes running. Use the Regional and Language Options command in the Control Panel to reset the date format.
Note:
You must analyze the active task tables and their indexes for updated statistics, because the data from active task tables is removed. Perform this step only if you are using Oracle Database as the database for Oracle Identity Manager.Table 22-2 describes the output files that are generated by the Task Archival utility.
Table 22-2 Output Files Generated by the Task Archival Utility
File | Description |
---|---|
|
Generated when the utility is unable to connect to the database with the specified credentials |
|
Generated when the archival or deletion processes fail |
|
Generated when the archival or deletion processes succeed |
Note:
These error log files are deleted when you run the utility again.This section describes how to use the Platform Archival utility. It contains the following topics:
Oracle Identity Manager stores platform data from the target systems in the following tables, which are called active platform tables:
ORCHPROCESS
ORCHEVENTS
ORCHFAILEDEVENTS
CONTEXT
CONTEXTVALUE
By default, Oracle Identity Manager does not remove completed transaction data from the active platform tables. As the size of the active platform table increases, you might experience a deterioration in the performance of Oracle Identity Manager. You can use the Platform Archival utility to archive data processed by Oracle Identity Manager and remove it from the active platform table. Archiving transaction data with the Platform Archival utility enhances performance and ensures that the data is safely stored.
Note:
Platform data cleanup can also be performed by using the Orchestration Process Cleanup Task scheduled task. However, this task does not support archival of orchestration process data. See "Predefined Scheduled Tasks" for information about this scheduled task.The Platform Archival utility stores archived data in the following tables, called archival platform tables, which have the same structure as the active platform tables:
ARCH_ORCHPROCESS
ARCH_ORCHEVENTS
ARCH_ORCHFAILEDEVENTS
ARCH_CONTEXT
ARCH_CONTEXTVALUE
Note:
Data archived from the active platform tables to the archival platform tables is not available through Oracle Identity Manager. You must query the archival platform tables in your Oracle Identity Manager database to access the required data.The files that constitute the Oracle Database version of the Platform Archival utility are located in the following directory:
OIM_HOME/db/oim/oracle/Utilities/PlatformArchival
Table 22-3 lists the files that comprise the Platform Archival Utility.
Table 22-3 Scripts Constituting the Platform Archival Utility
Script | Description |
---|---|
OIM_PlatformArch.bat |
It is a driver batch file used in Microsoft Windows environment for Platform Archival Utility. |
OIM_PlatformArch.sh |
It is a driver Shell Script used in UNIX environment for Platform Archival Utility. |
OIM_SP_PlatformArchival |
It is a stored procedure used for archiving data. |
Create_PlatformArch_Tables.sql |
It is a script that is used to create the archival platform tables. |
Cr_PlatformArchival_DDL_Table.sql |
It is a script to create a table to store the DDL commands for recreating the indexes and constraints. |
Before you can use the Platform Archival utility with Oracle Database, you must perform the following steps:
Start Oracle SQL*Plus and connect to Oracle Database as a user with Create Tablespace privileges or SYSDBA privileges, such as SYS
user.
Enter the following command to run the oim_archival_tablespace_setup.sql script, which creates a separate tablespace for the archival platform tables:
@ path/oim_archival_tablespace_setup.sql
Note:
You must set LD_LIBRARY_PATH to start Oracle utilities such as SQL*Plus in the environment where you want to run Oracle Identity Manager utilities.Perform the following steps to run the Platform Archival utility:
Ensure that the Oracle Identity Manager database is available. In addition, verify that the Oracle Identity Manager database is not open for transactions with other sessions.
Note:
Oracle recommends that you run the Platform Archival utility during off-peak hours.Back up the ORCHPROCESS
, ORCHEVENTS
, ORCHFAILEDEVENTS
, CONTEXT
, and CONTEXTVALUE
tables.
Stop the Oracle Identity Manager by following the instructions in the "Starting and Stopping Servers"chapter.
On Microsoft Windows platforms, specify the short date format as dddd M/d/yyyy
. In addition, you must specify the time format as H:mm:ss
.
To customize the date and time format, select the Regional and Language Options command in the Control Panel.
Note:
When you change the date and time format, the change is applied to all the applications running on the Microsoft Windows platform.
Minimal validation is done on date before calling the utility, and you can scan logs files for any ORA-18xx errors for invalid date-related errors.
On Linux and UNIX platforms, run the following commands to set execution permission for the OIM_PlatformArch.sh
file and to ensure that the file is a valid Linux and UNIX text file:
chmod 755 path/OIM_PlatformArch.sh dos2unix path/OIM_PlatformArch.sh
On Linux and UNIX platforms, run the path/OIM_PlatformArch.sh
file. On Microsoft Windows platforms, run the path\OIM_PlatformArch.bat
file.
For Oracle Database installations, enter values for the following parameters when prompted:
Oracle home directory
Oracle Identity Manager database name or TNS string, if the Oracle Identity Manager database is running on a remote computer
For a remote database, a connection string is required as input, which is of the following format: //HOST_NAME:PORT/SERVICE_NAME
Oracle Identity Manager database user name and password
Enter the date range in YYYYMMDD
format when prompted.
When prompted, select one of the following menu options:
1) Archive Orchestration Process Instance Data
2) Archive Context Data
3) Exit
See "Platform Archival Utility Menu Options" for more information.
If you select Archive Orchestration Process Instance Data
, you are prompted for the archival criteria.
Enter the batch size for processing.
The default batch size is 2000.
The count of records to be archived is displayed. Enter y
or Y
when prompted to archive the data. Alternatively, enter a value of n
or N
to exit the utility.
Note:
You must enter the value ofY
or N
when prompted. If you press Enter without selecting a value, then the utility again counts the number of records to be archived and prompts you without beginning the archival process.On Microsoft Windows platform, reset the short date format to the date format of your region or locale after you run the utility. Select the Regional and Language Options command in Control Panel to reset the date format.
Note:
You must analyze the active tables and their indexes for updated statistics, because the data from active tables is removed. You need to perform this step, if and only if you are using Oracle Database as the database for Oracle Identity Manager.The Platform Archival Utility presents the following menu options.
This option archives the orchestration process instance data from ORCHPROCESS
, ORCHEVENTS
, and ORCHFAILEDEVENTS
tables into ARCH_ORCHPROCESS
, ARCH_ORCHEVENTS
, and ARCH_ ORCHFAILEDEVENTS
tables based on the archival criteria. The archival criteria comprise two columns MODIFIEDON
and STATUS
.
The format for the MODIFIEDON
archival criteria is YYYYMMDD
and it is mapped to the MODIFIEDON
column in the ORCHPROCESS
table. The MODIFIEDON date is validated and an error is raised, if it is invalid.
The STATUS
criterion is mapped to the STATUS
column in the ORCHPROCESS
table. The STATUS
criterion is COMPLETED
and is fixed.
This option archives the context data from CONTEXT
and CONTEXTVALUE
tables into ARCH_CONTEXT
and ARCH_CONTEXTVALUE
tables based on the archival criteria.
While archiving the utility excludes the context ids that are present in the REQUEST
, FAILED_TASKS
, and ORCHPROCESS
tables with STATUS
as PENDING
.
The format for the MODIFIEDON
archival criterion is YYYYMMDD
and it is mapped to the MODIFIEDON
column in the CONTEXT
table. The archival criterion is validated and an error is raised, if it is invalid. In case the MODIFIEDON
date selected for archival is less than three months, then the following warning is issued:
"WARNING: You are archiving data less than 3 months old. Any pending transaction information will be lost, and those transactions cannot be completed. Do you want to continue?".
Table 22-4 describes the output files that are generated by the Platform Archival utility.
Table 22-4 Output Files Generated by the Platform Archival Utility
File | Description |
---|---|
Err_DB_Conn_timestamp.log |
Generated when the utility is unable to connect to the database with the provided credentials |
Err_Arch_Platform_timestamp.log |
Generated when the archival processes fail |
Arch_Platform_timestamp.log |
Generated when the archival processes succeed |
Note:
These error log files are deleted when you run the utility again.This section describes how to use the Requests Archival utility. It contains the following topics:
Requests that are closed or withdrawn are stored in the Oracle Identity Manager database. To archive these requests and free up the disk space and thereby enhance database performance, the Requests Archival utility is used. You can archive request data based on request creation date and request status. Archiving requests based on the request status is optional. By using request status, you can archive:
Completed requests such as requests with status Withdrawn, Closed, and Completed. This is specified by the user input 1
.
Completed and failed requests such as requests with status Withdrawn, Closed, Completed, Failed, and Partially Failed. This is specified by the user input 2
.
All requests based on request creation date. This is specified by the user input 3
.
The Requests Archival utility involves running the following scripts:
oim_request_archival.bat and oim_request_archival.sh: Driver script batch for Microsoft Windows and shell script for UNIX
oim_create_request_arch_tables.sql: Script with PL/SQL procedure to create archival tables against all tables that need archiving
oim_request_archival.sql: Script with PL/SQL procedure that performs the archive
Table 22-5 lists the names of the tables which are to be archived and the corresponding archival table names.
Table 22-5 Archival Tables
Main Table | Archival Table |
---|---|
REQUEST |
REQUEST_ARCH |
REQUEST_HISTORY |
ARCH_REQUEST_HISTORY |
REQUEST_APPROVALS |
ARCH_REQUEST_APPROVALS |
REQUEST_ENTITIES |
ARCH_REQUEST_ENTITIES |
REQUEST_ENTITY_DATA |
ARCH_REQUEST_ENTITY_DATA |
REQUEST_BENEFICIARY |
ARCH_REQUEST_BENEFICIARY |
REQUEST_BENEFICIARY_ENTITIES |
ARCH_REQUEST_BE |
REQUEST_BENEFICIARY_ENTITYDATA |
ARCH_REQUEST_BED |
REQUEST_TEMPLATE_ATTRIBUTES |
ARCH_REQUEST_TA |
WF_INSTANCE |
ARCH_WF_INSTANCE |
REQUEST_COMMENTS |
ARCH_REQUEST_COMMENTS |
The files that constitute the Oracle Database version of the Requests Archival utility are located in the following directory:
OIM_HOME/db/oim/oracle/Utilities/RequestArchival
Before running the Requests Archival utility:
Note:
You must set LD_LIBRARY_PATH to start Oracle utilities such as SQL*Plus in the environment where you want to run Oracle Identity Manager utilities.Create the OIM_REQUEST_ARCH tablespace. When the Requests Archival utility is run for the first time, a corresponding archival table is created for all the tables that are to be archived. The archival tables are created in a separate tablespace named OIM_REQUEST_ARCH. This tablespace must be created before running the utility.
Create the required archival tables for the request tables by running the oim_create_request_arch_tables.sql script. This is the PL/SQL script to create archival tables against all tables that are to be archived.
Table 22-6 lists the input parameters used by the Requests Archival utility:
Table 22-6 Input Parameters
Parameter | Description |
---|---|
Oracle Home |
The value of ORACLE_HOME environment variable on the system. |
Oracle SID |
The SID of the Oracle Identity Manager database. For a remote database, a connection string is required as input, which is in the following format://HOST_NAME:PORT/SERVICE_NAME Here, HOST_NAME is the host name of the computer on which the database is deployed, PORT is the port number of the host, and SERVICE_NAME is the name of the database instance. |
OIM DB User |
The database login ID of the Oracle Identity Manager database user. |
OIM DB Pwd |
The password of the Oracle Identity Manager database user. |
Request Status |
The request status based on the user inputs 1, 2, or 3. |
Request Creation Date |
The utility archives all requests created on or before this request creation date with the required request status. |
Batch Size |
The utility processes a group of records or batch as a single transaction. The batch size can influence the performance of the utility. Default value of Batch Size is |
To run the Requests Archival utility:
Ensure that the Oracle Identity Manager database is available. In addition, ensure that the Oracle Identity Manager database is not open to transactions for other sessions.
Note:
It is recommended that you run the Requests Archival utility during off-peak hours.Stop Oracle Identity Manager by following the instructions in the "Starting and Stopping Servers" chapter.
On Microsoft Windows platform, you must specify the short date format as dddd M/d/yyyy
. In addition, you must specify the time format as H:mm:ss
. To customize the date and time formats, use the Regional and Language Options command in Control Panel.
Note:
When you change the date and time format, the change is applied to all the applications running on the Microsoft Windows platform.
Minimal validation is done on date before calling the utility, and you can scan logs files for any ORA-18xx errors for invalid date-related errors.
On UNIX platform, run the following commands to set execution permission for the OIM_request_archival.sh
file and to ensure that the file is a valid UNIX text file:
chmod 755 path/OIM_request_archival.sh dos2unix path/OIM_request_archival.sh
On UNIX platform, run the path/OIM_request_archival.sh
file. On Microsoft Windows platform, run the path\OIM_request_archival.bat
file.
The oim_request_archival script validates the database input and establishes a connection with the database. It then calls the oim_request_archival.sql script, the script is used to compile PL/SQL procedures related to the utility.
For Oracle Database installations, enter values for the following parameters when prompted:
Oracle home directory.
Oracle Identity Manager database name or TNS string if the Oracle Identity Manager database is running on a remote computer. Otherwise, enter ORACLE SID.
For a remote database, a connection string is required as input, which is of the following format:
//HOST_NAME:PORT/SERVICE_NAME
Oracle Identity Manager database user name and password.
When prompted, enter one of the following options:
Enter 1 to archive the requests with status Request Withdrawn, Request Closed, or Request Completed, and requests with creation date on or before the request creation date specified by the user in the format YYYYMMDD.
Enter 2 to archive the requests with status Request Withdrawn, Request Closed, Request Completed, or Request Partially Failed, and requests with creation date on or before the request creation date specified by the user in the format YYYYMMDD.
Enter 3 to archive all the requests with request creation date on or before the request creation date specified by the user in the format YYYYMMDD.
Specify the batch size, when prompted.
On Microsoft Windows platforms, reset the short date format to the date format for your region or locale after you run the utility. Use the Regional and Language Options command in Control Panel to reset the date format.
Because the data from active request tables are removed, your DBA must analyze the active request tables and their indexes in order to update the statistics. Perform this step only if you are using Oracle Database as the database for Oracle Identity Manager.
All the logs are written to the logs/ directory created in the current folder. Table 22-7 lists the log files generated by the utility.
Table 22-7 Logs Generated by the DB Archival Utility
Log File | Description |
---|---|
oim_create_request_arch_tables.log |
Created when the utility fails to create the archival tables |
oim_request_archival.log |
Created when the utility fails to create the procedures required for archival |
validate_date.log |
Created when the input REQUEST_CREATION_DATE is invalid |
oim_request_archival_summary_TIMESTAMP.log |
Contains the summary of the run |
Err_DB_Conn_TIMESTAMP_ATTEMPTNUMBER.log |
Created when the utility is unable to connect to the database with the credentials provided |