In this post we’ll cover step by step approach for
installing Golden Gate Software on both Windows based and Unix based operating
system. Below are some requirements that should be met before installing the
Golden Gate software:-
At least between 25 and 55 Mb of RAM memory is required for
each GoldenGate Replicat and Extract process. Oracle Goldengate supports up to
300 concurrent processes for Extract and Replicat per Goldengate instance. As a
rule of thumb, you will need to take into consideration that at least 1–2
Extract processes and multiple Replicat processes will be required in addition
to manager processes for a basic Oracle Goldengate installation. The best way
to assess total memory requirement is to run the GGSCI command to view the
current report file and to examine the PROCESS AVAIL VM FROM OS (min) to
determine if you have sufficient swap memory for your platform.
Disk Space Requirements
Following are some things you should do to ensure having
enough disk space to support your Goldengate replication needs:
• Allocate at least 50–150 MB of disk space for the Oracle
GoldenGate software binaries.
• Allocate 40 MB of disk space per instance of Goldengate
for working directories and files per server. For a basic configuration with
Oracle Goldengate, you will need to allocate 40 MB on the source and 40 MB on
the target system for a total requirement of 80 MB of disk space.
• Allocate sufficient disk space to temporary files to
accommodate GoldenGate operations. By default, Goldengate stores temporary
files in the dirtmp directory under the default installation directory. A good
rule of thumb to use for temp file space is around 10 GB of disk space.
• Plan on at least 10 MB per trail file. As a rule of thumb,
we recommend that you start with at least 1 GB of disk space allocated per
system for trail files. Alternatively, use the following formula that Oracle
provides to determine the amount of disk space to set aside:
[log volume in one hour] x [number of hours downtime] x 0.4
= trail disk space.
One way to calculate the total amount required for trail
file space is by querying the V$ARCHIVED_LOG view from within the source Oracle
database. The following query shows you how to do so:
select trunc(COMPLETION_TIME),count(*)*100 size_in_MB
from v$archived_log
group by trunc(COMPLETION_TIME);
TRUNC(COM SIZE_IN_MB
——— ———-
15-MAY-11 500
Run tests after installing Goldengate to measure your
specific transaction mix and
load, and to gauge the total disk space required for trail
files.
Network Requirements
Since Oracle Goldengate software operates between source and
target systems over networks, you must configure TCP/IP networking to
accommodate all hosts within DNS to include host names that will be included in
the Oracle Goldengate infrastructure deployed. In the event of firewalls, hosts
must be allowed to send and receive data for open ports that the manager,
Extract, and Replicat processes require access to in order to send and receive
data. This range of ports must be allocated for the Goldengate environments.
Also allocate ports for Goldengate manager, Extract, and Replicat processes. By
default, manager uses port 7840. The recommendation is that you keep this port
available. In addition, keep a record of ports allocated to Goldengate
processes to avoid port conflicts.
Operating System Requirements
Linux or UNIX:
• Grant read and write privileges for the operating system
(OS) account used to install the Oracle Goldengate software.
• Place the Oracle Goldengate software on a shared disk in a
clustered environment, or on a shared clustered filesystem that all cluster
nodes have access to.
• Install from an operating and database system account that
has read/write
Installation
I assume that you have downloaded the software by now, I
have downloaded Oracle GoldenGate V11.2.1.0.1 for Oracle 11g on Linux x86. Now
lets proceed with the installation:-
Step 1:- Create GoldenGate directory and copy the downloaded
file.
mkdir /u01/app/oracle/product/gg
cp V32409-01.zip /u01/app/oracle/product/gg/
cd /u01/app/oracle/product/gg/
Step 2:- Unzip the file.
unzip V32409-01.zip
ls -ltr
fbo_ggs_Linux_x86_ora11g_32bit.tar
Oracle GoldenGate 11.2.1.0.1 README.doc
V32409-01.zip
OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
Oracle GoldenGate 11.2.1.0.1 README.txt
Step 3:- Untar the following tar ball
tar -xf fbo_ggs_Linux_x86_ora11g_32bit.tar
ls
bcpfmt.tpl defgen libxml2.txt
bcrypt.txt demo_more_ora_create.sql logdump
cfg demo_more_ora_insert.sql marker_remove.sql
chkpt_ora_create.sql demo_ora_create.sql marker_setup.sql
cobgen demo_ora_insert.sql marker_status.sql
convchk demo_ora_lob_create.sql mgr
db2cntl.tpl demo_ora_misc.sql notices.txt
ddl_cleartrace.sql demo_ora_pk_befores_create.sql oggerr
ddlcob demo_ora_pk_befores_insert.sql
OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
ddl_ddl2file.sql demo_ora_pk_befores_updates.sql Oracle
GoldenGate 11.2.1.0.1 README.doc
ddl_disable.sql dirjar Oracle GoldenGate 11.2.1.0.1
README.txt
ddl_enable.sql dirprm params.sql
ddl_filter.sql emsclnt prvtclkm.plb
ddl_nopurgeRecyclebin.sql extract pw_agent_util.sh
ddl_ora10.sql fbo_ggs_Linux_x86_ora11g_32bit.tar remove_seq.sql
ddl_ora10upCommon.sql freeBSD.txt replicat
ddl_ora11.sql ggcmd retrace
ddl_ora9.sql ggMessage.dat reverse
ddl_pin.sql ggsci role_setup.sql
ddl_purgeRecyclebin.sql help.txt sequence.sql
ddl_remove.sql jagent.sh server
ddl_session1.sql keygen sqlldr.tpl
ddl_session.sql libantlr3c.so tcperrs
ddl_setup.sql libdb-5.2.so ucharset.h
ddl_status.sql libgglog.so ulg.sql
ddl_staymetadata_off.sql libggrepo.so UserExitExamples
ddl_staymetadata_on.sql libicudata.so.38 usrdecs.h
ddl_tracelevel.sql libicui18n.so.38 V32409-01.zip
ddl_trace_off.sql libicuuc.so.38 zlib.txt
ddl_trace_on.sql libxerces-c.so.28
Step 4:- Set the LD_LIBRARY_PATH variable as
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/gg
Step 5:- Run the GGSCI and create the subdirs
$ ./ggsci
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All
rights reserved.
GGSCI 1> create subdirs
Creating subdirectories under current directory
/u01/app/oracle/product/gg
Parameter files /u01/app/oracle/product/gg/dirprm: already
exists
Report files /u01/app/oracle/product/gg/dirrpt: created
Checkpoint files /u01/app/oracle/product/gg/dirchk: created
Process status files /u01/app/oracle/product/gg/dirpcs:
created
SQL script files /u01/app/oracle/product/gg/dirsql: created
Database definitions files
/u01/app/oracle/product/gg/dirdef: created
Extract data files /u01/app/oracle/product/gg/dirdat:
created
Temporary files /u01/app/oracle/product/gg/dirtmp: created
Stdout files /u01/app/oracle/product/gg/dirout: created
No comments:
Post a Comment