GoldenGate安裝以及補丁安裝

????本文描述OGG的基本安裝操作以及OGG補丁安裝。

1.?GoldenGate安裝

1.1.?GoldenGate版本下載

新版本通過ORACLE官方網站可以直接進行下載Oracle GoldenGate Downloads：

https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html。

?

但歷史版本需要通過Delivery網站進行下載：https://edelivery.oracle.com/。

?

1.2.?GoldenGate安裝

新版本的GoldenGate支持通過圖形界面進行初始化安裝。相比以前的操作會復雜一些，GoldenGate?11可以通過直接解壓的方式進行安裝。

1.2.1.?圖形界面安裝

解壓軟件包后，通過runInstaller命令啟動安裝圖形界面。

[oracle@oradb1 Disk1]$ ./runInstaller

?

以安裝OGG 12.3為例，12.3支持ORACLE 11G和 12C，因此安裝過程中會進行數據庫版本的選擇。

1.2.2.?解壓安裝

GoldenGate?11可以通過直接解壓的方式進行安裝。

[root@gxoradb1 oracle]# cd /oracle

[root@gxoradb1 oracle]# mkdir GoldenGate

[root@gxoradb1 oracle]# chown oracle:oinstall ./GoldenGate/

?

[root@gxoradb1 oracle]# su - oracle

[oracle@gxoradb1 ~]$ ls

Oracle_GoldenGate_Monitor_Linux_x64_11.1.1.1.0.zip ?ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip ?oradiag_oracle

?

[oracle@gxoradb1 ~]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip -d /oracle/GoldenGate/

Archive: ?ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

??inflating: /oracle/GoldenGate/fbo_ggs_Linux_x64_ora11g_64bit.tar ?

??inflating: /oracle/GoldenGate/OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf ?

??inflating: /oracle/GoldenGate/Oracle GoldenGate 11.2.1.0.1 README.txt ?

??inflating: /oracle/GoldenGate/Oracle GoldenGate 11.2.1.0.1 README.doc ?

?

[oracle@gxoradb1 ~]$ cd /oracle/GoldenGate/

[oracle@gxoradb1 GoldenGate]$ ls -lrt

total 223764

-rw-rw-r-- 1 oracle oinstall 228556800 Apr 23 ?2012 fbo_ggs_Linux_x64_ora11g_64bit.tar

-rwxrwxrwx 1 oracle oinstall ???220546 May ?2 ?2012 OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf

-rwxrwxrwx 1 oracle oinstall ????93696 May ?2 ?2012 Oracle GoldenGate 11.2.1.0.1 README.doc

-rwxrwxrwx 1 oracle oinstall ????24390 May ?2 ?2012 Oracle GoldenGate 11.2.1.0.1 README.txt

?

[oracle@gxoradb1 GoldenGate]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle@gxoradb1 GoldenGate]$ ll gg*

-rw-r----- 1 oracle oinstall ?1257280 Apr 23 ?2012 ggMessage.dat

-rwxr-x--- 1 oracle oinstall ?6393899 Apr 23 ?2012 ggcmd

-rwxr-x--- 1 oracle oinstall 13398159 Apr 23 ?2012 ggsci

?

1.3.?配置環境變量

GoldenGate在Linux和Unix下安裝后，需要ORACLE安裝環境下的庫文件才能啟動，因此必須$ORACLE_HOME/lib目錄配置到LD_LIBRARY_PATH環境變量中：

export ORACLE_SID=ora11g

export ORACLE_BASE=/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/database/12c

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH;

?

export GG_HOME=/oradata/ogg12c/ogg123

?

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

?

export PATH=$ORACLE_HOME/bin:$GG_HOME:$PATH:$HOME/bin

?

alias gg='cd $GG_HOME; ./ggsci'

?

1.4.?檢查GoldenGate環境

GoldenGate 啟動前，需要對ggsci應用的庫文件進行檢查，如果有無法找到的庫文件，會導致ggsci啟動失敗。

[oracle@oradb1 ~]$ cd /oradata/ogg12c/ogg123

[oracle@oradb1 ogg123]$ ldd ./ggsci | grep 'not found' -> 確保所有庫文件都可以找到

?

[oracle@oradb1 ogg123]$ ./ggsci

?

Oracle GoldenGate Command Interpreter for Oracle

Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO

Linux, x64, 64bit (optimized), Oracle 12c on Apr 16 2018 00:53:30

Operating system character set identified as UTF-8.

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

?

GGSCI (oradb1) 1>

?

1.5.?GoldenGate補丁安裝

1.5.1.?升級OPatch

OPatch是ORACLE用來進行補丁安裝的程序，補丁安裝前，建議閱讀補丁包中的說明文件，升級OPatch到官方指定的版本。

?

下面是MOS中OPatch的說明文檔，OPatch的下載和使用可以參考該文檔。

OPatch - Where Can I Find the Latest Version of OPatch(6880880)? [Video] (文檔 ID 224346.1)

?

OPatch的替換比較簡單，將p6880880_<版本>_<操作系統平臺>.zip壓縮包解壓后，使用操作系統命令進行軟件替換即可。非ORACLE用戶替換OPatch目錄后，需要進行權限修改。OPatch軟件的版本編號(6880880)是固定的，可以在MOS上直接進行該補丁的下載。

?

解壓最新的OPatch軟件：

[oracle@oradb1 ~]$ cd /oradata/ogg12c/software/

[oracle@oradb1 software]$ unzip p6880880_122010_Linux-x86-64.zip

?

備份舊的OPatch軟件：

[oracle@oradb1 ~]$ cd $OGG_HOME

[oracle@oradb1 ogg123]$ mv OPatch/ ./OPatch.20190425

?

替換新的OPatch軟件，并修改軟件權限：

[oracle@oradb1 ogg123]$ mv /oradata/ogg12c/software/OPatch/ ./

[oracle@oradb1 ogg123]$ chown -R oracle:oinstall ./OPatch

?

替換完成后，檢查新的OPatch軟件的版本。

[oracle@oradb1 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.17

?

1.5.2.?獲取補丁

通過MOS的補丁查找功能，可以獲取當前軟件的最新補丁信息。?

需要注意OGG補丁是針對不同數據庫的版本。下載時需要注意版本信息。

1.5.3.?安裝補丁29636573

補丁程序29636573: Patch for MLR 29600067: Linux x86-64: Oracle 12c: OGG 12.3.0.1.4

?

查看補丁安裝自述文件：

(1) Prerequisites

--------------------

Before you install or deinstall the patch, ensure that you meet the following requirements:

?

1. Ensure that the Oracle GoldenGate on which you are installing the patch or from which you are rolling back the patch is Oracle GoldenGate V12.3.0.1.4 for Oracle.

2. ?Oracle recommends you to use the latest version of OPatch.

3. Ensure that you set the ORACLE_HOME environment variable to the Oracle GoldenGate home.

4. Ensure that you set the PATH environment variable to include the location of the unzip executable, and the <ORACLE_HOME>/bin and the <ORACLE_HOME>/OPatch directories present in the Oracle GoldenGate home.

5. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. If the command displays some errors, then contact Oracle Support and resolve the issue.

????????$ opatch lsinventory

6. Ensure that you shut down all the services running from the Oracle GoldenGate home.

7. ?Install the latest opatch version (i.e.,12.2.0.1.13).

8. ?Change file permissions for $ORACLE_HOME/crypto and $ORACLE_HOME/directc to be writable (patch will fail to install if this is not done prior to applying the opatch). ?

?

(2) Installation

-----------------

To install the patch, follow these steps:

?

1. Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_DIR>.

2. Extract the contents of the patch ZIP file to the location you created in Step (1). To do so, run the following command:

$ <PATCH_TOP_DIR> p<Patch_number>_<version>_<Platform>.zip

3. Navigate to the <PATCH_TOP_DIR>/<Patch_number> directory:

$ cd <PATCH_TOP_DIR>/<Patch_number>

4. Install the patch by running the following command:

$ opatch apply

??

?

1.?檢查當前GoldenGate版本為V12.3.0.1.4

[oracle@oradb1 ogg123]$ ./ggsci?

Oracle GoldenGate Command Interpreter for Oracle

Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO

?

2.?安裝OPatch 12.2.0.1.13

[oracle@oradb1 ~]$ cd $OGG_HOME/OPatch

[oracle@oradb1 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.17

3.?設置ORACLE_HOME環境變量到Oracle GoldenGate安裝目錄下

[oracle@oradb1 ogg123]$ export ORACLE_HOME=$OGG_HOME

[oracle@oradb1 ogg123]$ export PATH=$ORACLE_HOME:$PATH

?

4.?確認Oracle GoldenGate目錄下沒有運行的進程

[oracle@oradb1 ogg12c]$ fuser ./ogg123/

?

5.?檢查$ORACLE_HOME/crypto和$ORACLE_HOME/directc文件權限為可寫

[oracle@oradb1 ogg123]$ ls -ld crypto

drwxr-xr-x 2 oracle oinstall 4096 Apr 24 18:46 crypto

?

6.?執行補丁安裝

[oracle@oradb1 ~]$ cd /oradata/ogg12c/software/

[oracle@oradb1 software]$ unzip p29636573_123014_Linux-x86-64.zip

[oracle@oradb1 software]$ cd 29636573/

[oracle@oradb1 29636573]$?$ORACLE_HOME/OPatch/opatch apply ?

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: ??29636573 ?

?

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 = '/oradata/ogg12c/ogg123')

?

Is the local system ready for patching? [y|n]

y

?

Backing up files...

Applying interim patch '29636573' to OH '/oradata/ogg12c/ogg123'

?

Patching component oracle.oggcore.ora12c, 12.3.0.1.2...

Patch 29636573 successfully applied.

OPatch succeeded.

1.5.4.?查看當前版本信息

[oracle@oradb1 29636573]$ $ORACLE_HOME/OPatch/opatch lsinv

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: oradb1

ARU platform id: 226

ARU platform description:: Linux x86-64

?

Installed Top-level Products (1):

?

Oracle GoldenGate Core ??????????????????????????????????????????????12.3.0.1.2

There are 1 products installed in this Oracle Home.

Interim patches (1) :

?

Patch ?29636573 ????: applied on Wed Apr 24 22:57:55 CST 2019

Unique Patch ID: ?22876441

???Created on 12 Apr 2019, 00:30:40 hrs PST8PDT

???Bugs fixed:

?????24411701, 29135238

?

--------------------------------------------------------------------------------

OPatch succeeded.

?

[oracle@oradb1 ogg123]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.3.0.1.4 29600067_FBO

?

1.5.5.?參考文檔

How to Apply Patches for GoldenGate (文檔 ID 2188592.1)

How To Upgrade GoldenGate 12c OPatch To Latest Release? (文檔 ID 2053712.1)

Master Note for Oracle GoldenGate Core Product Patch Sets (文檔 ID 1645495.1)

Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations (文檔 ID 2193391.1)

Oracle GoldenGate -- Oracle RDBMS Server Recommended Patches (文檔 ID 1557031.1)

Oracle GoldenGate 12.3.0.1.181228 Patch Set Availability (文檔 ID 2525524.1)