1. 目的說(shuō)明
本文檔提供Oracle GoldenGate安裝配置指導(dǎo)唇辨,適用于入門練習(xí)使用沃暗,生產(chǎn)環(huán)境配置绽诚,在關(guān)鍵步驟和重要參數(shù)設(shè)置需要特別對(duì)待。
2. 參考文檔
《叱咤風(fēng)云GoldenGate企業(yè)級(jí)運(yùn)維實(shí)戰(zhàn)》
《Expert Oracle GoldenGate》
Oracle GoldenGate Document
3. 介質(zhì)準(zhǔn)備
操作系統(tǒng)介質(zhì):
#LINUX
https://wiki.centos.org/Download
數(shù)據(jù)庫(kù)介質(zhì):
#ORACLE DB
http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html
GoldenGate:
#GoldenGate介質(zhì)
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
根據(jù)需要練習(xí)的環(huán)境下載對(duì)應(yīng)的GoldenGate介質(zhì)颤专,注意下載安裝的版本,一般選擇更高版本的會(huì)更好一些焦匈。
4. GoldenGate安裝
GoldenGate對(duì)應(yīng)不同的數(shù)據(jù)庫(kù)的安裝方式不同血公,GoldenGate for Oracle通過(guò)OUI來(lái)進(jìn)行安裝,其他的則一般只需要解壓至指定的位置配置環(huán)境變量就可以使用缓熟。
4.1 GoldenGate for Oracle 安裝
GoldenGate的安裝主要是通過(guò)OUI的GUI或者silent安裝累魔,實(shí)踐下來(lái),silent安裝比GUI安裝更為方便一些够滑。
4.1.1 OUI圖形安裝
上傳解壓介質(zhì):
unzip fbo_ggs_Linux_x64_shiphome.zip -d /u01/install/ogg/
進(jìn)入目錄
cd /u01/install/ogg/fbo_ggs_Linux_x64_shiphome/Disk1
創(chuàng)建GoldenGate目錄:
mkdir -p /u01/ogg/12.2.0/oggcore_1
#root 授權(quán)
chown oracle.oinstall -R /u01/ogg/
啟動(dòng)OUI安裝程序:
./runInstaller
根據(jù)實(shí)際安裝的數(shù)據(jù)庫(kù)類型選擇相應(yīng)的選項(xiàng)垦写。
輸入前面創(chuàng)建好的GoldenGate目錄,不選擇啟動(dòng)manager彰触。
選擇install進(jìn)行安裝梯投。
安裝進(jìn)行中
安裝完成。
4.1.2 OUI靜默安裝
OUI靜默安裝是通過(guò)配置響應(yīng)文件進(jìn)行安裝况毅。
響應(yīng)文件在解壓后的目錄里面:
[oracle@dbserver Disk1]$ ls
install response runInstaller stage
編輯響應(yīng)文件:
vi ./response/oggcore.rsp
#修改以下參數(shù)指定項(xiàng)
####################################################################
## 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
啟動(dòng)OUI程序指定響應(yīng)文件進(jìn)行安裝:
./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.
如果機(jī)器的性能差會(huì)反應(yīng)會(huì)慢一些分蓖,可以再開一個(gè)新的terminal,一邊安裝一邊使用tail命令查看安裝日志:
tail -f /u01/app/oraInventory/logs/installActions2016-08-11_02-00-27AM.log
4.1.3 配置環(huán)境變量
vi ~/.bash_profile
#添加GGATE變量
export $GGATE=/u01/ogg/12.2.0/oggcore_1