IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    GoldenGate 19安装和打patch

    惜分飞发表于 2024-12-02 15:17:33
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:GoldenGate 19安装和打patch

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    1. 下载V983658-01.zip,并上传到/tmp中
    2. 安装19.1.0.0.4版本ogg,需要修改静默文件/tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp中修改这两个参数

    INSTALL_OPTION=ORA19c
    SOFTWARE_LOCATION=/tmp/ogg
    

    3. 静默安装ogg

    [oracle@ora19c:/home/oracle]$ /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller -silent \
     -responseFile /tmp/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
    Starting Oracle Universal Installer...
    
    Checking Temp space: must be greater than 120 MB.   Actual 6106 MB    Passed
    Checking swap space: must be greater than 150 MB.   Actual 1257 MB    Passed
    Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-12-02_10-57-00PM. Please wait ...
    [oracle@ora19c:/home/oracle]$ You can find the log of this install session at:
     /data/app/oraInventory/logs/installActions2024-12-02_10-57-00PM.log
    Successfully Setup Software.
    The installation of Oracle GoldenGate Core was successful.
    Please check '/data/app/oraInventory/logs/silentInstall2024-12-02_10-57-00PM.log' for more details.
    
    [oracle@ora19c:/home/oracle]$ cd /tmp/ogg
    [oracle@ora19c:/tmp/ogg]$ ./ggsci
    
    Oracle GoldenGate Command Interpreter for Oracle
    Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
    Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29
    Operating system character set identified as UTF-8.
    
    Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
    
    
    
    GGSCI (ora19c) 1> info all
    
    Program     Status      Group       Lag at Chkpt  Time Since Chkpt
    
    MANAGER     STOPPED                                           
    
    
    GGSCI (ora19c) 2> create subdirs
    
    Creating subdirectories under current directory /tmp/ogg
    
    Parameter file                 /tmp/ogg/dirprm: created.
    Report file                    /tmp/ogg/dirrpt: created.
    Checkpoint file                /tmp/ogg/dirchk: created.
    Process status files           /tmp/ogg/dirpcs: created.
    SQL script files               /tmp/ogg/dirsql: created.
    Database definitions files     /tmp/ogg/dirdef: created.
    Extract data files             /tmp/ogg/dirdat: created.
    Temporary files                /tmp/ogg/dirtmp: created.
    Credential store files         /tmp/ogg/dircrd: created.
    Masterkey wallet files         /tmp/ogg/dirwlt: created.
    Dump files                     /tmp/ogg/dirdmp: created.
    
    
    GGSCI (ora19c) 3> exit
    

    4. 下载patch p37236684_1925000OGGRU_Linux-x86-64.zip 和opatch p6880880_190000_Linux-x86-64.zip(12.2.0.1.44版本) 并解压

    [oracle@ora19c:/tmp]$ cd /tmp/
    [oracle@ora19c:/tmp]$ unzip p37236684_1925000OGGRU_Linux-x86-64.zip 
    [oracle@ora19c:/tmp]$ cd /tmp/ogg
    [oracle@ora19c:/tmp/ogg]$ mv OPatch/ OPatch_bak
    [oracle@ora19c:/tmp/ogg]$ unzip /tmp/p6880880_190000_Linux-x86-64.zip 
    [oracle@ora19c:/tmp/ogg]$ /tmp/ogg/OPatch/opatch version
    OPatch Version: 12.2.0.1.44
    
    OPatch succeeded.
    

    5. 对19.1.0.0.4版本ogg 打上最新patch(37236684)

    [oracle@ora19c:/tmp/ogg]$ export ORACLE_HOME=/tmp/ogg
    [oracle@ora19c:/tmp/ogg]$ OPatch/opatch apply /tmp/37236684/
    Oracle Interim Patch Installer version 12.2.0.1.44
    Copyright (c) 2024, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : /tmp/ogg
    Central Inventory : /data/app/oraInventory
       from           : /tmp/ogg/oraInst.loc
    OPatch version    : 12.2.0.1.44
    OUI version       : 12.2.0.4.0
    Log file location : /tmp/ogg/cfgtoollogs/opatch/opatch2024-12-02_23-04-26PM_1.log
    
    Verifying environment and performing prerequisite checks...
    OPatch continues with these patches:   37236684  
    
    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 = '/tmp/ogg')
    
    
    Is the local system ready for patching? [y|n]
    y
    User Responded with: Y
    Backing up files...
    Applying interim patch '37236684' to OH '/tmp/ogg'
    
    Patching component oracle.oggcore.ora19c, 19.1.0.0.0...
    Patch 37236684 successfully applied.
    Log file location: /tmp/ogg/cfgtoollogs/opatch/opatch2024-12-02_23-04-26PM_1.log
    
    OPatch succeeded.
    [oracle@ora19c:/tmp/ogg]$ OPatch/opatch lspatches
    37236684;
    
    OPatch succeeded.
    [oracle@ora19c:/tmp/ogg]$ ./ggsci
    
    Oracle GoldenGate Command Interpreter for Oracle
    Version 19.25.0.0.241105 OGGCORE_19.25.0.0.0OGGRU_PLATFORMS_241118.0932_FBO
    Linux, x64, 64bit (optimized), Oracle 19c  on Nov 18 2024 13:19:46
    Operating system character set identified as UTF-8.
    
    Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved.
    
    
    
    GGSCI (ora19c) 1> 
    
    • Oracle 小升级 opatch apply使用
    • fuser命令缺失导致19c打补丁失败
    • Kylin Linux 安装19c
    • 打patch出现Copy failed—tfa服务导致部分lib未释放
    • 记录在linux 7中安装11.2.0.4 RAC遇到问题
    • 11gR2 GI打PSU ORACLE_HOME空间不足案例—需要20G以上空闲空间
    • 重建oraInventory解决ORA-20001
    • opatch auto 出现unable to get oracle owner for 错误
    • ogg同步部分列配置
    • 10.2.0.x升级到10.2.0.5.5
    • ogg中Time Since Chkpt显示unknown解决
    • 通过with实现对表非法dml操作—解决方案_with_subquery=materialize或者psu(2014.07以后)


沪ICP备19023445号-2号
友情链接