最近在进行Oracle GoldenGate的版本升级，参考的文档为：How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Data
最近在进行oracle goldengate的版本升级，参考的文档为：
how to upgrade goldengate from 11.2.1.x to 11.2.1.y for oracle database (文档 id 1601971.1)
该文档中说的很清楚：
2. stop the ogg processes on the existing ogg v11.2.1.x home including the manager
也就是说：停止ogghome下的所有进程：extract（包括抽取和传输），replicat（复制），server（在目的端的写入trail file的进程），mgr进程
其中，server进程可能容易被忽略掉。因为其他三类的进程（extract和replicat和mgr）都能用命令stop掉。
在本案例中，进行的是ogg目的端的升级，恰恰此时server进程被调度起来，导致tar -xvf ggs_aix_ppc_ora11g_64bit.tar 报错：
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 ./libantlr3c.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
省略部分
tar: 0511-188 Cannot create ./libdb-5.2.so: Cannot open or remove a file containing a running program.
省略部分
tar: 0511-188 Cannot create ./server: Cannot open or remove a file containing a running program.
省略部分
tar -xvf ggs_AIX_ppc_ora11g_64bit.tar 报错归报错，但是能执行完成，只是OGG的新版本的个别程序文件（binary）无法覆盖，进而导致新版本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$
基于此种问题，我对How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Database进行了完善，完善后的升级步骤如下：
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，
并使用ps -ef | grep ggs 命令确认$OGG_HOME下没有任何进程在运行。(注意:我之所以grep ggs是因为我的$OGG_HOME的路径中包括ggs)--->这是我加的
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，
确认如下问题：
4.1 在tar -xvf的输出日志中，不包括任何的“Cannot open or remove a file containing a running program.” --->这是我加的
4.2 进入ggsci命令提示符，确认ggsci能正常进入，并确认$OGG_HOME已经升级到新的ogg版本。 --->这是我加的
5-7步省略，请参考该mos文章
以下步骤照抄该mos文章，，对以下步骤，我并没有任何的修改。
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.
dmSOBC SHOP网店系统由北京时代胜腾信息技术有限公司（http://www.webzhan.com）历时6个月开发完成，本着简单实用的理念，商城在功能上摒弃了外在装饰的一些辅助功能，尽可能的精简各项模块开发，做到有用的才开发，网店V1.0.0版本开发完成后得到了很多用户的使用并获得了好评，公司立即对网店进行升级，其中包括修正客户提出的一些意见和建议，现对广大用户提供免费试用版本，如您在使用
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 the
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单向表DML同步
Oracle GoldenGate 系列：Extract 进程的恢复原理
Oracle GoldenGate安装配置
Oracle goldengate的OGG-01004 OGG-1296错误
Oracle GoldenGate快速入门教程：基本概念和配置
搭建一个Oracle到Oracle的GoldenGate双向复制环境
本文永久更新链接地址：
