Goldengate 12c生产环境抽取进程遇到一个故障，上mos查了下报错，发现是ogg的一个bug，需要打psu补丁解决。ogg打补丁的步骤如下:
1.验证opatch是否正常显示相关信息
1.1切换到设置ogg的ORACLE_HOME
export ORACLE_HOME=/opt/app/OGG_12
1.2执行 optch lsinventory
/opt/app/OGG_12/OPatch/optch lsinventory oracle@bd-dev-oracle-104:/opt/app/oraInventory/ContentsXML$/opt/app/OGG_12/OPatch/opatch lsinventory Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /opt/app/OGG_12 Central Inventory : /opt/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_13-52-07PM.log Lsinventory Output file location : /opt/app/OGG_12/cfgtoollogs/opatch/lsinv/lsinventory2018-12-18_13-52-07PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle GoldenGate Core 12.2.0.0.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
2.开始打PSU补丁
2.1 上传补丁包到/opt/app,并解压
unzip p24449451_12201160823_Linux-x86-64.zip
2.2 停止ogg所有进程，停止mgr,并查看所有进程状态是否为stop
GGSCI (bd-dev-oracle-104) 1>STOP FH_E01 GGSCI (bd-dev-oracle-104) 2>STOP MGR GGSCI (bd-dev-oracle-104) 3>INFO ALL
2.3 进入解压目录,执行打补丁命令
oracle@bd-dev-oracle-104:/opt/app$cd 24449451/ oracle@bd-dev-oracle-104:/opt/app/24449451$/opt/app/OGG_12/OPatch/opatch apply Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /opt/app/OGG_12 Central Inventory : /opt/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_16-07-26PM.log Applying interim patch '24449451' to OH '/opt/app/OGG_12' Verifying environment and performing prerequisite checks... Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/opt/app/OGG_12') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Patching component oracle.oggcore.ora11g, 12.2.0.0.0... Patch 24449451 successfully applied Log file location: /opt/app/OGG_12/cfgtoollogs/opatch/opatch2018-12-18_16-07-26PM.log OPatch succeeded.
2.4 切换ORACLE_HOME环境变量指向ORACLE DATABASE
oracle@bd-dev-oracle-104:/opt/app/24449451$cd oracle@bd-dev-oracle-104:~$source .bash_profile
2.5 启动Ogg mgr和相关进程
oracle@bd-dev-oracle-104:~$cd /opt/app/OGG_12/ oracle@bd-dev-oracle-104:/opt/app/OGG_12$./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.2.0.1.160823 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160805.1058_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 5 2016 22:07:01 Operating system character set identified as UTF-8. Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved. GGSCI (bd-dev-oracle-104) 1> info all GGSCI (bd-dev-oracle-104) 2> start mgr Manager started. GGSCI (bd-dev-oracle-104) 5> start FH_E01 Sending START request to MANAGER ... EXTRACT FH_E01 starting GGSCI (bd-dev-oracle-104) 6> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STARTING FH_E01 00:00:05 00:02:40
3.回退步骤
3.1.停止ogg mgr和相关进程
GGSCI (bd-dev-oracle-104) 1>STOP FH_E01 GGSCI (bd-dev-oracle-104) 2>STOP MGR GGSCI (bd-dev-oracle-104) 3>INFO ALL
3.2 切换ORACLE_HOME环境变量指向OGG
export ORACLE_HOME=/opt/app/OGG_12
3.3 进入解压目录执行
oracle@bd-dev-oracle-104:/opt/app/24449451$/opt/app/OGG_12/OPatch/opatch rollback -id 24449451
3.4 切换ORACLE_HOME环境变量指向ORACLE DATABASE
oracle@bd-dev-oracle-104:~$cd /opt/app/OGG_12/ oracle@bd-dev-oracle-104:/opt/app/OGG_12$./ggsci
3.5 启动Ogg mgr和相关进程
GGSCI (bd-dev-oracle-104) 1>START MGR Manager started. GGSCI (bd-dev-oracle-104) 2>START FH_E01 Sending START request to MANAGER ... EXTRACT FH_E01 starting GGSCI (bd-dev-oracle-104) 3>INFO ALL Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STARTING FH_E01 00:00:05 00:02:40
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69982136/viewspace-2716146/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 解决oem13c windows server下agent无法upload问题
- oracle查询blocking session阻塞情况
- Centos7下Clickhouse安装+Cluster配置
- 使用Data Guard Menu工具管理监控dataguard
- Oracle EMCC 12c emcli命令行工具安装以及使用介绍
- GoldenGate Enterprise Manager Plug-In(12.1.0.3.0) 部署文档
- GoldenGate 12c 在原有同步进程中新增同步表的操作步骤
- centos7下安装oracle rac使用udev绑定磁盘方法
- Oracle 11g 一主多备切换方案
