oracle-goldengate-monitoring-featured

This week I had to install the Oracle Golden Gate product on a client and the DBA that was on site, was deprived of the access to a graphical environment to execute the installation with the Oracle Universal Install method.

The first thing that this young man tells me is that he had thought about uploading the software and doing the unzip and voila!

With that I would have the binaries ready to be used and start with the configurations.

But we were before a version of OGG 12c and this is not possible.

It is so that it appeals to the traditional installation in SILENT MODE.

Starting of Installation

I asked you to follow the following steps:

  1. Create the path for the software installation.
  2. Deploy the installation binaries with the unzip command.
  3. Identify the Response File.
  4. Execute the installation in silent mode.

Path for software installation

It helps to create a mnemonic path in case we will contain more instances of OGG in the future.

 /home/oracle/CDBAR/OGG_Ins1

We deploy the software

[oracle@src01 Disk1]$ unzip fbo_ggs_Linux_x64_shiphome.zip

About the Response File

The response file is in the response directory

[oracle@src01 Disk1]$ ls
install  response  runInstaller  stage

This will be our configuration file (oggcore.rsp), which will allow us to perform SILENT execution through the console.

I share the model that you have set for this team.

####################################################################
## 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=ORA11g
#-------------------------------------------------------------------------------
# Specify a location to install Oracle GoldenGate
#-------------------------------------------------------------------------------
SOFTWARE_LOCATION=/home/oracle/CDBAR/OGG_Inst1
#-------------------------------------------------------------------------------
# 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/db_1

################################################################################
##                                                                            ##
## 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=dba

So we are ready to start with the installation of the software.

Installation

Now that we have our response file configured from the console, we can begin the installation.

 ./runInstaller -silent -responseFile /home/oracle/CDBAR/soft/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp 

We can see that the installation finished correctly and that we can also consult a log that the tool proposes.

[oracle@src01 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/CDBAR/soft/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 6350 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3998 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-07-10_09-20-53PM. Please wait ...[oracle@src01 Disk1]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2016-07-10_09-20-53PM.log
The installation of Oracle GoldenGate Core was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2016-07-10_09-20-53PM.log' for more details.
Successfully Setup Software.

[oracle@src01 Disk1]$

As we set the parameter START_MANAGER = TRUE we will perform the corresponding control and verify that it is in full force.

[oracle@src01 OGG]$ ./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 (src01.localdomain) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING

GGSCI (src01.localdomain) 2>

I hope to be of help again, post your messages and Greetings LATAM!

Twt: @enjoydana
face: https://www.facebook.com/JuanAndresBA/