goldengate 12.2.2.1.0 upgrade to 12.1.2.1.5

dongxujian

GOLDENGATE  ogg 12.1.2.1.0升级至 12.1.2.1.5 实践操作

1.opatch 使用$GGHOME/OPATCH/opatch
2.声明 export ORACLE_HOME=$GGHOME所在目录
3.数据库实例关闭，防止数据库进程占用目录
4.OGG安装用户执行，此处为oracle用户
##########################################################################################################################
单实例：
[oracle@node1 20704740]$ export ORACLE_HOME=/u01/app/ogg
[oracle@node1 20704740]$ cd /tmp/20704740
[oracle@node1 20704740]$ /u01/app/ogg/OPatch/opatch apply
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home    : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from          : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version    : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2015-08-04_03-06-40AM.log

Applying interim patch '20704740' to OH '/u01/app/ogg'
Verifying environment and performing prerequisite checks...

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 = '/u01/app/ogg')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.oggcore.ora11g, 12.1.2.1.0...
Patch 20704740 successfully applied
Log file location: /u01/app/ogg/cfgtoollogs/opatch/opatch2015-08-04_03-06-40AM.log

OPatch succeeded.

###################################################################################################################################
rac 只关闭数据库实例

[oracle@node1 ogg]$ cd /tmp
[oracle@node1 tmp]$ cd 20704740/
[oracle@node1 20704740]$ pwd
/tmp/20704740
[oracle@node1 20704740]$ export ORACLE_HOME=/u01/app/ogg/
[oracle@node1 20704740]$ /u01/app/ogg/OPatch/o
ocm/          opatch       opatch.bat    opatchprereqs/
[oracle@node1 20704740]$ /u01/app/ogg/OPatch/opatch apply
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home    : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from          : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version    : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2015-08-04_03-13-49AM.log

Applying interim patch '20704740' to OH '/u01/app/ogg'
Verifying environment and performing prerequisite checks...

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 = '/u01/app/ogg')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

Patching component oracle.oggcore.ora11g, 12.1.2.1.0...

Copy failed from '/tmp/20704740/files//mgr' to '/u01/app/ogg//mgr'...
Please verify all applications associated with the Oracle Home '/u01/app/ogg' are shut down. If this is AIX, please perform solution documented in Note 739963.1 on https://myoraclesupport.oracle.com.

Do you want to retry copying the file? [y|n]
y
User Responded with: Y

Retry copying the file to '/u01/app/ogg//mgr'.
Patch 20704740 successfully applied
Log file location: /u01/app/ogg/cfgtoollogs/opatch/opatch2015-08-04_03-13-49AM.log

OPatch succeeded.

#######################################################################################################################

Oracle GoldenGate V12.1.2.1.5 for Oracle Database 11g
OPTIMIZER Patch for Bug# 20704740
Released: April 2015

This patch is applicable via Oracle GoldenGate V12.1.2.1.0 for Oracle Database

This document describes how you can install the one-off patch for bug# 20704740 on your Oracle GoldenGate V12.1.2.1.0 for Oracle Database 11g

(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.1.2.1.0 for Oracle.

2.    Oracle recommends you to use the latest version of OPatch.
If you do not have the latest version, then follow the instructions outlined in the My Oracle Support note 224346.1 available at:
https://support.oracle.com/CSP/m ... NOT&id=224346.1

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.


(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

Note:
When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME of the Oracle GoldenGate release. OPatch categorizes conflicts into the following types:
- Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply  - In this case, continue with the patch installation because the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.

5. Start the services from the Oracle GoldenGate home.

(3) Postinstallation
----------------------

<Any postinstall instructions if applicable>

(4) Deinstallation
---------------------
To deinstall the patch, follow these steps:

1. Navigate to the <PATCH_TOP_DIR>/<Patch_number> directory:
$ cd <PATCH_TOP_DIR>/<Patch_number>

2. Deinstall the patch by running the following command:
$ opatch rollback -id <Patch_number>

3. Start the services from the Oracle GoldenGate home.

(5)Postdeinstallation
-------------------------

<Any postinstall instructions if applicable>

(6) Bugs Fixed by This Patch
---------------------------------
Please refer to the release notes for Oracle GoldenGate for the complete list of bugs fixed by this patch.

--------------------------------------------------------------------------
Copyright 2014, Oracle and/or its affiliates. All rights reserved.
--------------------------------------------------------------------------

图文精华

goldengate 12.2.2.1.0 upgrade to 12.1.2.1.5