Saturday, 18 April 2015

Oracle Golden Gate installation step by step..

--- Oracle Golden Gate installation step by step..

-server information 

OS Version: 
[oracle@gg1 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[oracle@gg1 ~]$

Hostname:node1.example.com
Ip Address:192.168.0.100

1) create seprate folder for oracle GG_HOME

[oracle@gg1 gg]$ mkdir /u01/app/oracle/product/gg

[oracle@gg1 gg]$ chown -R oracle:oinstall /u01

[oracle@gg1 gg]$ chmod 775 /u01


2)copy oracle Golden Gate S/W to GG_HOME (/u01/app/oracle/product/gg)

-unzip oracle golden gate s/w

[oracle@gg1 gg]$tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

3)set oracle GG home parameter in user bash_profile,add below line in .bash_profile

[oracle@gg1 gg] vi .bash_profile

GG_HOME=/u01/app/oracle/product/gg; export GG_HOME

[oracle@gg1 gg] . .bash_profile

4) configure oracle GG 

[oracle@gg1 gg] cd $GG_HOME
[oracle@gg1 ~]$ pwd
/u01/app/oracle/product/gg

[oracle@gg1 gg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

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



GGSCI (gg1.example.com) 1>


-create subdirectory

GGSCI (gg1.example.com) 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: already exists
Checkpoint files               /u01/app/oracle/product/gg/dirchk: already exists
Process status files           /u01/app/oracle/product/gg/dirpcs: already exists
SQL script files               /u01/app/oracle/product/gg/dirsql: already exists
Database definitions files     /u01/app/oracle/product/gg/dirdef: already exists
Extract data files             /u01/app/oracle/product/gg/dirdat: already exists
Temporary files                /u01/app/oracle/product/gg/dirtmp: already exists
Stdout files                   /u01/app/oracle/product/gg/dirout: already exists

Note:- already I configured GG because of that it is showing directories are exists.


                --------------------END---------------






No comments:

Post a Comment

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...