Example of installing and upgrading goldengate 12.2 using Opatch

Source: Internet
Author: User
Tags character set reserved oracle database

The installation method of ogg 12.2 is slightly different from that of OGG 11. It is OK before Decompression. Now ogg provides the OUI installation method and can also be silent. The previous upgrade is to decompress and overwrite, now there is one more option to use opatch for installation like DB. Here we will simply record the installation process and install PSU for OGG.

Basic software can be downloaded from the ORACLE official website (OTN), and patches can be downloaded from MOS. My environment is OGG 12.2.0.1 FOR oracle database 11.2 on Solaris OS 11.

Install
[Oracle @ solaris_db1:/export/home/oracle] # unzip fbo_ggs_Solaris_x86_64_shiphome.zip

[Oracle @ solaris_db1:/export/home/oracle] # cd fbo_ggs_Solaris_x86_64_shiphome

[Oracle @ solaris_db1:/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1] # ls
Install response runInstaller stage


[Oracle @ solaris_db1:/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1] # cd response
[Oracle @ solaris_db1:/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1/response] # ls
Oggcore. rsp
[Oracle @ solaris_db1:/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1/response] # vi oggcore. rsp
...
# 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 =/export/home/oracle/ogg12
...
-- Modify only two items
[Oracle @ solaris_db1:/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1] #. /runInstaller-silent-nowait-responseFile/export/home/oracle/fbo_ggs_Solaris_x86_64_shiphome/Disk1/response/oggcore. rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 5140 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5400 MB Passed
Preparing to launch Oracle Universal Installer from/tmp/OraInstall2016-08-11_08-59-55AM. Please wait...
You can find the log of this install session:
/Oracle/app/oraInventory/logs/installActions2016-08-11_08-59-55AM.log
The installation of Oracle GoldenGate Core was successful.
Please check'/oracle/app/oraInventory/logs/silentInstall2016-08-11_08-59-55AM.log 'for more details.
Successfully Setup Software.


Tip:
ResponseFile cannot use relative paths

Patch
Export ORACLE_HOME =/export/home/oracle/ogg12_2
Export LD_LIBRARY_PATH = $ ORACLE_HOME: $ LD_LIBRARY_PATH


[Oracle @ solaris_db1:/export/home/oracle/22641169] # $ ORACLE_HOME/OPatch/opatch apply
/Export/home/oracle/ogg12_2/OPatch/opatch [103]: whereis: not found [No such file or directory]
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:/export/home/oracle/ogg12_2
Central Inventory:/oracle/app/oraInventory
From:/var/opt/oracle/oraInst. loc
OPatch version: 11.2.0.1.7
OUI version: 11.2.0.3.0
Log file location:/export/home/oracle/ogg12_2/export toollogs/opatch/opatch2016-08-11_09-21-19AM.log

Applying interim patch '000000' to oh'/export/home/oracle/ogg12_2'
Verifying environment and padding Ming 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 = '/export/home/oracle/ogg12_2 ')


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

Patching component oracle.ogg core. ora11g, 12.2.0.0.0...
Patch 22641169 successfully applied
Log file location:/export/home/oracle/ogg12_2/export toollogs/opatch/opatch2016-08-11_09-21-19AM.log

OPatch succeeded.
[Oracle @ solaris_db1:/export/home/oracle/22641169] # $ ORACLE_HOME/OPatch/opatch lsinventory
/Export/home/oracle/ogg12_2/OPatch/opatch [103]: whereis: not found [No such file or directory]
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:/export/home/oracle/ogg12_2
Central Inventory:/oracle/app/oraInventory
From:/var/opt/oracle/oraInst. loc
OPatch version: 11.2.0.1.7
OUI version: 11.2.0.3.0
Log file location:/export/home/oracle/ogg12_2/export toollogs/opatch/opatch2016-08-11_09-22-45AM.log

Lsinventory Output file location:/export/home/oracle/ogg12_2/export toollogs/opatch/lsinv/lsinventory2016-08-11_09-22-45AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1 ):

Oracle GoldenGate Core 12.2.0.0.0
There are 1 products installed in this Oracle Home.


Interim patches (1 ):

Patch 22641169: applied on Thu Aug 11 09:22:26 UTC 2016
Unique Patch ID: 20170213
Created on 23 Feb 2016, 16:46:08 hrs PST8PDT
Bugs fixed:
22352402,215 62399, 21481506,224 55149

 

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

OPatch succeeded.

[Oracle @ solaris_db1:/export/home/oracle/ogg12_2] #./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.160223 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160206.1508.4_FBO
Solaris, x64, 64bit (optimized), Oracle 11g on Feb 19 2016 18:51:21
Operating system character set identified as ISO-8859-1.

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

 

GGSCI (solaris_db1) 1>

GGSCI (solaris_db1) 16> create subdirs

Creating subdirectories under current directory/export/home/oracle/ogg12_2

Parameter files/export/home/oracle/ogg12_2/dirprm: created
Report files/export/home/oracle/ogg12_2/dirrpt: created
Checkpoint files/export/home/oracle/ogg12_2/dirchk: created
Process status files/export/home/oracle/ogg12_2/dirpcs: created
SQL script files/export/home/oracle/ogg12_2/dirsql: created
Database definitions files/export/home/oracle/ogg12_2/dirdef: created
Extract data files/export/home/oracle/ogg12_2/dirdat: created
Temporary files/export/home/oracle/ogg12_2/dirtmp: created
Credential store files/export/home/oracle/ogg12_2/dircrd: created
Masterkey wallet files/export/home/oracle/ogg12_2/dirwlt: created
Dump files/export/home/oracle/ogg12_2/dirdmp: created


GGSCI (solaris_db1) 17> edit params mgr
Port 7809
Dynamicportlist 7810-7830
DynamicPortReassignDelay 5

GGSCI (solaris_db1) 18> start mgr
Manager started.


GGSCI (solaris_db1) 19> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.