Notes for Oracle GoldenGate upgrade

Notes for Oracle GoldenGate upgrade

Oracle GoldenGate is being upgraded recently. refer to the following documents:
How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Database (Document ID 1601971.1)

This document makes it clear:
2. Stop the OGG processes on the existing OGG v11.2.1.x home including the manager

That is to say, stop all processes under the ogghome: extract (including extraction and transmission), replicat (replication), server (the process of writing the trail file to the target end), mgr Process
The server process may be easily ignored. Because other three types of processes (extract, replicat, and mgr) can use the command to stop.

In this case, the OGG target terminal is upgraded. In this case, the server process is scheduled, causing tar-xvf ggs_AIX_ppc_ora11g_64bit.tar to report an error:

Oracle @ hosta:/home/oracle/ggs $ tar-xvf ggs_AIX_ppc_ora11g_64bit.tar
X.
X./mgr, 5176606 bytes, 10111 media blocks.
X./ggsci, 6273278 bytes, 12253 media blocks.
X./ggcmd, 3087685 bytes, 6031 media blocks.
X./ggMessage. dat, 1334816 bytes, 2608 media blocks.
X./help.txt, 178647 bytes, 349 media blocks.
X./tcperrs, 759 bytes, 2 media blocks.
X./bcrypt.txt, 1725 bytes, 4 media blocks.
X./libxml2.txt, 1668 bytes, 4 media blocks.
X./zlib.txt, 1476 bytes, 3 media blocks.
X./freeBSD.txt, 1968 bytes, 4 media blocks.
X./notices.txt, 213535 bytes, 418 media blocks.
Tar: 0511-188 Cannot create./libxerces-c.a: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libicui18n38. a: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libicuuc38.a: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libicudata38.a: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libantl3c. so: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libggrepo. a: Cannot open or remove a file containing a running program.
Tar: 0511-188 Cannot create./libgglog. a: Cannot open or remove a file containing a running program.
X./dirjar

Omitted

Tar: 0511-188 Cannot create./libdb-5.2.so: Cannot open or remove a file containing a running program.
Omitted
Tar: 0511-188 Cannot create./server: Cannot open or remove a file containing a running program.
Omitted

Tar-xvf ggs_AIX_ppc_ora11g_64bit.tar: an error is returned, but the execution can be completed. However, some program files (binary files) in the new version of OGG cannot be overwritten, resulting in the failure to log on to the new version of OGG:

Oracle @ hosta:/home/oracle/ggs $
Oracle @ hosta:/home/oracle/ggs $
Oracle @ hosta:/home/oracle/ggs $
Oracle @ hosta:/home/oracle/ggs $ ggsci
Exec (): 0509-036 Cannot load program ggsci because of the following errors:
Rtld: 0712-001 Symbol _ MSG_ERR_COLUMN_BUFFER_OVERFLOW _ FP14CSourceContextiT2Q2_15CMessageFactory18MessageDisposition was referenced
From module ggsci (), but a runtime definition
Of the symbol was not found.
Rtld: 0712-002 fatal error: exiting.
Oracle @ hosta:/home/oracle/ggs $

Based on this problem, I have improved How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Database. The Complete Upgrade steps are as follows:

1. Download the latest OGG v11.2.1.y version provided by OGG Support team.

2. Stop the OGG processes on the existing OGG v11.2.1.x home including the manager, and exit all GGSCI sessions,
Run the ps-ef | grep ggs command to confirm that no process is running under $ OGG_HOME. (Note: The reason why I grep ggs is because my $ OGG_HOME path contains ggs) ---> This Is What I added
3. Take a backup of the existing OGG home
4. Unzip and untar the new build on top of the existing OGG home. This will overwrite the binaries,
Confirm the following questions:
4.1 The output log of tar-xvf does not contain any "Cannot open or remove a file containing a running program." ---> This Is What I added.
4.2 enter the ggsci command prompt, confirm that ggsci can be properly entered, and confirm that $ OGG_HOME has been upgraded to the new ogg version. ---> This Is What I added

Step 5-7 is omitted. Please refer to this mos article
Follow these steps to copy this mos article. I have not made any changes to the following steps.
8. If using DDL replication steps 9 to 14 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

10. Disconnect all sessions that ever issued DDL. Otherwise the database might generate ORA * errors

11. Run the ddl_setup script as sysdba. You will be prompted for the name of the Oracle GoldenGate
DDL schema.

12. Run the role_setupscript to recreate the Oracle GoldenGate DDL role.

13. Grant the role that you created to all Oracle GoldenGate users under which
Following Oracle GoldenGate processes run: Extract, Replicat, GGSCI, and Manager.
You might need to make multiple grants ifthe processes have different user names.

14. Run the ddl_enable.sqlscript to enable the DDL trigger.

15. Start the OGG process back

16. Resume doing DDL changes to the db.

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

Build a GoldenGate bidirectional replication environment from Oracle to Oracle

This article permanently updates the link address: