GoldenGate安裝以及補(bǔ)丁安裝

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

1.?GoldenGate安裝

1.1.?GoldenGate版本下載

新版本通過ORACLE官方網(wǎng)站可以直接進(jìn)行下載Oracle GoldenGate Downloads：

宣漢網(wǎng)站制作公司哪家好，找成都創(chuàng)新互聯(lián)！從網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、APP開發(fā)、成都響應(yīng)式網(wǎng)站建設(shè)公司等網(wǎng)站項目制作，到程序開發(fā)，運(yùn)營維護(hù)。成都創(chuàng)新互聯(lián)從2013年開始到現(xiàn)在10年的時間，我們擁有了豐富的建站經(jīng)驗(yàn)和運(yùn)維經(jīng)驗(yàn)，來保證我們的工作的順利進(jìn)行。專注于網(wǎng)站建設(shè)就選成都創(chuàng)新互聯(lián)。

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

?

但歷史版本需要通過Delivery網(wǎng)站進(jìn)行下載：https://edelivery.oracle.com/。

?

1.2.?GoldenGate安裝

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

1.2.1.?圖形界面安裝

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

[oracle@oradb1 Disk1]$ ./runInstaller

?

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

1.2.2.?解壓安裝

GoldenGate?11可以通過直接解壓的方式進(jìn)行安裝。

[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.?配置環(huán)境變量

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

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環(huán)境

GoldenGate 啟動前，需要對ggsci應(yīng)用的庫文件進(jìn)行檢查，如果有無法找到的庫文件，會導(dǎo)致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補(bǔ)丁安裝

1.5.1.?升級OPatch

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

?

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

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

?

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

?

解壓最新的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軟件，并修改軟件權(quán)限：

[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.?獲取補(bǔ)丁

通過MOS的補(bǔ)丁查找功能，可以獲取當(dāng)前軟件的最新補(bǔ)丁信息。?

需要注意OGG補(bǔ)丁是針對不同數(shù)據(jù)庫的版本。下載時需要注意版本信息。

1.5.3.?安裝補(bǔ)丁29636573

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

?

查看補(bǔ)丁安裝自述文件：

(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.?檢查當(dāng)前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.?設(shè)置ORACLE_HOME環(huán)境變量到Oracle GoldenGate安裝目錄下

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

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

?

4.?確認(rèn)Oracle GoldenGate目錄下沒有運(yùn)行的進(jìn)程

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

?

5.?檢查$ORACLE_HOME/crypto和$ORACLE_HOME/directc文件權(quán)限為可寫

[oracle@oradb1 ogg123]$ ls -ld crypto

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

?

6.?執(zhí)行補(bǔ)丁安裝

[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.?查看當(dāng)前版本信息

[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)

網(wǎng)站題目：GoldenGate安裝以及補(bǔ)丁安裝
網(wǎng)址分享：http://bm7419.com/article42/jdijhc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站維護(hù)、定制網(wǎng)站、虛擬主機(jī)、企業(yè)建站、、動態(tài)網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)