Monday, 2 January 2017

Install Oracle GoldenGate 12c on Exadata - Using Response file

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:

  1. Graphical User Interface (GUI) 
  2. 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


  • Login to Exadata Compute node 1 as Oracle software owner and navigate to the Oracle GoldenGate staging location

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.

No comments:

Post a Comment