Goldengate installation in silent mode

-

Goldengate installation in silent mode. First step is to create response file for triggering installation in silent mode. But first we will understand system requirement and other prerequisites.  

1        System Requirements and Preinstallation Instructions

Platform                    Oracle Version                  Installed Size (MB)

 

Windows                     11g                                          504

Windows                     12c                                          504

Linux                           11g                                          492

Linux                           12c                                          521

Solaris SPARC           11g                                          391

Solaris SPARC           12c                                          391

 

 

1.2      Operating System Privileges

To install on UNIX, the person who installs Oracle GoldenGate must have read

and write privileges on the Oracle GoldenGate installation directory.

 

osuser :  oracle

groups : oinstall, dba

 

1.3      Create  Directories and Symbolic link for GG binaries

  mkdir  -p /u02/app/oracle/

  mkdir  -p /u02/app/oracle/ogg_12.2

 

   cd /u02/app/oracle/

   ln -s   /u02/app/oracle/ogg_12.2  ogg

1        Golden Gate 12.2.0.1 Installation

 

Create following directories for GoldenGate software and trail files:

GoldenGate Home: /u02/app/oracle/ogg

 

GoldenGate Trail file:

Source System Trail Location: (The trail file size depends on the application requirement)

If possible, put trail files in shared storage.

Trail file location:  /ggtrail/outbound/..

n  If multiple databases utilizing GG, trail files can be located as such:

/ggtrail/outbound/database_name1/EX..

/ggtrail/outbound/database_name2/EX..

 

Target System Trail File Location:

            /ggtrail/dirdat/inbound/<sourcehost>/EX..

 

 

The minimum size of /ggtrail filesystem should be 500GB.

 

Note: GG database trail files should never be placed under GoldenGate Home (/u02/app/oracle/ogg).

 

1.1      Golden Gate Software Download.

 

1. Go to http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

2. Accept License Agreement

3. Find out your OS name and version:

$ uname -a

x86_64 x86_64 x86_64 GNU/Linux

4. Downloaded Oracle GoldenGate V12.2.0.1.0 for Oracle on Linux x86-64

5. You will get the zip file like: fbo_ggs_Linux_x64_shiphome.zip

6.  unzip the above file will generate a Folder: fbo_ggs_Linux_x64_shiphome

 

Note: Download the specific version of golden gate and Install on Primary and Target sites. Each Oracle database version on each platform has different installation binaries of Golden

Gate.

 

Prior to 12c Golden gate Installation was very simple, only need to unzip the file after download


 

 

Set ORACLE_SID, ORACLE_HOME, PATH and LD_LIBRARY_PATH

 

Platform

Environment variable

IBM AIX

IBM z/OS

LIBPATH

 

HP-UX

SHLIB_PATH

Sun Solaris

HP Tru64 (OSF/1)

LINUX

LD_LIBRARY_PATH

 

Example:

export LD_LIBRARY_PATH=/u02/app/oracle/produc/ogg_12.2:$LD_LIBRARY_PATH

 

 

The best practice is to install Oracle GoldenGate on each node. The Oracle GoldenGate installation must have the same location path on every node.

 

1.     Shutdown Oracle GoldenGate and move the following directories to the shared storage

a.     ./dirprm                       (parameter files – all)

b.     ./dirchk                        (process checkpoint files)

c.     ./dirpcs                        (process run PID files)

d.     ./dirdat                        (trail files – if used in dirdat)

e.     ./dirtmp                       (caching to temp files for extract or apply)

f.      ./BR                             (extraction only – Bounded Recovery files)

g.     ./scripts                       (monitoring scripts and log files)

h.     ./dirdef                        (source definition files)

./ dircrd                       (credential stores)

Response file. 

cat /tmp/gg.rsp:

oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2
INSTALL_OPTION=ORA11g
SOFTWARE_LOCATION=/u01/app/oracle/dba/scripts/gg/GG_12.2.1
START_MANAGER=FALSE
#MANAGER_PORT=21001
DATABASE_LOCATION=/u01/app/oracle/product/12.2.2.1/dbhome_1
INVENTORY_LOCATION=/u01/app/oraInventory
UNIX_GROUP_NAME=oinstall

Initiate installation in silent mode. 

GGserver> ./runInstaller -silent -executePrereqs -responseFile /tmp/gg.rsp -showProgress -local

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 5862 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 24570 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-12-10_01-54-37PM. Please wait ...GGserver> [WARNING] [INS-75003] The specified directory /u01/app/oracle/dba/scripts/shyam/GG_12.2.1 is not empty.

   CAUSE: The directory specified /u01/app/oracle/dba/scripts/shyam/GG_12.2.1 contains files.

   ACTION: Clean up the specified directory or enter a new directory location.

[WARNING] [INS-75016] Cluster detected: Specified software location is not shared.

It is recommended to install Oracle GoldenGate entirely on shared storage.

   CAUSE: The specified software location may not be accessible from one or more cluster nodes.

   ACTION: Specify the software location on a shared storage.

You can find the log of this install session at:

 /u01/app/oraInventory/logs/installActions2015-12-10_01-54-37PM.log
Prepare in progress.

..................................................   10% Done.

Prepare successful.

WARNING:OUI-10030:You have specified a non-empty directory to install this product. It is recommended to specify either an empty or a non-existent directory. You may, however, choose to ignore this message if the directory contains Operating System generated files or subdirectories like lost+found.

Do you want to proceed with installation in this Oracle Home?

Copy files in progress.
..................................................   61% Done.
..................................................   69% Done.
..................................................   77% Done.
..................................................   82% Done.
..................................................   87% Done.
..................................................   94% Done.
..................................................   95% Done.

Copy files successful.

Link binaries in progress.
..................................................   95% Done.

Link binaries successful.

Setup files in progress.
..................................................   95% Done.
..................................................   96% Done.
..................................................   97% Done.
..................................................   98% Done.
..................................................   99% Done.
..................................................   100% Done.

Setup files successful.
The installation of Oracle GoldenGate Core was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2015-12-10_01-54-37PM.log' for more details.
Successfully Setup Software.

GGserver> ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Nov 11 2015 01:38:14

Operating system character set identified as UTF-8.

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

GGSCI (GGserver) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     STOPPED

GGSCI (GGserver) 2>

You can learn more about oracle database administration: 

Pro Oracle GoldenGate for the DBA

Oracle Security Tools Installation and Configuration

Expert Oracle Exadata 

Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

Expert Oracle RAC 12c

==========================================================

Location: Singapore

Comments

Post a Comment

Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !

Popular posts from this blog

Restart Innodb MySQL Cluster after Complete outage(All node Down)

-
Image
Restart Innodb MySQL Cluster after Complete outage(All node Down) In DBA World, Their could be activity(like DC Migration) where all node of an MySQL Innodb cluster need to brought down. In MySQL Innodb cluster, We need to follow below steps in order to bring up cluster. 1) Start all node in the MySQL Innodb cluster. systemctl start myql 2) Try to connect cluster using mysqlsh and check status. 3) Strat cluster using complete outage command. Restart Cluster using below command: var cluster = dba.rebootClusterFromCompleteOutage(); root@mysqlhost01:~# mysqlsh --uri clusteradmin@mysqlhost01:3306 Please provide the password for 'clusteradmin@mysqlhost01:3306': ************************ Save password for 'clusteradmin@mysqlhost01:3306'? [Y]es/[N]o/Ne[v]er (default No): MySQL Shell 8.0.17 Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of...
Read more

Oracle Block Corruption - Detection and Resolution

-
Oracle Block Corruption - Detection and Resolution Any kind of corruption in database can  lead to stand still operation of the organization and can cause sever impact to organisation. In this blog , We are going to discuss about Block Corruption of the oracle database. Block Corruption :  Oracle Block Corruption occurs due inconsistent block Header ,Footer ,Checksum or Structure. Depending on the kind of insistency ,We can divide corruption into Physical and Logical corruption. Physical Corruption is due to Bad header, header or footer mismatch ,Invalid Block checksum & misplaced block. Usually this kind of the block corruption are due to external reason and difficult to resolve by oracle utilities alone.  Logical Corruption is due to corrupt or invalid Block structure when block checksum is valid. This kind of the Corruption can be resolved by the Oracle Utilities. Detection of Block Corruption Whenever a corrupt block is read Oracle reports an error in the alert l...
Read more

Install & Configure MySQL Router - MySQL InnoDB Cluster

-
Image
Install & Configure MySQL Router -  MySQL InnoDB Cluster MySQL Router is one of the important component of MySQL InnoDB Cluster as it's used by applications to connect to the MySQL DBs running on cluster.  In this blog, We will show How we can install and configure MySQL Router either on application server or on dedicated server for MySQL Router. Below are the step to install and configure MySQL Router: 1) Install MySQL Router on the Server(In our case , We are restoring MySQL Router on the ubuntu server). Run command as root user : apt-get install MySQL-router 2) Bootstrap or Configure MySQL Router mysqlrouter --bootstrap clusteradmin@mysqlhost01:3306 --user=mysqlrouter In Case of any issue in configuring MySQL Router ,We can use -force option of the bootstrap. mysqlrouter --bootstrap clusteradmin@n4ldbdev5030:3306 --directory=/home/myrouter --user=mysqlrouter --force 3) Test Connectivity via MySQL Router. mysqlsh --uri clusteradmin@localhost:6446 you can learn more ...
Read more