Moneycontrol Brokerage Recos

Sunday, July 30, 2017

Oracle GoldenGate 12c Silent Installation



In my last article, I demonstrated the steps to install Oracle GoldenGate 12c software in Graphical Mode, thanks to my friend "Juan Andres Mercado" who reminded me for Oracle GoldenGate silent installation because it is possible you may not find graphical access to some critical Data Center environments to install in Graphical Mode so the only option to install Oracle products would be in silent mode.

Oracle GoldenGate silent installation is similar to other oracle product's silent or Text based installation like we do for Oracle Grid Infrastructure and Oracle RDBMS installations using a response file. All we need to do is to create a response file to be used for silent installation. Oracle already provides a sample response file (Disk1/response/oggcore.rsp) with Oracle GoldenGate software package which can be used to create a new response file or we can modify the existing sample response file to be used for our Oracle GoldenGate silent installation.


I used the existing sample response file for this demo by adjusting the required parameters to be used as per its need and requirements.

Below is the sample response file I have used and have highlighted the parameters which are required and needed to modify for the silent installation.



Sample Response File:
==================

 bash-4.1$ cat /u01/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=ORA11g  
 #-------------------------------------------------------------------------------  
 # Specify a location to install Oracle GoldenGate  
 #-------------------------------------------------------------------------------  
 SOFTWARE_LOCATION=/u01/app/oracle/product/11.2.0/ogg_home  
 #-------------------------------------------------------------------------------  
 # 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=7800  
 #-------------------------------------------------------------------------------  
 # Specify the location of the Oracle Database.  
 # Required only if START_MANAGER is true.  
 #-------------------------------------------------------------------------------  
 DATABASE_LOCATION=/u01/app1/oracle/product/11.2.0/dbhome_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/app1/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  


In above sample response file, following parameters are used for silent installation.

INSTALL_OPTION=This parameter is used to choose the option whether you want to install Oracle GoldenGate for Oracle Database 11g or Oracle Database 12c. To install Oracle GoldenGate for Oracle Database 11g, you would need to specify its value as ORA11G or ORA12C to install Oracle GoldenGate for Oracle Database 12c. I have used the value ORA11G as I am installing Oracle Goldenate for Oracle Database 11g.

SOFTWARE_LOCATION: Specify the Oracle GoldenGate Home location for this parameter.

START_MANAGER: Specify true if you want Oracle GoldenGate Manager process to start upon completion of Oracle GoldenGate or false if you don't want the Manager process to start automatically after Oracle GoldenGate installation.

MANAGER_PORT: Specify Manager port number on which your Oracle GoldenGate Manager process will run and listen remote GoldenGate connections.

DATABASE_LOCATION: Specify Oracle Database Home location for which you are installation Oracle GoldenGate software to capture changed data from or want to replicate the changes to.

INVENTORY_LOCATION: Specify Oracle Inventory location here.

UNIX_GROUP_NAME: Specify Oracle OS user group.



Once you are done with the preparation of response file, in my case, I have placed my response file at /u01/oggcore.rsp location. Go to the Oracle GoldenGate extracted software location and run the /runInstaller in silent mode to install Oracle GoldenGate software as below.

[oracle@DRsrv Disk1]$ ./runInstaller -silent -responseFile /u01/oggcore.rsp -showProgress
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 2520 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-10-16_01-52-22PM. Please wait ...[oracle@DRsrv Disk1]$ No protocol specified
You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2017-10-16_01-52-22PM.log

Prepare in progress.
..................................................   9% Done.

Prepare successful.

Copy files in progress.
..................................................   55% Done.
..................................................   62% Done.
..................................................   69% Done.
..................................................   74% Done.
..................................................   79% Done.
..................................................   85% Done.
..........
Copy files successful.
.
.
.

Link binaries in progress.
..........
Link binaries successful.

Setup files in progress.
..................................................   90% Done.

Setup files successful.
The installation of Oracle GoldenGate Core was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2017-10-16_01-52-22PM.log' for more details.

Configuring and starting manager... in progress.
..................................................   100% Done.

Configuring and starting manager... successful.
Successfully Setup Software.


The installation of Oracle GoldenGate Core was successful.

Please check '/u01/app1/oraInventory/logs/silentInstall2017-07-30_09-26-10PM.log' for more details.

Successfully Setup Software.


Once the Oracle GoldenGate Installation completes successfully, run the orainstroot.sh script located in oraInventory location.


[root@prodsrv app]# /u01/app1/oraInventory/orainstRoot.sh 
Changing permissions of /u01/app1/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app1/oraInventory to oinstall.
The execution of the script is complete.



Validating Oracle GoldenGate Installation:
----------------------------------------------------

You can verify what all Oracle products are installed on your server just by looking at your Oracle inventory file.


First identify your Oracle inventory location as below.

[root@prodsrv ~]# cat /etc/oraInst.loc
inventory_loc=/u01/app1/oraInventory
inst_group=oinstall


Once you identified Oracle Inventory location then go to your Oracle Inventory location and get the contents of inventory.xml file to see the installed oracle products on your server.


[root@prodsrv ContentsXML]# pwd
/u01/app1/oraInventory/ContentsXML


[root@prodsrv ContentsXML]# cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.2.0.3.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDb11g_home1" LOC="/u01/app1/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/>
<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/11.2.0/ogg_home" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
[root@prodsrv ContentsXML]#


In above contents from inventory.xml file, you can see an Oracle Home added for our Oracle GoldenGate product as highlighted.


Another simplest way to validate your Oracle GoldenGate software installation quickly is to go to Oracle GoldenGate Home and invoke Oracle GoldenGate command line Interface to check the status of Manager process.


 $cd $OGG_HOME  
 -bash-4.1$ pwd  
 /u01/app/oracle/product/11.2.0/ogg_home  


 -bash-4.1$ ./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 (prodsrv) 1>  



 GGSCI (prodsrv) 1> info all  
 Program   Status   Group    Lag at Chkpt Time Since Chkpt  
 MANAGER   RUNNING                        
 GGSCI (prodsrv) 2>   



 GGSCI (prodsrv) 2> view param mgr  
 PORT 7800  
 GGSCI (prodsrv) 3>   


As you can see above that Oracle GoldenGate Installation has been performed successfully in silent mode and working fine.


No comments:

Post a Comment