Oracle® Identity Manager Upgrade Guide Release 9.1.0 (9.0.3.2 Upgrade) Part Number E13340-01 |
|
|
View PDF |
The Oracle Identity Manager Database Validator is a command-line interface (CLI) utility that compares objects of two databases and generates a report of the missing and mismatched objects in the destination database.
You can also use this utility to verify an upgrade that you perform.
The Oracle Identity Manager Database Validator compares objects of a standard Oracle Identity Manager schema or a customized Oracle Identity Manager database (source) with a destination database that you specify.
The utility gathers source database details in a table. This information is the standard for comparison. For Oracle Database, the information is saved in a file that is created by the database export utility.
In upgrade scenarios, you can use this utility to verify an upgrade that you perform. You can compare the upgraded Oracle Identity Manager database with the provided standard dump (as source dump). This is to verify the success of Oracle Identity Manager database upgrade after the upgrade patch is applied.
Scenario: You upgrade your Oracle Identity Manager installation from release x.x.1 to release x.x.2 by using a standard upgrade package. Oracle Identity Manager Database Validator identifies the missing and mismatched objects, if any, after the upgrade has been completed.
The Oracle Identity Manager Database Validator files are at the following location:
Oracle Database
PATCH\db\oracle\Utilities\OIMDBValidator
All Oracle Identity Manager Database Validator files are located in the OIMDBValidator folder.
Table B-1 provides details of the files that are part of the Oracle Identity Manager Database Validator.
Table B-1 Files of the Oracle Identity Manager Database Validator
File | Description |
---|---|
oim_ddl_create_oim_src_db.sql |
Creates the oim_src_db table. |
oim_dml_populate_oim_src_db.sql |
Populates the oim_src_db table with metadata details. |
oim_dml_src_do_counts.sql |
Takes the row count of Oracle Identity Manager standard tables. This file is optional and is based on your inputs. |
If Source is a standard database, then: oim_std_src_db.dmp |
If Source is a standard/vanilla database, then the standard dump files is named oim_std_src_db.dmp. For a successful standard vanilla installation, a standard dump accompanies the utility. This standard file for Oracle Database is available at the following location: PATCH\db\oracle\Utilities\OIMDBValidator\SrcInfo |
If Source is a customized database, then: oim_src_db.dmp |
You can opt to generate the dump file on your own. This file is created when you want to create a dump file from a source Oracle Identity Manager database of your choice. It is named oim_src_db.dmp, and for Oracle Database, it is available at the following location: For Oracle: PATCH\db\oracle\Utilities\OIMDBValidator\SrcInfo |
oim_dml_check_oim_version.sql |
Selects the version from the oim_src_db table and compares it with the version of the XSD table of the Destination Oracle Identity Manager schema. |
oim_ddl_create_oim_dest_db.sql |
Creates the oim_dest_db table in the destination Oracle Identity Manager database. This file is used to store the data dictionary information of Oracle Identity Manager. |
oim_dml_populate_oim_dest_db.sql |
Populates the oim_dest_db table with metadata details. |
oim_dml_dest_do_counts.sql |
Counts the number of records in the Oracle Identity Manager standard tables. This file is optional and is based on your input. |
oim_db_compare.sql |
This main comparison script creates a comparison report named COMPARISON_SUMMARY_YYYY_MM_DD_HH_MI.log that lists details of the missing or mismatched objects and the row count difference if any. |
oim_ddl_drop_oim_src_dest_db.sql |
Drops the tables that are created at the destination. This file is optional and is based on your input. |
oim_db_validator.bat (Microsoft Windows) oim_db_validator.sh (UNIX) |
Runs the utility. |
oim_db_input.bat (Microsoft Windows) oim_db_input.sh (UNIX) |
The oim_db_validator.bat file calls the oim_db_input.bat file to get the user input and validate the provided information. The oim_db_validator.sh file calls the oim_db_input.sh file to get the user input and validate the provided information. |
To use the Database Validator utility, run the following script:
On Microsoft Windows: oim_db_validator.bat
On UNIX: oim_db_validator.sh
After you run the script, a log file is generated with the following name:
For Microsoft Windows:
If the utility runs without error: oim_db_validator_YYYY_MM_DD_HH_MM.log
In case of error: oim_db_validator_err_YYYY_MM_DD_HH_MM.log
For UNIX:
If the utility runs without error: oim_db_validator_YYYY_MM_DD_HH_MM.log
In case of error: oim_db_validator_err_YYYY_MM_DD_HH_MM.log
Authentication
When you run the script, you are prompted to enter the following information:
Oracle Home name
Database Name
Database User name
Database Password
The utility permits only three connection attempts.
Functionality
The following options are available:
Collect Details about the Source Oracle Identity Manager Database:
Enter 1 to select this option.
Select this option to collect details of a specific source.
The utility generates a .dmp file that is named based on your input of whether or not the source is a standard Oracle Identity Manager installation.
For standard Oracle Identity Manager installation: The file is named oim_std_src_db.dmp.
This file is shipped along with the utility and is available in the following directory:
PATCH\db\oracle\Utilities\OIMDBValidator\SrcInfo
You can use this file for comparison or upgrade verification.
For nonstandard Oracle Identity Manager installation: The file is named oim_src_db.dmp.
Compare Source Oracle Identity Manager Database with a Destination Oracle Identity Manager Database:
Enter 2 to select this option.
Choose either to compare against a standard dump or a user-created dump for a specific source:
To compare against a standard dump, copy oim_std_src_db.dmp from SoureMetadataDump910 to SrcInfo. If SrcInfo is not already available, then create a new directory. The oim_std_src_db.dmp file is a dump of OIM 910 Vanilla installation.
Note:
If the comparison with the standard dump indicates any difference, then contact Oracle support.To compare against a user-created dump, copy your dump file to SrcInfo. The name of the dump file must be oim_src_db.dmp.
Note:
For Microsoft SQL Server, the dump file extension is .bcp instead of .dmp.You have options for choosing the source for comparison, whether to calculate the number of rows in the destination Oracle Identity Manager database tables, or to drop the comparison tables.
Exit: Enter 3 to select this option.
Choose this option to close the utility.
The following is a sample summary report of the Database Validator utility:
################################################################################################### R E P O R T ########################## ######################################################################## Start Time (hh:mi:ss:mmm) : 15:09:39:370 =============================================================== ======================= S U M M A R Y =========================== =============================================================== OIM OBJECT TYPE SOURCE DESTINATION COMPARE STATUS --------------- ----------- ----------- --------------------- ------------------- TABLE 6 5 1 TABLE MISSING COLUMN 26 23 3 COLUMNS MISSING PK 6 5 1 PKS MISSING PK COL 7 6 1 PK COLS MISSING FK 1 0 1 FKS MISSING FK COL 1 0 1 FK COLS MISSING U INDEX 2 2 SUCCESSFUL UIDX COL 5 5 SUCCESSFUL NU INDEX 1 1 SUCCESSFUL NUIDX COL 1 1 SUCCESSFUL VIEW 1 1 SUCCESSFUL PROCEDURE 1 1 SUCCESSFUL FUNCTION 1 1 SUCCESSFUL TRIGGER 1 1 SUCCESSFUL =============================================================== DETAILS OF DIFFERENCES =============================================================== ####################### MISSING OBJECTS ######################### MISSING OBJECT'S NAME MISSING OBJECT'S TYPE ------------------------------ ------------------------------ AAP TABLE PK_AAP PK FK_AAD_FK_AAD_AC_ACT FK #####################MIS-MATCHEDOBJECTS ################# ********************* MISSING TABLE COLUMNS ********************* OBJECT NAME OBJECT TYPE PARENT OBJECT PARENT OBJECT TYPE DATATYPE COLUMN LENGTH ISNULL -------------------- ----------- -------------------- ------------------ --------------- ------------- ----- AAP_KEY COLUMN AAP TABLE numeric 9 NO ACT_KEY COLUMN AAP TABLE numeric 9 NO AAP_VALUE COLUMN AAP TABLE varchar 200 YES ******************************************************* COLUMN DETAILS OF PRIMARY KEYS, FOREIGN KEYS & INDEXES ******************************************************* OBJECT NAME OBJECT TYPE PARENT OBJECT PARENT OBJECT TYPE COLUMN POSITION CHILD TABLE CHILD TABLE COLUMN -------------------- ----------- -------------------- ------------------ --------------- -------------------- -------------------- AAP_KEY PK COL PK_AAP PK 1 ACT_KEY FK COL FK_AAD_FK_AAD_AC_ACT FK 1 ACT ACT_KEY =============================================================== SEED METADATA COMPARISION =============================================================== NO DIFFERENCES FOUND. End Time (hh:mi:ss:mmm) : 15:09:39:387