- Installation and Upgrade Guide
- Upgrading Oracle Grid Infrastructure
- Downgrading Oracle Clusterware After an Upgrade
- Downgrading to Oracle Grid Infrastructure 12c Release 1 (12.1)
11.11.1 Downgrading to Oracle Grid Infrastructure 12c Release 1 (12.1)
Use this procedure to downgrade to Oracle Grid Infrastructure 12c release 1 (12.1).
- Optional: Delete the Oracle Grid Infrastructure 12c release 2 (12.2) Management Database:
dbca -silent -deleteDatabase -sourceDB -MGMTDB
- Use the command syntax
rootcrs.bat -downgrade
to downgrade Oracle Grid Infrastructure on all nodes, in any sequence.For example:
C:\app\12.2.0\grid
\crs\install\rootcrs.bat -downgradeRun this command from a directory that has write permissions for the Oracle Grid Infrastructure installation user. You can run the downgrade script in parallel on all cluster nodes, but one.
- Downgrade the last node after you downgrade all other nodes.
C:\app\12.2.0\grid
\crs\install\rootcrs.bat -downgrade - Remove the Oracle Grid Infrastructure 12c release 2 (12.2) Grid home as the active Oracle Clusterware home:
- On any of the cluster member nodes where the
rootcrs.bat -downgrade
command has run successfully, log in as the Oracle Grid Infrastructure installation owner. - Use the following command to start the installer, where
is the location of the new (upgraded) Grid home:C:\app\12.2.0\grid
cd
C:\app\12.2.0\grid
\oui\bin setup.exe -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=false ORACLE_HOME=C:\app\12.2.0\grid
"CLUSTER_NODES=node1,node2,node3" LOCAL_NODE=local_node_running_the_command -doNotUpdateNodeListAdd the flag
-cfs
if the Grid home is a shared home.
- On any of the cluster member nodes where the
- Set Oracle Grid Infrastructure 12c release 1 (12.1) Grid home as the active Oracle Clusterware home:
- On any of the cluster member nodes where the
rootcrs.bat -downgrade
command has run successfully, log in as the Oracle Grid Infrastructure installation owner. - Use the following command to start the installer, where the path you provide for
ORACLE_HOME
is the location of the home directory from the earlier Oracle Clusterware installation.cd
C:\app\12.1.0\grid
\oui\bin
setup.exe -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true ORACLE_HOME=C:\app\12.1.0\grid
"CLUSTER_NODES=node1,node2,node3" -doNotUpdateNodeList
- On any of the cluster member nodes where the
- Start the Oracle Grid Infrastructure 12c release 1 (12.1) clusterware stack from the old Grid home on each node to complete the downgrade.
crsctl start crs
- On any node, remove the MGMTDB resource as follows:
121_Grid_home\bin\srvctl remove mgmtdb
- If you are downgrading to Oracle Grid Infrastructure 12c release 1 (12.1.0.2), run the following commands to configure the Grid Infrastructure Management Database:
- Run DBCA in silent mode from the Oracle Database 12c release 1 (12.1.0.2) home and create the Management Database container database (CDB) as follows:
12102_Grid_home\bin\dbca -silent -createDatabase -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName ASM_DG_NAME -datafileJarLocation 12102_grid_home\assistants\dbca\templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck
- Run DBCA in silent mode from the Oracle Database 12c release 1 (12.1.0.2) home and create the Management Database pluggable database (PDB) as follows:
12102_Grid_home\bin\dbca -silent -createPluggableDatabase -sourceDB -MGMTDB -pdbName cluster_name -createPDBFrom RMANBACKUP -PDBBackUpfile 12102_Grid_home\assistants\dbca\templates\mgmtseed_pdb.dfb -PDBMetadataFile 12102_Grid_home\assistants\dbca\templates\mgmtseed_pdb.xml -createAsClone true -internalSkipGIHomeCheck
- Run DBCA in silent mode from the Oracle Database 12c release 1 (12.1.0.2) home and create the Management Database container database (CDB) as follows:
- If you are downgrading to Oracle Grid Infrastructure 12c release 1 (12.1.0.1), run DBCA in silent mode from the Oracle Database 12c release 1 (12.1.0.1) home and create the Management Database as follows:
12101_Grid_home\bin\dbca -silent -createDatabase -templateName MGMTSeen_Database.dbc -sid -MGMTDB -gdbName _mgmtdb -storageType ASM -diskGroupName ASM_DG_NAME -datafileJarLocation 12101_Grid_home\assistants\dbca\templates -characterset AL32UTF8 -autoGeneratePasswords
- Configure the Management Database by running the Configuration Assistant from the location
121_Grid_home
\bin\mgmtca
.