Oracle Goldengate 12c打pus补丁

最新推荐文章于 2024-09-12 08:16:49 发布

原创最新推荐文章于 2024-09-12 08:16:49 发布 · 371 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #ogg

GoldenGate 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了如何在Oracle GoldenGate 12c生产环境中打PSU补丁以解决抽取进程的故障。首先验证opatch工具的正常运行，然后上传并解压补丁包，接着停止单元，执行打补丁命令，最后启动GoldenGate进程。同时提供了回退步骤以应对可能出现的问题。

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