The Ogg version is also upgraded after the DB version upgrade.
First of all, the DB version upgrade here is 10.2.0.5 upgrade to 11.2.0.3, so it belongs to the change of major version.
What's the name major version?
MOS article Oracle Database END of Premier support for Major releases-frequently asked Questions (Doc ID 1559513.1)
As the following discussion:
2. What is a major release? For the Oracle Database, a major release has a distinct first and a places in its version number. For example 11.1, 11.2, and 12.1 is major releases.
The topic back to the DB version of the upgrade after the Ogg version of the situation.
Due to the upgrade of major version, the Ogg version also needs to be upgraded because the Ogg release is matched to major version of Oracle database software.
Then someone may have a question: for the new version of Ogg under DB 11.2.0.3, all DDL replication scripts need to run again? For example, the following sequence:
9. execute sqlsql> @marker_setup. SQL -------> This step does not need to be performed during the upgrade. implement sqlsql> @ddl_setup. SQL --------Run this script when upgrading >ogg. One. perform sqlsql> @role_setup. SQL --------Run this script when upgrading >ogg. 12. Authorizing sql> Grant Ggs_ggsuser_role to Goldengate; This command is executed-------->ogg upgrade. Implementation of sqlsql> @ddl_enable. SQL --------Execute this command when >ogg upgrade.
In fact, you don't need to run all over again. Which needs to be re-run, follow the MoS article how to Upgrade Goldengate from 11.2.1.x to 11.2.1.y for Oracle Database Doc ID 1601971.1.
In this article, the following steps are as follows:
8. If using DDL replication steps 9 to + needs to be followed. If using only DML replication then skip steps 9 to 14
9. Stop doing DDL changes on the source DB and run the Ddl_disable script as sysdba to disable the OGG DDL trigger
Disconnect all sessions that ever issued DDL. Otherwise the database might generate ora* errors
One. Run the Ddl_setup script as SYSDBA. You'll be prompted for the name of the Oracle GoldenGate
DDL schema.
Run the role_setupscript to recreate the Oracle GoldenGate DDL role.
Grant the role that you created to all Oracle GoldenGate users under which the
Following Oracle GoldenGate processes run:extract, Replicat, Ggsci, and Manager.
You might need to make multiple grants ifthe processes has different user names.
Run the Ddl_enable.sqlscript to enable the DDL trigger.
Follow the execution!
Issues with scripting when configuring DDL replication when the Ogg version is also upgraded after the DB version upgrade
