Uncategorized

Install Oracle GoldenGate 12c on Exadata – Using Response file

January 2, 2017

Overview
Until Oracle GoldenGate 11g, Oracle GoldenGate installation was fairly simple. You just unzip the software into a directory and create subdirs. Starting with Oracle GoldenGate 12c, Oracle GoldenGate software for Oracle Database is installed using Oracle Universal Installer (OUI). This change makes it easy for Oracle to audit software and licensing.

You can Install Oracle GoldenGate 12c in 2 ways:

Graphical User Interface (GUI)
Using response file (Silent)

In this article I will demostrate how to Install Oracle GoldenGate 12c using response file on a full Rack Exadata Database Machine.

Environment

Full Rack Exadata X5-2
ZFS for Share Oracle GoldenGate Software location
Oracle Database 12.1.0.2

Steps to Download Oracle GoldenGate 12c Software

Open a web browser and enter www.oracle.com in the address bar

This will bring you to the Oracle website home page

On this page hover on the download tab and click on “middleware”

Click GoldenGate

Accept the agreement and select the desired Oracle GoldenGate version for your platform.

Here I am downloading “Oracle GoldenGate 12.2.0.1.1 for Oracle on Linux x86-64”

Copy the zip file from your desktop to Exadata Compute node 1 using WinScp

Drag and Drop the file from left to right in to a directory

Here I am copying the file to /u01/app/oracle/software location

File copy is in progress

Steps to Install Oracle GoldenGate 12c software using response file

dm01db01-orcl1 {/home/oracle}:cd /u01/app/oracle/software
dm01db01-orcl1 {/u01/app/oracle/software}:ls -ltr
total 464928
-rw-r–r– 1 oracle oinstall 475611228 Jan 2 04:51 fbo_ggs_Linux_x64_shiphome.zip
dm01db01-orcl1 {/u01/app/oracle/software}:

Unzip the Oracle GoldenGate 12c software

dm01db01-orcl1 {/u01/app/oracle/software}:unzip fbo_ggs_Linux_x64_shiphome.zip
Archive: fbo_ggs_Linux_x64_shiphome.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/OuiConfigVariables.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/productlanguages.properties
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/setperms1.sh
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/racfiles.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_exp_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_exp_1.xml
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/globalvariables/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/standardDialogs/
……
creating: fbo_ggs_Linux_x64_shiphome/Disk1/response/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf
dm01db01-orcl1 {/u01/app/oracle/software}:ls -ltr
total 465216
drwxr-xr-x 3 oracle oinstall 4096 Dec 12 2015 fbo_ggs_Linux_x64_shiphome
-rw-r–r– 1 oracle oinstall 1559 Jan 18 2016 OGG-12.2.0.1-README.txt
-rw-r–r– 1 oracle oinstall 282294 Jan 18 2016 OGG-12.2.0.1.1-ReleaseNotes.pdf
-rw-r–r– 1 oracle oinstall 475611228 Jan 2 04:51 fbo_ggs_Linux_x64_shiphome.zip

Change directory to response folder and copy the response file (oggcore.rsp) to /u01/app/oracle/software location

dm01db01-orcl1 {/u01/app/oracle/software}:cd fbo_ggs_Linux_x64_shiphome/Disk1/response

dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1/response}:ls -ltr
total 8
-rwxrwxr-x 1 oracle oinstall 4286 Jul 3 2014 oggcore.rsp

dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1/response}:cp oggcore.rsp /u01/app/oracle/software/

dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1/response}:cd /u01/app/oracle/software/
dm01db01-orcl1 {/u01/app/oracle/software}:ls -ltr
total 465224
drwxr-xr-x 3 oracle oinstall 4096 Dec 12 2015 fbo_ggs_Linux_x64_shiphome
-rw-r–r– 1 oracle oinstall 1559 Jan 18 2016 OGG-12.2.0.1-README.txt
-rw-r–r– 1 oracle oinstall 282294 Jan 18 2016 OGG-12.2.0.1.1-ReleaseNotes.pdf
-rw-r–r– 1 oracle oinstall 475611228 Jan 2 04:51 fbo_ggs_Linux_x64_shiphome.zip
-rwxr-xr-x 1 oracle oinstall 4286 Jan 2 07:20 oggcore.rsp

Make a backup of the response file before editing

dm01db01-orcl1 {/u01/app/oracle/software}:cp oggcore.rsp oggcore.rsp_bkp
dm01db01-orcl1 {/u01/app/oracle/software}:

Open the response file and make the following changes as described below

dm01db01-orcl1 {/u01/app/oracle/software}:vi oggcore.rsp

INSTALL_OPTION=ORA12c –> This is the Oracle database version
SOFTWARE_LOCATION=/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome –> This is Oracle GoldenGate software location. On RAC it should be a shared location.
START_MANAGER=true –> Setting this parameter to true will configure manager process at the end of installation.
MANAGER_PORT=7809 –> port number for starting manager process. The port should be opened.
DATABASE_LOCATION=/u01/app/oracle/product/11.2.0.4/dbhome –> This is the Oracle Database Home location
INVENTORY_LOCATION=/u01/app/oraInventory –> OraInventory location
UNIX_GROUP_NAME=oinstall –> The operating system group for oraInventory

After making the changes above, the response file looks like this:

dm01db01-orcl1 {/u01/app/oracle/software}:cat oggcore.rsp

####################################################################
## Copyright(c) Oracle Corporation 2014. All rights reserved. ##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file should be secured to have read ##
## permission only by the oracle user or an administrator who ##
## own this installation to protect any sensitive input values. ##
## ##
####################################################################

#——————————————————————————-
# Do not change the following system generated value.
#——————————————————————————-
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2

################################################################################
## ##
## Oracle GoldenGate installation option and details ##
## ##
################################################################################

#——————————————————————————-
# 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=ORA12c

#——————————————————————————-
# Specify a location to install Oracle GoldenGate
#——————————————————————————-
SOFTWARE_LOCATION=/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome

#——————————————————————————-
# Specify true to start the manager after installation.
#——————————————————————————-
START_MANAGER=true

#——————————————————————————-
# Specify a free port within the valid range for the manager process.
# Required only if START_MANAGER is true.
#——————————————————————————-
MANAGER_PORT=7809

#——————————————————————————-
# Specify the location of the Oracle Database.
# Required only if START_MANAGER is true.
#——————————————————————————-
DATABASE_LOCATION=/u01/app/oracle/product/11.2.0.4/dbhome

################################################################################
## ##
## Specify details to Create inventory for Oracle installs ##
## Required only for the first Oracle product install on a system. ##
## ##
################################################################################

#——————————————————————————-
# Specify the location which holds the install inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#——————————————————————————-
INVENTORY_LOCATION=/u01/app/oraInventory

#——————————————————————————-
# Unix group to be set for the inventory directory.
# This parameter is not applicable if installing on
# Windows based Operating System.
#——————————————————————————-
UNIX_GROUP_NAME=oinstall

dm01db01-orcl1 {/u01/app/oracle/software}:

Change directory to Disk1 and start Oracle GoldenGate software installation as follows:

dm01db01-orcl1 {/u01/app/oracle/software}:cd fbo_ggs_Linux_x64_shiphome/Disk1/
dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1}:ls -ltr
total 16
drwxr-xr-x 4 oracle oinstall 4096 Dec 12 2015 install
drwxr-xr-x 11 oracle oinstall 4096 Dec 12 2015 stage
-rwxr-xr-x 1 oracle oinstall 918 Dec 12 2015 runInstaller
drwxrwxr-x 2 oracle oinstall 4096 Dec 12 2015 response

dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1}:./runInstaller -silent -responseFile /u01/app/oracle/software/oggcore.rsp
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB. Actual 3317 MB Passed
Checking swap space: must be greater than 150 MB. Actual 24302 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-02_07-31-03AM. Please wait …
dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1}:You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2017-01-02_07-31-03AM.log
The installation of Oracle GoldenGate Core was successful.
Please check ‘/u01/app/oraInventory/logs/silentInstall2017-01-02_07-31-03AM.log’ for more details.
Successfully Setup Software.

Note: If you look at the log file at ‘/u01/app/oraInventory/logs/installActions2017-01-02_07-31-03AM.log’ it will show you what has been done in the background by the runInstaller

Let’s connect to ggsci prompt and verify the manager process

dm01db01-orcl1 {/u01/app/oracle/software/fbo_ggs_Linux_x64_shiphome/Disk1}:cd /zfssa/dm01/backup/product/ogg/12.2.0.1/gghome/
dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:./ggsci
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

ooppss we can’t connect to ggsci. Don’t worry. This is the known issue on Linux/Unix platform. Here is the solution for this issue.

Open the .bash_profile and add the following two variables

dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:vi ~/.bash_profile

export GG_HOME=/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$GG_HOME

Execute the .bash_profile and verify the variables.

dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:. ~/.bash_profile
dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:echo $GG_HOME
/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome

dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11.2.0.4/dbhome/lib:/u01/app/oracle/product/11.2.0.4/dbhome/lib32:/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome

Now try connecting to ggsci.

Yeah we are able to connect now

dm01db01-orcl1 {/zfssa/dm01/backup/product/ogg/12.2.0.1/gghome}:./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dm01db01.netsoftmate.com) 1>

Verify the manager process

GGSCI (dm01db01.netsoftmate.com) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

GGSCI (dm01db01.netsoftmate.com) 2> info mgr

Manager is running (IP port dm01db01.netsoftmate.com.7809, Process ID 53422).

GGSCI (dm01db01.netsoftmate.com) 3> view params mgr

PORT 7809

Conclusion
This completes our Oracle GoldenGate 12c installation on Exadata database machine. We have seen how much easy it is to install Oracle GoldenGate software wihtout GUI interface. The key for installing Oracle GoldenGate on 12c a RAC environment is to choose a shared location for software. You can also choose to install Oracle GoldenGate on local file system if you don’t have a shared location.

Tags: Exadata and GoldenGate, Install Oracle GoldenGate on Exadata, OGG, OGG 12c, Oracle GoldenGate 12c, Oracle GoldenGate installation, Oracle GoldenGate installation on Exadata

Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!

Home

About

Services

Blog

Contact

Uncategorized

Install Oracle GoldenGate 12c on Exadata – Using Response file

REPLY A MESSAGE Cancel reply

ABOUT US

Services

CONTACT US

Follow Us!