By Mike Dietrich-Oracle on Aug 05, 2015
And Markus Michalewicz, our Director of Product Management, Oracle Real Application Clusters (RAC), has published a very interesting and helpful insight article about GIMR on July 30, 2015. Read it here:
Since Oracle Database 184.108.40.206 the GIMR database will be created by default - and it is a single tenant database having a CDB$ROOT and one active PDB.
Recently the question came up if - in the likely event of applying a PSU or BP to the GI Home - you'll have to run datapatch manually to adopt the SQL changes for the PSU/BP into the GIMR database as well?
Simple answer: No.
SQL changes will be automatically applied to the GIMR database by default. This got introduced in Oracle 220.127.116.11 with the PSU1 already and is tracked by ER BUG 14830129 - MGMT DATABASE PATCH ACTIONS NEED TO RUN DURING GI POST PATCH PHASE
You can verify this by looking at your logs (Thanks Santosh!) - you should see something similar as:<grid_home>/cfgtoollogs/crsconfig/crspatch_xxxx file
2015-07-15 15:36:51: Mgmtdb is running on node: racnode1; local node: racnode1
2015-07-15 15:36:51: Mgmtdb is running on the local node
2015-07-15 15:36:51: Starting to patch Mgmt DB ...
2015-07-15 15:36:51: Invoking "/opt/oracle/app/12.1.0/grid/sqlpatch/sqlpatch -db -MGMTDB"
2015-07-15 15:36:51: Running as user oracle: /opt/oracle/app/12.1.0/grid/sqlpatch/sqlpatch -db -MGMTDB
2015-07-15 15:36:51: Invoking "/opt/oracle/app/12.1.0/grid/sqlpatch/sqlpatch -db -MGMTDB" as user "oracle"
2015-07-15 15:36:51: Executing /bin/su oracle -c "/opt/oracle/app/12.1.0/grid/sqlpatch/sqlpatch -db -MGMTDB"
2015-07-15 15:36:51: Executing cmd: /bin/su oracle -c "/opt/oracle/app/12.1.0/grid/sqlpatch/sqlpatch -db -MGMTDB"
2015-07-15 15:37:50: Command output:
> SQL Patching tool version 18.104.22.168.0 on Tue Jul 15 15:36:51 2015
> Copyright (c) 2015, Oracle. All rights reserved.
> Connecting to database...OK
> Note: Datapatch will only apply or rollback SQL fixes for PDBs
> that are in an open state, no patches will be applied to closed PDBs.
> Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
> (Doc ID 1585822.1)
> Determining current state...done
> Adding patches to installation queue and performing prereq checks...done
> Installation queue:
> For the following PDBs: CDB$ROOT PDB$SEED CRS
> Nothing to roll back
> The following patches will be applied:
> 20831110 (Database Patch Set Update : 22.214.171.124.4 (20831110))
> Installing patches...
> Patch installation complete. Total patches installed: 3
> Validating logfiles...done
> SQL Patching tool complete on Tue Jul 21 15:37:50 2015
For all the skeptical people (Germans especially) let me add that in Oracle Database 126.96.36.199 the Grid Infrastructure Management Repository (GIMR) is not mandatory - but its existence will be mandatory for a future upgrade to Grid Infrastructure 12.2.