说明:本文为Oracle Goldengate 打补丁操作指导手册
标签:OGG打补丁
温馨提示:如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化
实验环境:
系统:Centos 6.3
数据库版本:11.2.0.4
OGG版本:12.3.0.1.4
补丁版本:30703128
OPATCH版本:p6880880_122010_Linux-x86-64.zip
※ ogg-opatch版本需要与ogg版本对应,而不是依赖于服务的数据库
※ ogg-opatch与DB-opatch通用
目录说明:
/bd 补丁/OPatch临时存放目录
/ogg123 OGG安装目录
/u01 Oracle数据库安装目录
环境变量:
※ 注意:ORACLE_HOME必须设置为DB的,而不是OGG的,打补丁时需要特别指定OGG-HOME参数OH
※ 注意:OGG的运行需要DB中的lib库文件:/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.so
cat /home/oggos/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=rac2
export GG_HOME=/ogg123/
export PATH=$ORACLE_HOME/bin:$HOME/bin:$ORACLE_HOME/jdk/bin:$GG_HOME:$PATH:$GG_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GG_HOME:$GG_HOME/lib:$GG_HOME/OPatch
export PATH
alias ogg='rlwrap /ogg123/ggsci'
相关命令:
/ogg123/OPatch/opatch apply /bd/30703128 -jre /ogg123/jdk/ -oh /ogg123 应用补丁包
/ogg123/OPatch/opatch rollback -id 30703128 -jre /ogg123/jdk/ -oh /ogg123 回滚补丁包
/ogg123/OPatch/opatch lspatches -jre /ogg123/jdk/ -oh /ogg123 查看补丁Patch包概况
/ogg123/OPatch/opatch lsinventory -jre /ogg123/jdk/ -oh /ogg123 查看补丁Patch包详情
说明:
-jre 是打补丁时opatch运行所需要的Java环境,指向OGG安装目录下的jdk即可
-oh 是打补丁时opatch运行所在的OGG_HOME路径
打补丁详情:
//
[oggos@rac1 bd]$ cd /ogg123
[oggos@rac1 ogg123]$ mv OPatch/ OPatch_back
[oggos@rac1 ogg123]$ cp -r /bd/OPatch/ /ogg123
[oggos@rac1 ogg123]$ cd /bd/30703128/
[oggos@rac1 30703128]$ /ogg123/OPatch/opatch apply /bd/30703128 -jre /ogg123/jdk/ -oh /ogg123
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /ogg123
Central Inventory : /u01/app/oraInventory
from : /ogg123/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : /ogg123/cfgtoollogs/opatch/opatch2020-04-05_21-58-04PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 30703128
Do you want to proceed? [y|n] 【询问你是否开始,选择Y代表同意】
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ogg123')
Is the local system ready for patching? [y|n] 【询问你是否准备好打补丁,选择Y代表同意】
y
User Responded with: Y
Backing up files...
Applying interim patch '30703128' to OH '/ogg123'
Patching component oracle.oggcore.ora11g, 12.3.0.1.2...
Patch 30703128 successfully applied.
Sub-set patch [28511684] has become inactive due to the application of a super-set patch [30703128].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /ogg123/cfgtoollogs/opatch/opatch2020-04-05_21-58-04PM_1.log
OPatch succeeded.
回滚详情:
//
[oggos@rac1 30703128]$ /ogg123/OPatch/opatch rollback -id 30703128 -jre /ogg123/jdk/ -oh /ogg123
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /ogg123
Central Inventory : /u01/app/oraInventory
from : /ogg123/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : /ogg123/cfgtoollogs/opatch/opatch2020-04-05_22-01-35PM_1.log
Patches will be rolled back in the following order:
30703128
The following patch(es) will be rolled back: 30703128
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ogg123')
Is the local system ready for patching? [y|n] 【询问你是否准备好回滚补丁,选择Y代表同意】
y
User Responded with: Y
Rolling back patch 30703128...
RollbackSession rolling back interim patch '30703128' from OH '/ogg123'
Patching component oracle.oggcore.ora11g, 12.3.0.1.2...
RollbackSession removing interim patch '30703128' from inventory
Inactive sub-set patch [28511684] has become active due to the rolling back of a super-set patch [30703128].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /ogg123/cfgtoollogs/opatch/opatch2020-04-05_22-01-35PM_1.log
OPatch succeeded.
查看补丁Patch包概况:
//
[oggos@rac1 ogg123]$ /ogg123/OPatch/opatch lspatches -jre /ogg123/jdk/ -oh /ogg123
30703128;
OPatch succeeded.
查看补丁Patch包详情:
//
[oggos@rac1 30703128]$ /ogg123/OPatch/opatch lsinventory -jre /ogg123/jdk/ -oh /ogg123
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /ogg123
Central Inventory : /u01/app/oraInventory
from : /ogg123/oraInst.loc
OPatch version : 12.2.0.1.19
OUI version : 12.2.0.1.4
Log file location : /ogg123/cfgtoollogs/opatch/opatch2020-04-05_22-03-58PM_1.log
Lsinventory Output file location : /ogg123/cfgtoollogs/opatch/lsinv/lsinventory2020-04-05_22-03-58PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 12.3.0.1.2
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 30703128 : applied on Sun Apr 05 22:02:27 CST 2020
Unique Patch ID: 23313503
Created on 27 Dec 2019, 10:15:27 hrs PST8PDT
Bugs fixed:
27078084, 28043789, 28962077, 28011195
--------------------------------------------------------------------------------
OPatch succeeded.
※ 如果您觉得文章写的还不错, 别忘了在文末给作者点个赞哦 ~
over