SYED GOLDEN GATE INSTALLATION STEPS

login as: root
root@192.168.1.251's password:
Last login: Tue Apr  5 08:12:04 2016
[root@PrimeDG ~]# pwd
/root



[
[root@PrimeDG ~]# mkdir /syed
[root@PrimeDG ~]# cd /syed
[root@PrimeDG syed]# ls -altr
total 12
drwxr-xr-x 30 root root 4096 Apr 10 12:33 ..
drwxr-xr-x  2 root root 4096 Apr 10 12:33 .

[root@PrimeDG syed]# chown -R oracle:oinstall /syed
[root@PrimeDG syed]# chmod 775 /syed
[root@PrimeDG syed]# mkdir gg_home
[root@PrimeDG syed]#  chown -R oracle:oinstall gg_home/
[root@PrimeDG syed]# cd gg_home
[root@PrimeDG gg_home]# ls -altr
total 8
drwxrwxr-x 3 oracle oinstall 4096 Apr 10 12:35 ..
drwxr-xr-x 2 oracle oinstall 4096 Apr 10 12:35 .

[root@PrimeDG syed]# ls -altr /syed/gg_home
total 8
drwxrwxr-x 3 oracle oinstall 4096 Apr 10 12:35 ..
drwxrwxr-x 2 oracle oinstall 4096 Apr 10 12:35 .
[root@PrimeDG syed]# ls -altr
total 16
drwxr-xr-x 30 root   root     4096 Apr 10 12:33 ..
drwxrwxr-x  2 oracle oinstall 4096 Apr 10 12:35 gg_home
drwxrwxr-x  3 oracle oinstall 4096 Apr 10 12:35 .
[root@PrimeDG syed]# ls -ltr
total 4
drwxrwxr-x 2 oracle oinstall 4096 Apr 10 12:35 gg_home
[root@PrimeDG syed]# ls -altr
total 16
drwxr-xr-x 30 root   root     4096 Apr 10 12:33 ..
drwxrwxr-x  2 oracle oinstall 4096 Apr 10 12:35 gg_home
drwxrwxr-x  3 oracle oinstall 4096 Apr 10 12:35 .

[root@PrimeDG syed]# su - oracle
[oracle@PrimeDG ~]$ . oraenv
ORACLE_SID = [oracle] ? PrimeDG
The Oracle base for ORACLE_HOME=/u01/app/oracle/produc                                                                                            t/11.2.0/db_1 is /u01/app/oracle

[oracle@PrimeDG ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 10                                                                                             14:34:06 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved                                                                                            .

Connected to an idle instance.


SQL> startup;
ORACLE instance started.

Total System Global Area  726540288 bytes
Fixed Size                  2216904 bytes
Variable Size             545262648 bytes
Database Buffers          171966464 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.
SQL> !

[oracle@PrimeDG ~]$ cd /syed
[oracle@PrimeDG syed]$ ls -altr
total 16

-rw-r--r-- 1 root root 92569288 Apr 11 00:08 V34339-01.zip


[root@PrimeDG syed]# cd /syed
[root@PrimeDG syed]# ls -lrt
total 153460
-rw-r--r-- 1 root   root     64399077 Apr  8 22:46 V22230-01.zip
drwxrwxr-x 2 oracle oinstall     4096 Apr 10 12:35 gg_home
-rw-r--r-- 1 root   root     92569288 Apr 11 00:08 V34339-01.zip
[root@PrimeDG syed]# pwd
/syed
[root@PrimeDG syed]# pwd
/syed
[root@PrimeDG syed]# ls -lrt
total 153460
-rw-r--r-- 1 root   root     64399077 Apr  8 22:46 V22230-01.zip
drwxrwxr-x 2 oracle oinstall     4096 Apr 10 12:35 gg_home
-rw-r--r-- 1 root   root     92569288 Apr 11 00:08 V34339-01.zip

[root@PrimeDG syed]# chown oracle:oinstall V34339-01.zip
[root@PrimeDG syed]# ls -lrt
total 153460
-rw-r--r-- 1 root   root     64399077 Apr  8 22:46 V22230-01.zip
drwxrwxr-x 2 oracle oinstall     4096 Apr 10 12:35 gg_home
-rw-r--r-- 1 oracle oinstall 92569288 Apr 11 00:08 V34339-01.zip

[root@PrimeDG syed]# su - oracle
[oracle@PrimeDG ~]$ pwd
/home/oracle
[oracle@PrimeDG ~]$ ls -lrt
total 48
-rw-r--r-- 1 oracle oinstall 15607 Dec 31 15:23 db.rsp
drwxr-x--- 3 oracle oinstall  4096 Mar 28 15:35 oradiag_oracle
-rw-r--r-- 1 oracle oinstall  4242 Mar 29 11:53 ddl_list.sql
-rw-r--r-- 1 oracle oinstall 12288 Mar 29 15:11 schema.out
drwxr-xr-x 4 oracle oinstall  4096 Mar 30 19:29 scripts
drwxr-xr-x 4 oracle oinstall  4096 Apr 10 12:28 syed

[oracle@PrimeDG ~]$ cd ..
[oracle@PrimeDG home]$ pwd
/home
[oracle@PrimeDG home]$ ls -lrt
total 8
drwx------ 8 oracle oinstall 4096 Apr  5 08:02 oracle

[oracle@PrimeDG home]$ cd /syed
[oracle@PrimeDG syed]$ ls -lrt
total 153460
-rw-r--r-- 1 root   root     64399077 Apr  8 22:46 V22230-01.zip
drwxrwxr-x 2 oracle oinstall     4096 Apr 10 12:35 gg_home
-rw-r--r-- 1 oracle oinstall 92569288 Apr 11 00:08 V34339-01.zip

[oracle@PrimeDG syed]$ mv V34339-01.zip gg_home

[oracle@PrimeDG syed]$ cd gg_home

[oracle@PrimeDG gg_home]$ ls -lrt
total 90496
-rw-r--r-- 1 oracle oinstall 92569288 Apr 11 00:08 V34339-01.zip

[oracle@PrimeDG gg_home]$ unzip V34339-01.zip
Archive:  V34339-01.zip
  inflating: fbo_ggs_Linux_x64_ora11g_64bit.tar
  inflating: Oracle_GoldenGate_11.2.1.0.3_README.doc
  inflating: Oracle GoldenGate_11.2.1.0.3_README.txt
  inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.3.pdf
[oracle@PrimeDG gg_home]$ ls -lrt
total 324556
-rw-rw-r-- 1 oracle oinstall 239042560 Aug 23  2012 fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxrwxrwx 1 oracle oinstall     24514 Aug 29  2012 Oracle GoldenGate_11.2.1.0.3_README.txt
-rwxrwxrwx 1 oracle oinstall    270255 Aug 29  2012 OGG_WinUnix_Rel_Notes_11.2.1.0.3.pdf
-rwxrwxrwx 1 oracle oinstall     92672 Aug 29  2012 Oracle_GoldenGate_11.2.1.0.3_README.doc
-rw-r--r-- 1 oracle oinstall  92569288 Apr 11 00:08 V34339-01.zip

[oracle@PrimeDG gg_home]$ unzip fbo_ggs_Linux_x64_ora11g_64bit.tar

Archive:  fbo_ggs_Linux_x64_ora11g_64bit.tar
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of fbo_ggs_Linux_x64_ora11g_64bit.tar or
        fbo_ggs_Linux_x64_ora11g_64bit.tar.zip, and cannot find fbo_ggs_Linux_x64_ora11g_64bit.tar.ZIP, period.
[oracle@PrimeDG gg_home]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar
UserExitExamples/
UserExitExamples/ExitDemo_more_recs/
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
UserExitExamples/ExitDemo_more_recs/readme.txt
UserExitExamples/ExitDemo_passthru/
UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
UserExitExamples/ExitDemo_passthru/readme.txt
UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
UserExitExamples/ExitDemo_lobs/
UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
UserExitExamples/ExitDemo_lobs/readme.txt
UserExitExamples/ExitDemo_pk_befores/
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
UserExitExamples/ExitDemo_pk_befores/readme.txt
UserExitExamples/ExitDemo/
UserExitExamples/ExitDemo/exitdemo.vcproj
UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
UserExitExamples/ExitDemo/exitdemo.c
UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
UserExitExamples/ExitDemo/exitdemo_utf16.c
UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
UserExitExamples/ExitDemo/readme.txt
bcpfmt.tpl
bcrypt.txt
cfg/
cfg/password.properties
cfg/MPMetadataSchema.xsd
cfg/jps-config-jse.xml
cfg/ProfileConfig.xml
cfg/mpmetadata.xml
cfg/Config.properties
chkpt_ora_create.sql
cobgen
convchk
db2cntl.tpl
ddl_cleartrace.sql
ddl_ddl2file.sql
ddl_disable.sql
ddl_enable.sql
ddl_filter.sql
ddl_ora10.sql
ddl_ora10upCommon.sql
ddl_ora11.sql
ddl_ora9.sql
ddl_pin.sql
ddl_remove.sql
ddl_session.sql
ddl_session1.sql
ddl_setup.sql
ddl_status.sql
ddl_staymetadata_off.sql
ddl_staymetadata_on.sql
ddl_trace_off.sql
ddl_trace_on.sql
ddl_tracelevel.sql
ddlcob
defgen
demo_more_ora_create.sql
demo_more_ora_insert.sql
demo_ora_create.sql
demo_ora_insert.sql
demo_ora_lob_create.sql
demo_ora_misc.sql
demo_ora_pk_befores_create.sql
demo_ora_pk_befores_insert.sql
demo_ora_pk_befores_updates.sql
dirjar/
dirjar/xmlparserv2.jar
dirjar/fmw_audit.jar
dirjar/jps-internal.jar
dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar
dirjar/org.springframework.context-3.0.0.RELEASE.jar
dirjar/jps-upgrade.jar
dirjar/oraclepki.jar
dirjar/org.springframework.transaction-3.0.0.RELEASE.jar
dirjar/xstream-1.3.jar
dirjar/jsr250-api-1.0.jar
dirjar/org.springframework.beans-3.0.0.RELEASE.jar
dirjar/ldapjclnt11.jar
dirjar/spring-security-cas-client-3.0.1.RELEASE.jar
dirjar/jps-manifest.jar
dirjar/org.springframework.aspects-3.0.0.RELEASE.jar
dirjar/identityutils.jar
dirjar/org.springframework.aop-3.0.0.RELEASE.jar
dirjar/jacc-spi.jar
dirjar/jmxremote_optional-1.0-b02.jar
dirjar/slf4j-log4j12-1.4.3.jar
dirjar/jps-api.jar
dirjar/slf4j-api-1.4.3.jar
dirjar/identitystore.jar
dirjar/jps-unsupported-api.jar
dirjar/osdt_xmlsec.jar
dirjar/org.springframework.orm-3.0.0.RELEASE.jar
dirjar/jagent.jar
dirjar/commons-codec-1.3.jar
dirjar/jps-ee.jar
dirjar/spring-security-taglibs-3.0.1.RELEASE.jar
dirjar/log4j-1.2.15.jar
dirjar/osdt_core.jar
dirjar/spring-security-acl-3.0.1.RELEASE.jar
dirjar/xpp3_min-1.1.4c.jar
dirjar/spring-security-web-3.0.1.RELEASE.jar
dirjar/spring-security-core-3.0.1.RELEASE.jar
dirjar/spring-security-config-3.0.1.RELEASE.jar
dirjar/jps-mbeans.jar
dirjar/org.springframework.test-3.0.0.RELEASE.jar
dirjar/jdmkrt-1.0-b02.jar
dirjar/jps-common.jar
dirjar/org.springframework.web-3.0.0.RELEASE.jar
dirjar/jps-patching.jar
dirjar/jps-wls.jar
dirjar/commons-logging-1.0.4.jar
dirjar/org.springframework.expression-3.0.0.RELEASE.jar
dirjar/org.springframework.instrument-3.0.0.RELEASE.jar
dirjar/monitor-common.jar
dirjar/osdt_cert.jar
dirjar/org.springframework.asm-3.0.0.RELEASE.jar
dirjar/org.springframework.context.support-3.0.0.RELEASE.jar
dirjar/org.springframework.core-3.0.0.RELEASE.jar
dirprm/
dirprm/jagent.prm
emsclnt
extract
freeBSD.txt
ggMessage.dat
ggcmd
ggsci
help.txt
jagent.sh
keygen
libantlr3c.so
libdb-5.2.so
libgglog.so
libggrepo.so
libicudata.so.38
libicui18n.so.38
libicuuc.so.38
libxerces-c.so.28
libxml2.txt
logdump
marker_remove.sql
marker_setup.sql
marker_status.sql
mgr
notices.txt
oggerr
params.sql
prvtclkm.plb
pw_agent_util.sh
remove_seq.sql
replicat
retrace
reverse
role_setup.sql
sequence.sql
server
sqlldr.tpl
tcperrs
ucharset.h
ulg.sql
usrdecs.h
zlib.txt
[oracle@PrimeDG gg_home]$ l -lrt
-bash: l: command not found
[oracle@PrimeDG gg_home]$ ls -lrt
total 537988
-rw-r----- 1 oracle oinstall      1476 Oct 15  2010 zlib.txt
-rw-r----- 1 oracle oinstall       759 Oct 15  2010 tcperrs
-rw-r----- 1 oracle oinstall       248 Oct 15  2010 sqlldr.tpl
-rw-r----- 1 oracle oinstall      1668 Oct 15  2010 libxml2.txt
-rw-r----- 1 oracle oinstall      1968 Oct 15  2010 freeBSD.txt
-rw-r----- 1 oracle oinstall       159 Oct 15  2010 db2cntl.tpl
-rw-r----- 1 oracle oinstall      1725 Oct 15  2010 bcrypt.txt
-rw-r----- 1 oracle oinstall       426 Oct 15  2010 bcpfmt.tpl
-rw-r----- 1 oracle oinstall      1715 Oct 15  2010 marker_status.sql
-rw-r----- 1 oracle oinstall      2275 Oct 15  2010 demo_ora_misc.sql
-rw-r----- 1 oracle oinstall      4015 Oct 15  2010 demo_ora_lob_create.sql
-rw-r----- 1 oracle oinstall       821 Oct 15  2010 demo_ora_insert.sql
-rw-r----- 1 oracle oinstall       883 Oct 15  2010 demo_ora_create.sql
-rw-r----- 1 oracle oinstall      2862 Oct 15  2010 ddl_trace_on.sql
-rw-r----- 1 oracle oinstall      2955 Oct 15  2010 ddl_tracelevel.sql
-rw-r----- 1 oracle oinstall      2501 Oct 15  2010 ddl_staymetadata_on.sql
-rw-r----- 1 oracle oinstall      2506 Oct 15  2010 ddl_staymetadata_off.sql
-rw-r----- 1 oracle oinstall      1026 Oct 15  2010 ddl_pin.sql
-rw-r----- 1 oracle oinstall       692 Oct 15  2010 ddl_enable.sql
-rw-r----- 1 oracle oinstall       746 Oct 15  2010 ddl_disable.sql
-rw-r----- 1 oracle oinstall      4189 Oct 15  2010 ddl_ddl2file.sql
-rw-r----- 1 oracle oinstall      1059 Oct 15  2010 ddl_cleartrace.sql
-rw-r----- 1 oracle oinstall      2520 Oct 15  2010 demo_ora_pk_befores_updates.sql
-rw-r----- 1 oracle oinstall      1227 Oct 15  2010 demo_ora_pk_befores_insert.sql
-rw-r----- 1 oracle oinstall      1269 Oct 15  2010 demo_ora_pk_befores_create.sql
-rw-r----- 1 oracle oinstall       967 Oct 15  2010 demo_more_ora_insert.sql
-rw-r----- 1 oracle oinstall      1217 Oct 15  2010 demo_more_ora_create.sql
-rw-r----- 1 oracle oinstall      1053 Oct 15  2010 ddl_session.sql
-rw-r----- 1 oracle oinstall       425 Oct 15  2010 ddl_session1.sql
-rw-r----- 1 oracle oinstall      1272 Dec 28  2010 prvtclkm.plb
-rw-r----- 1 oracle oinstall      2721 Dec 28  2010 ddl_trace_off.sql
-rw-r----- 1 oracle oinstall      4375 Apr  7  2011 role_setup.sql
-rw-r----- 1 oracle oinstall      2393 Apr  7  2011 remove_seq.sql
-rw-r----- 1 oracle oinstall      3824 Aug  9  2011 marker_setup.sql
-rw-r----- 1 oracle oinstall      2278 Aug  9  2011 marker_remove.sql
-rw-r----- 1 oracle oinstall      4138 Aug  9  2011 ddl_remove.sql
-rw-r----- 1 oracle oinstall      3167 Aug 29  2011 ddl_ora10upCommon.sql
-rw-r----- 1 oracle oinstall      3518 Oct 13  2011 ddl_filter.sql
-rw-r----- 1 oracle oinstall     34564 Nov 15  2011 sequence.sql
-rw-r----- 1 oracle oinstall     14051 Dec 14  2011 ddl_ora9.sql
-rw-r----- 1 oracle oinstall     14358 Dec 14  2011 ddl_ora11.sql
-rw-r----- 1 oracle oinstall    213535 Jan 18  2012 notices.txt
-rw-r----- 1 oracle oinstall     10506 Feb 27  2012 ddl_status.sql
-rw-r----- 1 oracle oinstall      1285 Feb 28  2012 chkpt_ora_create.sql
-rw-r----- 1 oracle oinstall     16763 Mar  2  2012 ucharset.h
-rwxr-x--- 1 oracle oinstall   1829888 May 18  2012 libdb-5.2.so
-rwxr-x--- 1 oracle oinstall    113969 May 18  2012 libantlr3c.so
-rwxr-x--- 1 oracle oinstall   4034679 May 18  2012 libicuuc.so.38
-rwxr-x--- 1 oracle oinstall   5359083 May 18  2012 libicui18n.so.38
-rwxr-x--- 1 oracle oinstall  15581892 May 18  2012 libicudata.so.38
-rwxr-x--- 1 oracle oinstall   5323945 May 18  2012 libxerces-c.so.28
-rw-r----- 1 oracle oinstall     28319 Jun 14  2012 usrdecs.h
-rw-r----- 1 oracle oinstall      5660 Jun 15  2012 params.sql
-rw-r----- 1 oracle oinstall     13647 Jun 15  2012 ddl_ora10.sql
-rw-r----- 1 oracle oinstall    170398 Jul 23  2012 help.txt
-rw-r----- 1 oracle oinstall      6760 Jul 31  2012 ulg.sql
-rw-r----- 1 oracle oinstall    303542 Aug  1  2012 ddl_setup.sql
drwxr-x--- 7 oracle oinstall      4096 Aug 23  2012 UserExitExamples
-rw-r----- 1 oracle oinstall   1280336 Aug 23  2012 ggMessage.dat
-rwxr-x--- 1 oracle oinstall  10778848 Aug 23  2012 mgr
-rwxr-x--- 1 oracle oinstall   6577392 Aug 23  2012 ggcmd
drwxr-x--- 2 oracle oinstall      4096 Aug 23  2012 cfg
-rwxr-x--- 1 oracle oinstall      1015 Aug 23  2012 pw_agent_util.sh
-rwxr-x--- 1 oracle oinstall       406 Aug 23  2012 jagent.sh
drwxr-x--- 2 oracle oinstall      4096 Aug 23  2012 dirprm
drwxr-x--- 2 oracle oinstall      4096 Aug 23  2012 dirjar
-rwxr-x--- 1 oracle oinstall   6005309 Aug 23  2012 cobgen
-rwxr-x--- 1 oracle oinstall   6303856 Aug 23  2012 ddlcob
-rwxr-x--- 1 oracle oinstall   6647014 Aug 23  2012 emsclnt
-rwxr-x--- 1 oracle oinstall    383299 Aug 23  2012 keygen
-rwxr-x--- 1 oracle oinstall   7277838 Aug 23  2012 logdump
-rwxr-x--- 1 oracle oinstall   5198770 Aug 23  2012 retrace
-rwxr-x--- 1 oracle oinstall   5178282 Aug 23  2012 oggerr
-rwxr-x--- 1 oracle oinstall    763004 Aug 23  2012 reverse
-rwxr-x--- 1 oracle oinstall  13757119 Aug 23  2012 server
-rwxr-x--- 1 oracle oinstall   5799420 Aug 23  2012 convchk
-rwxr-x--- 1 oracle oinstall   9678554 Aug 23  2012 defgen
-rwxr-x--- 1 oracle oinstall  13899588 Aug 23  2012 ggsci
-rwxr-x--- 1 oracle oinstall  41952307 Aug 23  2012 extract
-rwxr-x--- 1 oracle oinstall   7761420 Aug 23  2012 libgglog.so
-rwxr-x--- 1 oracle oinstall   2085004 Aug 23  2012 libggrepo.so
-rwxr-x--- 1 oracle oinstall  33525241 Aug 23  2012 replicat
-rw-rw-r-- 1 oracle oinstall 239042560 Aug 23  2012 fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxrwxrwx 1 oracle oinstall     24514 Aug 29  2012 Oracle GoldenGate_11.2.1.0.3_README.txt
-rwxrwxrwx 1 oracle oinstall    270255 Aug 29  2012 OGG_WinUnix_Rel_Notes_11.2.1.0.3.pdf
-rwxrwxrwx 1 oracle oinstall     92672 Aug 29  2012 Oracle_GoldenGate_11.2.1.0.3_README.doc
-rw-r--r-- 1 oracle oinstall  92569288 Apr 11 00:08 V34339-01.zip

[oracle@PrimeDG gg_home]$ pwd
/syed/gg_home


[oracle@PrimeDG gg_home]$ ./ggsci
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

[oracle@PrimeDG gg_home]$ ps -ef | grep smon
oracle    7664     1  0 Apr10 ?        00:00:04 ora_smon_PrimeDG
oracle   16984 16878  0 00:13 pts/1    00:00:00 grep smon
[oracle@PrimeDG gg_home]$ . oraenv PrimeDG
ORACLE_SID = [oracle] ? PrimeDG
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle

[oracle@PrimeDG gg_home]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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



GGSCI (PrimeDG) 1> help


GGSCI Command Summary:

Object:          Command:
SUBDIRS          CREATE
ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
                 LAG, REGISTER, SEND, START, STATS, STATUS, STOP
                 UNREGISTER
EXTTRAIL         ADD, ALTER, DELETE, INFO
GGSEVT           VIEW
MANAGER          INFO, SEND, START, STOP, STATUS
MARKER           INFO
PARAMS           EDIT, VIEW
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
                 START, STATS, STATUS, STOP
REPORT           VIEW
RMTTRAIL         ADD, ALTER, DELETE, INFO
TRACETABLE       ADD, DELETE, INFO
TRANDATA         ADD, DELETE, INFO
SCHEMATRANDATA   ADD, DELETE, INFO
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO

Commands without an object:
(Database)       DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
                 MININGDBLOGIN
(DDL)            DUMPDDL
(Miscellaneous)  FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
                 SHOW, VERSIONS, ! (note: you must type the word
                 COMMAND after the ! to display the ! help topic.)
                 i.e.: GGSCI (sys1)> help ! command



For help on a specific command, type HELP <command> <object>.

Example: HELP ADD REPLICAT

GGSCI (PrimeDG) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED


GGSCI (PrimeDG) 3> create subdirs

Creating subdirectories under current directory /syed/gg_home

Parameter files                /syed/gg_home/dirprm: already exists
Report files                   /syed/gg_home/dirrpt: created
Checkpoint files               /syed/gg_home/dirchk: created
Process status files           /syed/gg_home/dirpcs: created
SQL script files               /syed/gg_home/dirsql: created
Database definitions files     /syed/gg_home/dirdef: created
Extract data files             /syed/gg_home/dirdat: created
Temporary files                /syed/gg_home/dirtmp: created
Stdout files                   /syed/gg_home/dirout: created


GGSCI (PrimeDG) 4> start manager
ERROR: Parameter file /syed/gg_home/dirprm/mgr.prm does not exist.


GGSCI (PrimeDG) 5> edit params  mgr



GGSCI (PrimeDG) 6> start manager

Manager started.


GGSCI (PrimeDG) 7> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING


GGSCI (PrimeDG) 8> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.


GGSCI (PrimeDG) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED


GGSCI (PrimeDG) 10> start mgr

Manager started.


GGSCI (PrimeDG) 11> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.


GGSCI (PrimeDG) 12> edit params mgr




GGSCI (PrimeDG) 14> start manager

Manager started.


GGSCI (PrimeDG) 15> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING



GGSCI (PrimeDG) 17> info mgr, detail

Manager is running (IP port PrimeDG.7810).


GGSCI (PrimeDG) 18> exit
[oracle@PrimeDG gg_home]$ pwd
/syed/gg_home
[oracle@PrimeDG gg_home]$ ls -lrt ./dirprm
total 8
-rwxr-x--- 1 oracle oinstall 53 Aug 23  2012 jagent.prm
-rw-rw-rw- 1 oracle oinstall 11 Apr 11 00:15 mgr.prm
[oracle@PrimeDG gg_home]$ more ./dirprm/mgr.prm
PORT 7810

[oracle@PrimeDG gg_home]$ pwd
/syed/gg_home
[oracle@PrimeDG gg_home]$ ls -lrt
total 538024
-rw-r----- 1 oracle oinstall      1476 Oct 15  2010 zlib.txt
-rw-r----- 1 oracle oinstall       759 Oct 15  2010 tcperrs
-rw-r----- 1 oracle oinstall       248 Oct 15  2010 sqlldr.tpl
-rw-r----- 1 oracle oinstall      1668 Oct 15  2010 libxml2.txt
-rw-r----- 1 oracle oinstall      1968 Oct 15  2010 freeBSD.txt
-rw-r----- 1 oracle oinstall       159 Oct 15  2010 db2cntl.tpl
-rw-r----- 1 oracle oinstall      1725 Oct 15  2010 bcrypt.txt
-rw-r----- 1 oracle oinstall       426 Oct 15  2010 bcpfmt.tpl
-rw-r----- 1 oracle oinstall      1715 Oct 15  2010 marker_status.sql
-rw-r----- 1 oracle oinstall      2275 Oct 15  2010 demo_ora_misc.sql
-rw-r----- 1 oracle oinstall      4015 Oct 15  2010 demo_ora_lob_create.sql
-rw-r----- 1 oracle oinstall       821 Oct 15  2010 demo_ora_insert.sql
-rw-r----- 1 oracle oinstall       883 Oct 15  2010 demo_ora_create.sql
-rw-r----- 1 oracle oinstall      2862 Oct 15  2010 ddl_trace_on.sql
-rw-r----- 1 oracle oinstall      2955 Oct 15  2010 ddl_tracelevel.sql
-rw-r----- 1 oracle oinstall      2501 Oct 15  2010 ddl_staymetadata_on.sql
-rw-r----- 1 oracle oinstall      2506 Oct 15  2010 ddl_staymetadata_off.sql
-rw-r----- 1 oracle oinstall      1026 Oct 15  2010 ddl_pin.sql
-rw-r----- 1 oracle oinstall       692 Oct 15  2010 ddl_enable.sql
-rw-r----- 1 oracle oinstall       746 Oct 15  2010 ddl_disable.sql
-rw-r----- 1 oracle oinstall      4189 Oct 15  2010 ddl_ddl2file.sql
-rw-r----- 1 oracle oinstall      1059 Oct 15  2010 ddl_cleartrace.sql
-rw-r----- 1 oracle oinstall      2520 Oct 15  2010 demo_ora_pk_befores_updates.sql
-rw-r----- 1 oracle oinstall      1227 Oct 15  2010 demo_ora_pk_befores_insert.sql
-rw-r----- 1 oracle oinstall      1269 Oct 15  2010 demo_ora_pk_befores_create.sql
-rw-r----- 1 oracle oinstall       967 Oct 15  2010 demo_more_ora_insert.sql
-rw-r----- 1 oracle oinstall      1217 Oct 15  2010 demo_more_ora_create.sql
-rw-r----- 1 oracle oinstall      1053 Oct 15  2010 ddl_session.sql
-rw-r----- 1 oracle oinstall       425 Oct 15  2010 ddl_session1.sql
-rw-r----- 1 oracle oinstall      1272 Dec 28  2010 prvtclkm.plb
-rw-r----- 1 oracle oinstall      2721 Dec 28  2010 ddl_trace_off.sql
-rw-r----- 1 oracle oinstall      4375 Apr  7  2011 role_setup.sql
-rw-r----- 1 oracle oinstall      2393 Apr  7  2011 remove_seq.sql
-rw-r----- 1 oracle oinstall      3824 Aug  9  2011 marker_setup.sql
-rw-r----- 1 oracle oinstall      2278 Aug  9  2011 marker_remove.sql
-rw-r----- 1 oracle oinstall      4138 Aug  9  2011 ddl_remove.sql
-rw-r----- 1 oracle oinstall      3167 Aug 29  2011 ddl_ora10upCommon.sql
-rw-r----- 1 oracle oinstall      3518 Oct 13  2011 ddl_filter.sql
-rw-r----- 1 oracle oinstall     34564 Nov 15  2011 sequence.sql
-rw-r----- 1 oracle oinstall     14051 Dec 14  2011 ddl_ora9.sql
-rw-r----- 1 oracle oinstall     14358 Dec 14  2011 ddl_ora11.sql
-rw-r----- 1 oracle oinstall    213535 Jan 18  2012 notices.txt
-rw-r----- 1 oracle oinstall     10506 Feb 27  2012 ddl_status.sql
-rw-r----- 1 oracle oinstall      1285 Feb 28  2012 chkpt_ora_create.sql
-rw-r----- 1 oracle oinstall     16763 Mar  2  2012 ucharset.h
-rwxr-x--- 1 oracle oinstall   1829888 May 18  2012 libdb-5.2.so
-rwxr-x--- 1 oracle oinstall    113969 May 18  2012 libantlr3c.so
-rwxr-x--- 1 oracle oinstall   4034679 May 18  2012 libicuuc.so.38
-rwxr-x--- 1 oracle oinstall   5359083 May 18  2012 libicui18n.so.38
-rwxr-x--- 1 oracle oinstall  15581892 May 18  2012 libicudata.so.38
-rwxr-x--- 1 oracle oinstall   5323945 May 18  2012 libxerces-c.so.28
-rw-r----- 1 oracle oinstall     28319 Jun 14  2012 usrdecs.h
-rw-r----- 1 oracle oinstall      5660 Jun 15  2012 params.sql
-rw-r----- 1 oracle oinstall     13647 Jun 15  2012 ddl_ora10.sql
-rw-r----- 1 oracle oinstall    170398 Jul 23  2012 help.txt
-rw-r----- 1 oracle oinstall      6760 Jul 31  2012 ulg.sql
-rw-r----- 1 oracle oinstall    303542 Aug  1  2012 ddl_setup.sql
drwxr-x--- 7 oracle oinstall      4096 Aug 23  2012 UserExitExamples
-rw-r----- 1 oracle oinstall   1280336 Aug 23  2012 ggMessage.dat
-rwxr-x--- 1 oracle oinstall  10778848 Aug 23  2012 mgr
-rwxr-x--- 1 oracle oinstall   6577392 Aug 23  2012 ggcmd
drwxr-x--- 2 oracle oinstall      4096 Aug 23  2012 cfg
-rwxr-x--- 1 oracle oinstall      1015 Aug 23  2012 pw_agent_util.sh
-rwxr-x--- 1 oracle oinstall       406 Aug 23  2012 jagent.sh
drwxr-x--- 2 oracle oinstall      4096 Aug 23  2012 dirjar
-rwxr-x--- 1 oracle oinstall   6005309 Aug 23  2012 cobgen
-rwxr-x--- 1 oracle oinstall   6303856 Aug 23  2012 ddlcob
-rwxr-x--- 1 oracle oinstall   6647014 Aug 23  2012 emsclnt
-rwxr-x--- 1 oracle oinstall    383299 Aug 23  2012 keygen
-rwxr-x--- 1 oracle oinstall   7277838 Aug 23  2012 logdump
-rwxr-x--- 1 oracle oinstall   5198770 Aug 23  2012 retrace
-rwxr-x--- 1 oracle oinstall   5178282 Aug 23  2012 oggerr
-rwxr-x--- 1 oracle oinstall    763004 Aug 23  2012 reverse
-rwxr-x--- 1 oracle oinstall  13757119 Aug 23  2012 server
-rwxr-x--- 1 oracle oinstall   5799420 Aug 23  2012 convchk
-rwxr-x--- 1 oracle oinstall   9678554 Aug 23  2012 defgen
-rwxr-x--- 1 oracle oinstall  13899588 Aug 23  2012 ggsci
-rwxr-x--- 1 oracle oinstall  41952307 Aug 23  2012 extract
-rwxr-x--- 1 oracle oinstall   7761420 Aug 23  2012 libgglog.so
-rwxr-x--- 1 oracle oinstall   2085004 Aug 23  2012 libggrepo.so
-rwxr-x--- 1 oracle oinstall  33525241 Aug 23  2012 replicat
-rw-rw-r-- 1 oracle oinstall 239042560 Aug 23  2012 fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxrwxrwx 1 oracle oinstall     24514 Aug 29  2012 Oracle GoldenGate_11.2.1.0.3_README.txt
-rwxrwxrwx 1 oracle oinstall    270255 Aug 29  2012 OGG_WinUnix_Rel_Notes_11.2.1.0.3.pdf
-rwxrwxrwx 1 oracle oinstall     92672 Aug 29  2012 Oracle_GoldenGate_11.2.1.0.3_README.doc
-rw-r--r-- 1 oracle oinstall  92569288 Apr 11 00:08 V34339-01.zip
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirtmp
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirsql
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirout
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirdef
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirdat
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:13 dirchk
drwxr-x--- 2 oracle oinstall      4096 Apr 11 00:15 dirprm
-rw-rw-rw- 1 oracle oinstall      1924 Apr 11 00:15 ggserr.log
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:15 dirrpt
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 00:15 dirpcs
[oracle@PrimeDG gg_home]$ more ggserr.log
2016-04-11 00:13:56  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2016-04-11 00:14:08  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params  mgr.
2016-04-11 00:14:15  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2016-04-11 00:14:15  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2016-04-11 00:14:37  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop mgr.
2016-04-11 00:14:39  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host PrimeDG:42000 (STOP).
2016-04-11 00:14:39  WARNING OGG-00938  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager is stopping at user request.
2016-04-11 00:14:47  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2016-04-11 00:14:47  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2016-04-11 00:14:53  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop mgr.
2016-04-11 00:14:54  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host PrimeDG:42002 (STOP).
2016-04-11 00:14:54  WARNING OGG-00938  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager is stopping at user request.
2016-04-11 00:15:03  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params mgr.
2016-04-11 00:15:24  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2016-04-11 00:15:24  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7810).
[oracle@PrimeDG gg_home]$

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


INSTALLING GOLDEN GATE ON TARGET DATABASE

FROM SOURCE COPY SOFTWARE TO TARGET DATABASE

[oracle@PrimeDG gg_home]$ scp fbo_ggs_Linux_x64_ora11g_64bit.tar oracle@192.168.1.253:/syed/gg_home

oracle@192.168.1.253's password:
fbo_ggs_Linux_x64_ora11g_64bit.tar                                                                              100%  228MB  10.4MB/s   00:22
[oracle@PrimeDG gg_home]$

now on target database unzip software

login as: root

root@192.168.1.253's password:

Access denied

root@192.168.1.253's password:

Last login: Mon Mar 28 16:31:54 2016

[root@CyclopDB ~]# mkdir -p /syed/gg_home

[root@CyclopDB ~]# chown oracle:oinstall /syed/gg_home

[root@CyclopDB ~]# chmod 775 /syed/gg_home

[root@CyclopDB ~]# su - oracle

[oracle@CyclopDB gg_home]$ ls -altr
total 233680
drwxr-xr-x 3 root   root          4096 Apr 11 20:12 ..
drwxrwxr-x 2 oracle oinstall      4096 Apr 11 20:21 .
-rw-r--r-- 1 oracle oinstall 239042560 Apr 11 20:22 fbo_ggs_Linux_x64_ora11g_64bit.tar



[oracle@CyclopDB gg_home]$ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar
UserExitExamples/
UserExitExamples/ExitDemo_more_recs/
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
UserExitExamples/ExitDemo_more_recs/readme.txt
UserExitExamples/ExitDemo_passthru/
UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
UserExitExamples/ExitDemo_passthru/readme.txt
UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
UserExitExamples/ExitDemo_lobs/
UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
UserExitExamples/ExitDemo_lobs/readme.txt
UserExitExamples/ExitDemo_pk_befores/
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
UserExitExamples/ExitDemo_pk_befores/readme.txt
UserExitExamples/ExitDemo/
UserExitExamples/ExitDemo/exitdemo.vcproj
UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
UserExitExamples/ExitDemo/exitdemo.c
UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
UserExitExamples/ExitDemo/exitdemo_utf16.c
UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
UserExitExamples/ExitDemo/readme.txt
bcpfmt.tpl
bcrypt.txt
cfg/
cfg/password.properties
cfg/MPMetadataSchema.xsd
cfg/jps-config-jse.xml
cfg/ProfileConfig.xml
cfg/mpmetadata.xml
cfg/Config.properties
chkpt_ora_create.sql
cobgen
convchk
db2cntl.tpl
ddl_cleartrace.sql
ddl_ddl2file.sql
ddl_disable.sql
ddl_enable.sql
ddl_filter.sql
ddl_ora10.sql
ddl_ora10upCommon.sql
ddl_ora11.sql
ddl_ora9.sql
ddl_pin.sql
ddl_remove.sql
ddl_session.sql
ddl_session1.sql
ddl_setup.sql
ddl_status.sql
ddl_staymetadata_off.sql
ddl_staymetadata_on.sql
ddl_trace_off.sql
ddl_trace_on.sql
ddl_tracelevel.sql
ddlcob
defgen
demo_more_ora_create.sql
demo_more_ora_insert.sql
demo_ora_create.sql
demo_ora_insert.sql
demo_ora_lob_create.sql
demo_ora_misc.sql
demo_ora_pk_befores_create.sql
demo_ora_pk_befores_insert.sql
demo_ora_pk_befores_updates.sql
dirjar/
dirjar/xmlparserv2.jar
dirjar/fmw_audit.jar
dirjar/jps-internal.jar
dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar
dirjar/org.springframework.context-3.0.0.RELEASE.jar
dirjar/jps-upgrade.jar
dirjar/oraclepki.jar
dirjar/org.springframework.transaction-3.0.0.RELEASE.jar
dirjar/xstream-1.3.jar
dirjar/jsr250-api-1.0.jar
dirjar/org.springframework.beans-3.0.0.RELEASE.jar
dirjar/ldapjclnt11.jar
dirjar/spring-security-cas-client-3.0.1.RELEASE.jar
dirjar/jps-manifest.jar
dirjar/org.springframework.aspects-3.0.0.RELEASE.jar
dirjar/identityutils.jar
dirjar/org.springframework.aop-3.0.0.RELEASE.jar
dirjar/jacc-spi.jar
dirjar/jmxremote_optional-1.0-b02.jar
dirjar/slf4j-log4j12-1.4.3.jar
dirjar/jps-api.jar
dirjar/slf4j-api-1.4.3.jar
dirjar/identitystore.jar
dirjar/jps-unsupported-api.jar
dirjar/osdt_xmlsec.jar
dirjar/org.springframework.orm-3.0.0.RELEASE.jar
dirjar/jagent.jar
dirjar/commons-codec-1.3.jar
dirjar/jps-ee.jar
dirjar/spring-security-taglibs-3.0.1.RELEASE.jar
dirjar/log4j-1.2.15.jar
dirjar/osdt_core.jar
dirjar/spring-security-acl-3.0.1.RELEASE.jar
dirjar/xpp3_min-1.1.4c.jar
dirjar/spring-security-web-3.0.1.RELEASE.jar
dirjar/spring-security-core-3.0.1.RELEASE.jar
dirjar/spring-security-config-3.0.1.RELEASE.jar
dirjar/jps-mbeans.jar
dirjar/org.springframework.test-3.0.0.RELEASE.jar
dirjar/jdmkrt-1.0-b02.jar
dirjar/jps-common.jar
dirjar/org.springframework.web-3.0.0.RELEASE.jar
dirjar/jps-patching.jar
dirjar/jps-wls.jar
dirjar/commons-logging-1.0.4.jar
dirjar/org.springframework.expression-3.0.0.RELEASE.jar
dirjar/org.springframework.instrument-3.0.0.RELEASE.jar
dirjar/monitor-common.jar
dirjar/osdt_cert.jar
dirjar/org.springframework.asm-3.0.0.RELEASE.jar
dirjar/org.springframework.context.support-3.0.0.RELEASE.jar
dirjar/org.springframework.core-3.0.0.RELEASE.jar
dirprm/
dirprm/jagent.prm
emsclnt
extract
freeBSD.txt
ggMessage.dat
ggcmd
ggsci
help.txt
jagent.sh
keygen
libantlr3c.so
libdb-5.2.so
libgglog.so
libggrepo.so
libicudata.so.38
libicui18n.so.38
libicuuc.so.38
libxerces-c.so.28
libxml2.txt
logdump
marker_remove.sql
marker_setup.sql
marker_status.sql
mgr
notices.txt
oggerr
params.sql
prvtclkm.plb
pw_agent_util.sh
remove_seq.sql
replicat
retrace
reverse
role_setup.sql
sequence.sql
server
sqlldr.tpl
tcperrs
ucharset.h
ulg.sql
usrdecs.h
zlib.txt
[oracle@CyclopDB gg_home]$ pwd
/syed/gg_home
[oracle@CyclopDB gg_home]$  ./ggsci
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object f such file or directory
[oracle@CyclopDB gg_home]$ ps -ef | grep smon
oracle    4846  4768  0 20:27 pts/1    00:00:00 grep smon
[oracle@CyclopDB gg_home]$  . oraenv
ORACLE_SID = [oracle] ? CyclopDB
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@CyclopDB gg_home]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 11 20:27:52 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area  726540288 bytes
Fixed Size                  2216904 bytes
Variable Size             541068344 bytes
Database Buffers          176160768 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.
SQL> !
[oracle@CyclopDB gg_home]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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



GGSCI (CyclopDB) 1> help


GGSCI Command Summary:

Object:          Command:
SUBDIRS          CREATE
ER               INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP
EXTRACT          ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
                 LAG, REGISTER, SEND, START, STATS, STATUS, STOP
                 UNREGISTER
EXTTRAIL         ADD, ALTER, DELETE, INFO
GGSEVT           VIEW
MANAGER          INFO, SEND, START, STOP, STATUS
MARKER           INFO
PARAMS           EDIT, VIEW
REPLICAT         ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND,
                 START, STATS, STATUS, STOP
REPORT           VIEW
RMTTRAIL         ADD, ALTER, DELETE, INFO
TRACETABLE       ADD, DELETE, INFO
TRANDATA         ADD, DELETE, INFO
SCHEMATRANDATA   ADD, DELETE, INFO
CHECKPOINTTABLE  ADD, DELETE, CLEANUP, INFO

Commands without an object:
(Database)       DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE
                 MININGDBLOGIN
(DDL)            DUMPDDL
(Miscellaneous)  FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL,
                 SHOW, VERSIONS, ! (note: you must type the word
                 COMMAND after the ! to display the ! help topic.)
                 i.e.: GGSCI (sys1)> help ! command



For help on a specific command, type HELP <command> <object>.

Example: HELP ADD REPLICAT

GGSCI (CyclopDB) 2> create subdirs

Creating subdirectories under current directory /syed/gg_home

Parameter files                /syed/gg_home/dirprm: already exists
Report files                   /syed/gg_home/dirrpt: created
Checkpoint files               /syed/gg_home/dirchk: created
Process status files           /syed/gg_home/dirpcs: created
SQL script files               /syed/gg_home/dirsql: created
Database definitions files     /syed/gg_home/dirdef: created
Extract data files             /syed/gg_home/dirdat: created
Temporary files                /syed/gg_home/dirtmp: created
Stdout files                   /syed/gg_home/dirout: created


GGSCI (CyclopDB) 3>  edit params  mgr



GGSCI (CyclopDB) 4> start manager

Manager started.


GGSCI (CyclopDB) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

=======================================================================
PREPARING SOURCE DATABASE FOR GOLDEN GATE

[oracle@PrimeDG gg_home]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 11 21:04:25 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     73
Next log sequence to archive   75
Current log sequence           75
SQL> Select supplemental_log_data_min from v$database;

SUPPLEME
--------
NO

SQL> alter database add  supplemental log data;

Database altered.

SQL> Select supplemental_log_data_min from v$database;

SUPPLEME
--------
YES




SQL> create user ggadmin identified by india123;

User created.

SQL> grant dba to ggadmin ;

Grant succeeded.

SQL> grant connect,resource to ggadmin ;

Grant succeeded.

SQL> grant select any dictionary, select any table to  ggadmin ;

Grant succeeded.




SQL> grant flashback any table to ggadmin ;

Grant succeeded.

SQL> grant execute on dbms_flashback to ggadmin ;

Grant succeeded.

SQL>  grant execute on utl_file to ggadmin ;

Grant succeeded.

SQL> create user syed identified by india123;

User created.

SQL> grant connect, resource to syed;

Grant succeeded.

SQL> connect syed/india123
Connected.

SQL> create table mytab (id integer, name varchar2(100));

Table created.

SQL> alter table mytab add primary key (id);

Table altered.

SQL> create table mytab2 (id integer, name varchar2(200));

Table created.

SQL> alter table  mytab2 add primary key (id);

Table altered.

SQL> alter table mytab2 add supplemental log group ggs_mytab2_log(id);

Table altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@PrimeDG gg_home]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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



GGSCI (PrimeDG) 1> dblogin userid ggadmin password india123
Successfully logged into database.



GGSCI (PrimeDG) 6> add  trandata syed.mytab

Logging of supplemental redo data enabled for table SYED.MYTAB.

GGSCI (PrimeDG) 7>

PREPARING TARGET DATABASE FOR GOLDEN CONFIGURATION


[oracle@CyclopDB gg_home]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 12 13:43:20 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     14
Next log sequence to archive   16
Current log sequence           16
SQL> Select supplemental_log_data_min from v$database;

SUPPLEME
--------
NO

SQL> alter database add  supplemental log data;

Database altered.

SQL> Select supplemental_log_data_min from v$database;

SUPPLEME
--------
YES

SQL> create user ggadmin identified by india123;

User created.

SQL> grant dba to ggadmin ;

Grant succeeded.

SQL> grant connect,resource to ggadmin ;

Grant succeeded.

SQL> grant select any dictionary, select any table to  ggadmin ;

Grant succeeded.

SQL>  grant flashback any table to ggadmin ;

Grant succeeded.

SQL> grant execute on dbms_flashback to ggadmin ;

Grant succeeded.

SQL> grant execute on utl_file to ggadmin ;

Grant succeeded.

SQL> create user syed identified by india123;

User created.


SQL>  grant connect, resource to syed;

Grant succeeded.

SQL> connect syed/india123
Connected.
SQL>  create table mytab (id integer, name varchar2(100));

Table created.

SQL>  alter table mytab add primary key (id);

Table altered.

SQL>  create table mytab2 (id integer, name varchar2(200));

Table created.

SQL>  alter table  mytab2 add primary key (id);

Table altered.

SQL> alter table mytab2 add supplemental log group ggs_mytab2_log(id);

Table altered.

SQL>  exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@CyclopDB gg_home]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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



GGSCI (CyclopDB) 1> dblogin userid ggadmin password india123
Successfully logged into database.

GGSCI (CyclopDB) 2> add  trandata syed.mytab

Logging of supplemental redo data enabled for table SYED.MYTAB.

GGSCI (CyclopDB) 3>

GGSCI (CyclopDB) 3> add  trandata syed.*

Logging of supplemental redo log data is already enabled for table SYED.MYTAB.

Logging of supplemental redo data enabled for table SYED.MYTAB


e:  GGSCI command (oracle): add  trandata syed.*.


GGSCI (CyclopDB) 4> EXIT


[oracle@CyclopDB gg_home]$ vi ggserr.log
2016-04-11 20:39:14  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle):  edit params  mgr.
2016-04-11 20:39:33  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2016-04-11 20:39:33  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2016-04-12 13:52:01  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add  trandata syed.mytab.
2016-04-12 14:01:56  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add  trandata syed.*.



CONFIGURING EXTRACT PROCESS ON SOURCE

ONFIGURE EXTRACT
===============
IT HAS TO BE DONE FROM GOLDENGATE PROMPT
cd /syed/gg_home/
./ggsci
>edit  params ext1
:wq!

>edit  params ext1
extract ext1
SETENV (ORACLE_SID=prime)
USERID ggadmin,PASSWORD india123
EXTTRAIL ./dirdat/ex
TABLE syed.*;
OR
TABLE syed.mytab;
TABLE syed.mytab;
:wq!


./ggsci
>info all
>dblogin userid ggadmin, password india123
>add extract ext1, tranlog,begin now
>info all
link between trailfile and extract
>add extrail ./dirdat/ex, extract ext1, megabyte 100
>info all
START EXTRACT
>start extract ext1

GGSCI (PrimeDG) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EXT1        00:00:00      00:00:07

GGSCI (PrimeDG) 1> info extract ext1, detail

EXTRACT    EXT1      Last Started 2016-04-11 23:40   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2016-04-12 23:01:56  Seqno 86, RBA 19592704
                     SCN 0.1775242 (1775242)

  Target Extract Trails:

  Remote Trail Name                                Seqno        RBA     Max MB

  ./dirdat/ex                                          0       1023        100

  Extract Source                          Begin             End

  /u01/app/oracle/PrimeDG/redo02.log      2016-04-11 23:39  2016-04-12 23:01
  Not Available                           * Initialized *   2016-04-11 23:39


Current directory    /syed/gg_home

Report file          /syed/gg_home/dirrpt/EXT1.rpt
Parameter file       /syed/gg_home/dirprm/ext1.prm
Checkpoint file      /syed/gg_home/dirchk/EXT1.cpe
Process file         /syed/gg_home/dirpcs/EXT1.pce
Stdout file          /syed/gg_home/dirout/EXT1.out
Error log            /syed/gg_home/ggserr.log