Shulou(Shulou.com)06/01 Report--

This article describes the basic installation of OGG and the installation of OGG patches.

1. GoldenGate installation 1.1. Download the GoldenGate version

The new version can be downloaded directly from ORACLE's official website, Oracle GoldenGate Downloads:

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

But the historical version needs to be downloaded from the Delivery website: https://edelivery.oracle.com/.

1.2. GoldenGate installation

The new version of GoldenGate supports initialization of installation through a graphical interface. Compared to previous operations, GoldenGate 11 can be installed by direct decompression.

1.2.1. Graphical interface installation

After unpacking the package, launch the installation graphical interface with the runInstaller command.

[oracle@oradb1 Disk1] $. / runInstaller

Take the installation of OGG 12.3 as an example, which supports ORACLE 11G and 12C, so the database version is selected during the installation.

1.2.2. Decompression and installation

GoldenGate 11 can be installed by direct decompression.

[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. Configure environment variables

After GoldenGate is installed under Linux and Unix, the library file under the ORACLE installation environment is required to start, so the $ORACLE_HOME/lib directory must be configured in the LD_LIBRARY_PATH environment variable:

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. Check the GoldenGate environment

Before GoldenGate starts, the library files of ggsci applications need to be checked. If there are library files that cannot be found, it will cause ggsci startup failure.

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

[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. Install patch 1.5.1 for GoldenGate. Upgrade OPatch

OPatch is a program used by ORACLE to install patches. Before installing the patches, it is recommended to read the instructions in the patch pack and upgrade OPatch to the officially specified version.

The following is the documentation for OPatch in MOS, which can be referenced for download and use of OPatch.

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

The replacement of OPatch is relatively simple. After decompressing the p6880880__.zip package, you can use operating system commands to replace the software. Permissions need to be modified after non-ORACLE users replace the OPatch directory. The version number (6880880) of the OPatch software is fixed and the patch can be downloaded directly on MOS.

Extract the latest OPatch software:

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

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

Back up the old OPatch software:

[oracle@oradb1 ~] $cd $OGG_HOME

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

Replace the new OPatch software and modify the software permissions:

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

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

After the replacement is complete, check the version of the new OPatch software.

[oracle@oradb1 OPatch] $. / opatch version

OPatch Version: 12.2.0.1.17

1.5.2. Get patches

Through the patch search function of MOS, you can get the latest patch information of the current software.

It is important to note that the OGG patch is for different database versions. You need to pay attention to version information when downloading.

1.5.3. Install patch 29636573

Patch 29636573: Patch for MLR 29600067: Linux x86-64: Oracle 12c: OGG 12.3.0.1.4

View the patch installation README file:

(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 / bin and the / 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.Mel 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.

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

$p__.zip

3. Navigate to the / directory:

$cd /

4. Install the patch by running the following command:

$opatch apply

1. Check that the current GoldenGate version is 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

two。 Install 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. Set the ORACLE_HOME environment variable to the Oracle GoldenGate installation directory

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

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

4. Verify that there are no processes running in the Oracle GoldenGate directory

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

5. Check that the permissions of $ORACLE_HOME/crypto and $ORACLE_HOME/directc files are writable

[oracle@oradb1 ogg123] $ls-ld crypto

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

6. Perform patch installation

[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. View current version information

[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. Reference documentation

How to Apply Patches for GoldenGate (document ID 2188592.1)

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

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

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

Oracle GoldenGate-Oracle RDBMS Server Recommended Patches (document ID 1557031.1)

Oracle GoldenGate 12.3.0.1.181228 Patch Set Availability (document ID 2525524.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.