配置

创建用户（源 & 目标）

• 描述

  • 该用户必须加入到 oinstall 组
  • 该用户使用与 oracle 相同的 profile 文件
  • 操作系统必须为该用户开放一定的 CPU、内存等资源限制，可以通过 ulimit –a 查看，建议在 /etc/security/limits.conf 中设置和 oracle 用户一致

• 操作

  • 创建 GoldenGate 操作系统用户（此步骤非必须，也可以使用 ORACLE 用户安装）

    useradd -u 1001 -g oinstall -G dba ogg
    passwd ogg
    

  • 修改 GoldenGate 系统用户环境变量

    source /home/oracle/.bash_profile
    

  • 初始化参数

    vi .bash_profile
    

    export OGG_HOME=/u01/ogg
    export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$OGG_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    

安装目录（源 & 目标）

• 描述

  • 分配空间
    • 软件本身所需空间约为 200M 以下（OGG 21c 需要约 1G 空间）
    • 为缓存数据建议保留相当于 1-3 天归档日志的存储空间 （ trial 文件）
  • 将安装目录的 owner 修改为 OGG 运行用户

• 操作

  • 创建 GoldenGate 安装目录

    mkdir -p /u01/ogg
    chown -R ogg:oinstall /u01/ogg
    

图形化安装

1. Step 1：Select Installation Option
   运行 runInstaller，出现以下界面
   

2. Step 2：Specify Installation Details

   单击 Next，出现以下界面，配置安装路径和 manager 端口
   

   • 路径：与环境变量配置一致
   • 端口：根据需求进行配置，此处默认

3. Step 3：Summary
   单击：Next，确认安装信息
   

4. Step 4：Install Product
   单击：Install，开始安装 OGG
   

5. Step 5：Finish
   完成安装
   

静默安装

1. 编辑 rsp 文件

   vi oggcore.rsp
   

   oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v21_1_0
   INSTALL_OPTION=ORA21c
   SOFTWARE_LOCATION=/opt/ogg
   START_MANAGER=true
   MANAGER_PORT=7809
   DATABASE_LOCATION=/opt/ogg/instantclient
   INVENTORY_LOCATION=/opt/oraInventory
   

2. 运行命令，进行静默安装

   [ogg@ogg_node2 Disk1]$ ./runInstaller -silent -responseFile /opt/fbo_ggs_Linux_x64_Oracle_shiphome/Disk1/oggcore.rsp
   Starting Oracle Universal Installer...
   
   Checking Temp space: must be greater than 120 MB.   Actual 31941 MB    Passed
   Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
   Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-05-28_02-08-56PM. Please wait ...[ogg@ogg_node2 Disk1]$ You can find the log of this install session at:
    /opt/oraInventory/logs/installActions2024-05-28_02-08-56PM.log
   The installation of Oracle GoldenGate Core was successful.
   Please check '/opt/oraInventory/logs/silentInstall2024-05-28_02-08-56PM.log' for more details.
   [FATAL] [INS-75021] The Oracle GoldenGate Manager process could not be started.
      ACTION: Check the log files for more details.
   Setup failed.
   [WARNING] [INS-32090] Software installation was unsuccessful.
      CAUSE: Refer the log files for details.
      ACTION: Refer to the logs or contact Oracle Support Services.
   
   [ogg@ogg_node2 Disk1]$ cat /opt/oraInventory/logs/silentInstall2024-05-28_02-08-56PM.log
   The installation of Oracle GoldenGate Core was successful.
   
   

3. 创建需要目录

   [ogg@ogg_node2 Disk1]$ cd /opt/ogg
   [ogg@ogg_node2 ogg]$ ggsci
   
   Oracle GoldenGate Command Interpreter for Oracle
   Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO
   Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23
   Operating system character set identified as UTF-8.
   
   Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.
   
   
   
   GGSCI (ogg_node2) 1> create subdirs
   
   Creating subdirectories under current directory /opt/ogg
   
   Parameter file                 /opt/ogg/dirprm: already exists.
   Report file                    /opt/ogg/dirrpt: already exists.
   Checkpoint file                /opt/ogg/dirchk: already exists.
   Process status files           /opt/ogg/dirpcs: already exists.
   SQL script files               /opt/ogg/dirsql: already exists.
   Database definitions files     /opt/ogg/dirdef: already exists.
   Extract data files             /opt/ogg/dirdat: already exists.
   Temporary files                /opt/ogg/dirtmp: already exists.
   Credential store files         /opt/ogg/dircrd: already exists.
   Master encryption key wallet files /opt/ogg/dirwlt: already exists.
   Dump files                     /opt/ogg/dirdmp: already exists.
   

4. 编辑 MGR 配置文件

   EDIT PARAMS MGR
   

   port 7809
   

5. 开启 manager

   GGSCI (ogg_node2) 3> start mgr
   Manager started.
   
   

验证

[ogg@ogg_node1 ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO
Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.



GGSCI (ogg_node1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           


GGSCI (ogg_node1) 2>