1. 目的说明
本文档提供Oracle GoldenGate安装配置指导,适用于入门练习使用,生产环境配置,在关键步骤和重要参数设置需要特别对待。
2. 参考文档
《叱咤风云GoldenGate企业级运维实战》
《Expert Oracle GoldenGate》
Oracle GoldenGate Document
3. 介质准备
操作系统介质:
#LINUX
https://wiki.centos.org/Download
数据库介质:
#ORACLE DB
http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html
GoldenGate:
#GoldenGate介质
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
根据需要练习的环境下载对应的GoldenGate介质,注意下载安装的版本,一般选择更高版本的会更好一些。
4. GoldenGate安装
GoldenGate对应不同的数据库的安装方式不同,GoldenGate for Oracle通过OUI来进行安装,其他的则一般只需要解压至指定的位置配置环境变量就可以使用。
4.1 GoldenGate for Oracle 安装
GoldenGate的安装主要是通过OUI的GUI或者silent安装,实践下来,silent安装比GUI安装更为方便一些。
4.1.1 OUI图形安装
上传解压介质:
unzip fbo_ggs_Linux_x64_shiphome.zip -d /u01/install/ogg/
进入目录
cd /u01/install/ogg/fbo_ggs_Linux_x64_shiphome/Disk1
创建GoldenGate目录:
mkdir -p /u01/ogg/12.2.0/oggcore_1
#root 授权
chown oracle.oinstall -R /u01/ogg/
启动OUI安装程序:
./runInstaller
根据实际安装的数据库类型选择相应的选项。
输入前面创建好的GoldenGate目录,不选择启动manager。
选择install进行安装。
安装进行中
安装完成。
4.1.2 OUI静默安装
OUI静默安装是通过配置响应文件进行安装。
响应文件在解压后的目录里面:
[oracle@dbserver Disk1]$ ls
install response runInstaller stage
编辑响应文件:
vi ./response/oggcore.rsp
#修改以下参数指定项
####################################################################
## Copyright(c) Oracle Corporation 2014. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file should be secured to have read ##
## permission only by the oracle user or an administrator who ##
## own this installation to protect any sensitive input values. ##
## ##
####################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2
################################################################################
## ##
## Oracle GoldenGate installation option and details ##
## ##
################################################################################
#-------------------------------------------------------------------------------
# Specify the installation option.
# Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and
# ORA11g for installing Oracle GoldenGate for Oracle Database 11g
#-------------------------------------------------------------------------------
INSTALL_OPTION=ORA11g
#-------------------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#-------------------------------------------------------------------------------
SOFTWARE_LOCATION=/u01/ogg/12.2.0/oggcore_1
#-------------------------------------------------------------------------------
# Specify true to start the manager after installation.
#-------------------------------------------------------------------------------
START_MANAGER=
#-------------------------------------------------------------------------------
# Specify a free port within the valid range for the manager process.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
MANAGER_PORT=
#-------------------------------------------------------------------------------
# Specify the location of the Oracle Database.
# Required only if START_MANAGER is true.
#-------------------------------------------------------------------------------
DATABASE_LOCATION=/u01/app/oracle/product/11.2.0/dbhome_1
################################################################################
## ##
## Specify details to Create inventory for Oracle installs ##
## Required only for the first Oracle product install on a system. ##
## ##
################################################################################
#-------------------------------------------------------------------------------
# Specify the location which holds the install inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory
#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.
# This parameter is not applicable if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
启动OUI程序指定响应文件进行安装:
./runInstaller -silent -responseFile /u01/install/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 7941 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1387 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-08-11_02-00-27AM. Please wait ...[oracle@dbserver Disk1]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2016-08-11_02-00-27AM.log
[oracle@dbserver Disk1]$
[oracle@dbserver Disk1]$ The installation of Oracle GoldenGate Core was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2016-08-11_02-00-27AM.log' for more details.
Successfully Setup Software.
如果机器的性能差会反应会慢一些,可以再开一个新的terminal,一边安装一边使用tail命令查看安装日志:
tail -f /u01/app/oraInventory/logs/installActions2016-08-11_02-00-27AM.log
4.1.3 配置环境变量
vi ~/.bash_profile
#添加GGATE变量
export $GGATE=/u01/ogg/12.2.0/oggcore_1