MAR Update or Metadata Merge Issue

When you start the Oracle Identity Manager Managed Severs for the first time after upgrade, if you encounter any error during the bootstrap process which is related to MARUPDATE bootstrap task, run the external utility mergeMDSDataAfterUpgrade.sh from the 12c Middleware Home to re-trigger the Metadata Services (MDS) merge process.

The upgrade utility merges the existing 11.1.2.3.0 MDS data with 12c Out of the Box (OOTB) to preserve the customization.

When you start the OIM Managed Server for the first time, if you encounter errors for MARUPDATE bootstrap task, check if the issue is occurring during the MDS merge process. If so, run an external utility to re-trigger the MDS merge process as described in this section.

To check if the issue is occurring during the MDS merge process, do the following:

1. Connect to the Oracle Identity Manager database.

2. Use the following SQL query to check the status of the MARUPDATE bootstrap task:

   select State from OIMBootState where  FEATURENAME='MARUPDATE';

3. If the query returns VALID or COMPLETE, the issue is not because of the MDS merge failure. Therefore, no action is required. If the query returns any other result, run the merge utility to re-trigger the MDS merge process.

To re-trigger the MDS merge process using the merge utility, complete the following steps:

1. The OIM pre-upgrade reports folder must exist on the same machine from which the MDS merge utility is going to be triggered. If the pre-upgrade reports are on a different machine, copy them to the machine from which you wish to run the merge utility. The pre-upgrade report utility takes a back up of the MDS data and saves it in the pre-upgrade reports folder.
   The MDS backup data is located at <oim.outputreportfolder>/MDS-Backup folder. <oim.outputreportfolder> is the path that you specified for the property oim.outputreportfolder in the preupgrade_report_input.properties file, when generating the pre-upgrade reports for OIM.
2. Run the following command from the location ORACLE_HOME/idm/server/bin/mergeMDSDataAfterUpgrade.sh
   You must specify the location of the OIM pre-upgrade reports folder. The MDS merge utility that you triggered merges the MDS backup data from the pre-upgrade reports folder with the 12c data OOTB.
3. After the successful completion of the MDS merge process, connect to the OIM database and run the following query: update OIMBootState set State=’COMPLETE’ where FEATURENAME=’MARUPDATE’;
4. Restart the OIM Managed Server.

(Optional) Enter the result of the procedure here.