A Oracle Data Guard Broker Upgrading and Downgrading
Use these topics to upgrade or downgrade Oracle databases and Oracle Enterprise Manager Cloud Control (Cloud Control) in a broker configuration.
See Also:
Oracle Data Guard InstallationConsiderations While Using the DBMS_ROLLING Package
When upgrading from Oracle Database Version 12.2 to a higher database version, broker management can remain enabled. However, some considerations must be kept in mind.
The considerations are as follows:
-
The broker configuration files must be in a release-neutral location and accessible throughout the upgrade process.
-
After upgrading the leading group members, ensure broker communication between the leading group and the trailing group is successful before proceeding with the upgrade process.
Communication may be disrupted if network files are either not moved to the upgraded
ORACLE_HOME
or need to be edited appropriately. In such cases, shut down the upgraded databases (transient logical standby and any other Leading Group Standby databases), stop the listener, copy thelistener.ora
andtnsnames.ora
or fix them as appropriate, restart the listener, and restart the databases. -
Before you run the
DBMS_ROLLING
procedure, the physical standby databases must have been operating in Active Data Guard mode.If the physical standby databases were operating only in the mounted mode, and the primary database is a multitenant database, you must open the primary database including all its PDBs, and the temp file configuration must be confirmed before you run procedures in the
DBMS_ROLLING
package. This ensures that the necessary temp files are created and available during the upgrade process.