GGS

login as: mkumar020c
Using keyboard-interactive authentication.

Password:
Warning: Your password will expire in 46 hours.
Last login: Sat Dec 19 11:42:25 2015 from 10.19.0.211
-sh-3.2$ sudo -H -i -u oracle
[sudo] password for mkumar020c:
Warning: Your password will expire in 46 hours.
ENV HELP:
Source $HOME/grid.env to set DB/GI Env.
EXAMPLE:
. $HOME/grid.env
. $HOME/grid.env <dbuniquename|dbnanme>
$HOME/grid.env list
ctedb-ch2-a2p.sys.comcast.net:/home/oracle > ls -ltr *env

-rwxr-xr-x 1 oracle dba 2247 Apr 23 2012 grid.env
-rwxr-xr-x 1 oracle dba 218 Jun 26 2012 db.env
-rwxr--r-- 1 oracle dba 94 Aug 30 2012 agent.env
-rwxr--r-- 1 oracle dba 277 Nov 20 2013 agent12c.env
-rwxr--r-- 1 oracle dba 763 Aug 27 15:06 pctepros.env
ctedb-ch2-a2p.sys.comcast.net:/home/oracle > ps -ef|grep ggs
oracle 8897 8446 0 12:19 pts/6 00:00:00 grep ggs
ggs 14183 13943 0 11:33 pts/2 00:00:00 -bash
ggs 19298 19275 0 11:42 pts/5 00:00:00 -bash
ggs 23099 19298 0 11:52 pts/5 00:00:00 ssh ctedb-ch2-a1p.sys.comcast.ne
t
ctedb-ch2-a2p.sys.comcast.net:/home/oracle > ps -ef|grep mgr
oracle 12932 8446 0 12:22 pts/6 00:00:00 grep mgr
ctedb-ch2-a2p.sys.comcast.net:/home/oracle > cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
172.28.152.173 ctedb-ch2-a2p.sys.comcast.net ctedb-ch2-a2p
172.28.152.170 ctedb-ch2-a1p.sys.comcast.net ctedb-ch2-a1p
#Virtual Host IP's for Cluster

172.28.152.172 ctedb-ch2-a1p-vip.sys.comcast.net ctedb-ch2-a1p-vip
172.28.152.175 ctedb-ch2-a2p-vip.sys.comcast.net ctedb-ch2-a2p-vip
# Heart-beat Interconnect
192.168.170.1 ctedb-ch2-a1p-priv.sys.comcast.net ctedb-ch2-a1p-priv
192.168.170.2 ctedb-ch2-a2p-priv.sys.comcast.net ctedb-ch2-a2p-priv
# SCAN IP's
#172.28.152.171 ctedb-ch2-apgrd.sys.comcast.net ctedb-ch2-apgrd
#172.28.152.174 ctedb-ch2-apgrd.sys.comcast.net ctedb-ch2-apgrd
172.28.153.19 ctedb-ch2-a2p-bu.sys.comcast.net ctedb-ch2-a1p-bu

# NetBackup Media Server Address
68.87.80.67 nbkmedia01 nbkmedia01.cmc.co.denver.comcast.net
172.24.240.4 nbkmedia01-bu nbkmedia01-bu.cmc.co.denver.comcast.net
147.191.71.98 nilgiri nilgiri.cable.comcast.com
147.191.113.151 ketu ketu.cable.comcast.com
10.147.113.129 coddcnbk01 coddcnbk01.cable.comcast.com
10.147.113.130 coddcnbk02 coddcnbk02.cable.comcast.com
10.147.116.14 nilgiri-bu nilgiri-bu.cable.comcast.com
10.147.118.43 ketu-bu ketu-bu.cable.comcast.com
10.147.116.1 coddcnbk01-bu coddcnbk01-bu.cable.comcast.com
10.147.116.2 coddcnbk02-bu coddcnbk02-bu.cable.comcast.com
#
172.28.141.99 loghost
ctedb-ch2-a2p.sys.comcast.net:/home/oracle > ssh ctedb-ch2-a1p.sys.comcast.net
Last login: Fri Dec 18 23:29:33 2015 from ctedb-ch2-a2p.sys.comcast.net
ENV HELP:
Source $HOME/grid.env to set DB/GI Env.
EXAMPLE:
. $HOME/grid.env
. $HOME/grid.env <dbuniquename|dbnanme>
$HOME/grid.env list
ctedb-ch2-a1p.sys.comcast.net:/home/oracle > ls ltr *env

ls: ltr: No such file or directory
agent12c.env agent.env db.env grid.env pctepros.env
ctedb-ch2-a1p.sys.comcast.net:/home/oracle > ps -ef|grep mgr
oracle 9394 7859 0 12:25 pts/0 00:00:00 grep mgr
ggs 24110 1 0 Dec07 ? 00:01:52 ./mgr PARAMFILE
/ggs/oracle/bin/dirprm/mgr.prm REPORTFILE /ggs/oracle/bin/dirrpt/MGR.rpt PROCESSID
MGR PORT 7809
ctedb-ch2-a1p.sys.comcast.net:/home/oracle > cd
ctedb-ch2-a1p.sys.comcast.net:/home/oracle > ls -ltr *env
-rwxr-xr-x 1 oracle dba 2247 Apr 23 2012 grid.env
-rwxr-xr-x 1 oracle dba 218 May 22 2012 db.env
-rw-r--r-- 1 oracle dba 94 Aug 30 2012 agent.env
-rwxr-xr-x 1 oracle dba 277 Nov 20 2013 agent12c.env
-rwxr--r-- 1 oracle dba 763 Aug 27 15:14 pctepros.env
ctedb-ch2-a1p.sys.comcast.net:/home/oracle > . db.env
oracle@ctedb-ch2-a1p {~} pctepros1 > ps -ef |grep pmon
oracle 8376 1 0 02:09 ? 00:03:23 ora_pmon_pctepros1
oracle 16637 7859 0 12:27 pts/0 00:00:00 grep pmon
oracle 20945 1 0 2014 ? 00:09:17 asm_pmon_+ASM1
oracle@ctedb-ch2-a1p {~} pctepros1 > . pctepros.env
SID ORACLE HOME
------------- -------------------------------------
+ASM1 /u01/app/11.2.0.3/grid
* /u01/app/oracle/product/11.1.0/agent11g
pctepross1 /u01/app/oracle/product/11.2.0.3/db1
------------- -------------------------------------
ORACLE_SID=pctepros1
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db1
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /home/oracle > cd /ggs/bin
-bash: cd: /ggs/bin: No such file or directory
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /home/oracle > cd /ggs
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs > ls -ltr
total 88
drwx------ 2 root root 65536 Jun 28 2012 lost+found
drwxr-xr-x 2 ggs dba 4096 Dec 24 2014 dbadmin
drwxr-xr-x 3 ggs dba 4096 Jul 15 11:06 oracle
drwxrwxrwx 2 oracle dba 12288 Oct 2 02:25 export
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs > cd oracle
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle > ls
bin ggsinfo.sh ggslegend.log ggsmon_hawk_eye.ksh ggsmon_hawk_eye.ksh_bkup
ggs_mon_status.ksh ggs_mon_status.ksh.old ggs_mon_status.log_ctedb-ch2-
a1p.sys.comcast.net
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle > cd bin
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > ls
1.txt ddl_informix.tpl ddl_staymetadata_on.sql
dirdef gglog-R_22.dmp gglog-RW2CCTA3.dmp
help.txt RCTR_T11_TRACE1.TRC.gz
afiedt.buf ddl_mss.tpl ddl_sybase.tpl
dirdsc gglog-RCTE_T10.dmp gglog-RW2CCTA4.dmp
keygen replicat
bcpfmt.tpl ddl_mysql.tpl ddl_tandem.tpl
dirout gglog-RCTR_T10.dmp gglog-RW2CCTA5.dmp
libicudata.so.38 retrace
bcrypt.txt ddl_nopurgeRecyclebin.sql ddl_tracelevel.sql
dirpcs gglog-RCTR_T11.dmp gglog-RW2CCTE1.dmp
libicui18n.so.38 reverse
check_trails.sh ddl_nssql.tpl ddl_trace_off.sql
dirprm gglog-RCTR_T12.dmp gglog-RW2CCTE2.dmp
libicuuc.so.38 role_setup.sql
chkpt_ora_create.sql ddl_ora10.sql ddl_trace_on.sql
dirrpt gglog-RCTR_T13.dmp gglog-RW2CCTE3.dmp
libxerces-c.so.28 s1.oby
cobgen ddl_ora10upCommon.sql debug509.txt.gz
dirsql gglog-RCTR_T14.dmp gglog-RW2CCTE4.dmp
libxml2.txt sequence.sql
convchk ddl_ora11.sql defgen
dirtmp gglog-RCTR_T15.dmp gglog-RW2CCTE5.dmp
logdump server
db2cntl.tpl ddl_ora9.sql demo_more_ora_create.sql
dirver gglog-RCTR_T16.dmp gglog-RW2CCTR1.dmp
marker_remove.sql sqlldr.tpl
ddl_access.tpl ddl_oracle.tpl demo_more_ora_insert.sql
emsclnt gglog-RCTR_T17.dmp gglog-RW2CCTR2.dmp
marker_setup.sql sql_tune.txt
ddl_cleartrace.sql ddl_pin.sql demo_ora_create.sql
extract gglog-RCTR_T18.dmp gglog-RW2CCTR3.dmp
marker_status.sql ss
ddlcob ddl_purgeRecyclebin.sql demo_ora_insert.sql
fbo_ggs_Linux_x64_ora11g_64bit.tar gglog-RCTR_T.dmp gglog-RW2CCTR4.dmp mgr
tcperrs
ddl_db2_os390.tpl ddl_remove.sql demo_ora_lob_create.sql
ff gglog-RW2CCAD1.dmp gglog-RW2CCTR5.dmp
notices.txt TRACE2.TRC.gz
ddl_db2.tpl ddl_session1.sql demo_ora_misc.sql
freeBSD.txt gglog-RW2CCAD2.dmp gglog-TEST.dmp
OGG_WinUnix_Rel_Notes_11.1.1.0.30_5.pdf TRACE2.zip
ddl_ddl2file.sql ddl_session.sql demo_ora_pk_befores_create.sql
gglog-ggsci.dmp gglog-RW2CCAD3.dmp ggMessage.dat
Oracle_GoldenGate_11.1_README.txt UserExitExamples
ddl_disable.sql ddl_setup.sql demo_ora_pk_befores_insert.sql
gglog-mgr.dmp gglog-RW2CCAD4.dmp ggsci
params.sql usrdecs.h
ddl_enable.sql ddl_sqlmx.tpl demo_ora_pk_befores_updates.sql
gglog-PCTR01.dmp gglog-RW2CCAD5.dmp ggserr.log
RCTR_T10_2.TRC zlib.txt
ddl_filter.sql ddl_status.sql dirchk
gglog-PCTR02.dmp gglog-RW2CCTA1.dmp ggserr.log.12242014.gz
RCTR_T10_TRACE1.TRC.gz
ddlgen ddl_staymetadata_off.sql dirdat
gglog-R_21.dmp gglog-RW2CCTA2.dmp GLOBAL
RCTR_T10.TRC
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > pwd
/ggs/oracle/bin
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > export
LD_LIBRARY_PATH=$ORACLE_HOME/bin
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > . /ggsci
-bash: /ggsci: No such file or directory
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > pwd
/ggs/oracle/bin
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > ./ggsci
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared
object file: No such file or directory
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > . /ggsci
-bash: /ggsci: No such file or directory
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > ls -ltr
total 1871716
-r--r--r-- 1 ggs dba 1476 Oct 15 2010 zlib.txt
-r--r--r-- 1 ggs dba 759 Oct 15 2010 tcperrs
-r--r--r-- 1 ggs dba 248 Oct 15 2010 sqlldr.tpl
-r--r--r-- 1 ggs dba 1668 Oct 15 2010 libxml2.txt
-r--r--r-- 1 ggs dba 1968 Oct 15 2010 freeBSD.txt
-r--r--r-- 1 ggs dba 2653 Oct 15 2010 ddl_tandem.tpl
-r--r--r-- 1 ggs dba 3523 Oct 15 2010 ddl_sybase.tpl
-r--r--r-- 1 ggs dba 2652 Oct 15 2010 ddl_sqlmx.tpl
-r--r--r-- 1 ggs dba 3458 Oct 15 2010 ddl_oracle.tpl
-r--r--r-- 1 ggs dba 2653 Oct 15 2010 ddl_nssql.tpl
-r--r--r-- 1 ggs dba 3481 Oct 15 2010 ddl_mysql.tpl
-r--r--r-- 1 ggs dba 2984 Oct 15 2010 ddl_informix.tpl
-r--r--r-- 1 ggs dba 3017 Oct 15 2010 ddl_db2.tpl
-r--r--r-- 1 ggs dba 3502 Oct 15 2010 ddl_db2_os390.tpl
-r--r--r-- 1 ggs dba 3334 Oct 15 2010 ddl_access.tpl
-r--r--r-- 1 ggs dba 159 Oct 15 2010 db2cntl.tpl
-r--r--r-- 1 ggs dba 1725 Oct 15 2010 bcrypt.txt
-r--r--r-- 1 ggs dba 426 Oct 15 2010 bcpfmt.tpl
-r--r--r-- 1 ggs dba 21197 Oct 15 2010 usrdecs.h
-r--r--r-- 1 ggs dba 1715 Oct 15 2010 marker_status.sql
-r--r--r-- 1 ggs dba 3702 Oct 15 2010 marker_setup.sql
-r--r--r-- 1 ggs dba 2162 Oct 15 2010 marker_remove.sql
-r--r--r-- 1 ggs dba 2275 Oct 15 2010 demo_ora_misc.sql
-r--r--r-- 1 ggs dba 4015 Oct 15 2010 demo_ora_lob_create.sql
-r--r--r-- 1 ggs dba 821 Oct 15 2010 demo_ora_insert.sql
-r--r--r-- 1 ggs dba 883 Oct 15 2010 demo_ora_create.sql
-r--r--r-- 1 ggs dba 2862 Oct 15 2010 ddl_trace_on.sql
-r--r--r-- 1 ggs dba 2955 Oct 15 2010 ddl_tracelevel.sql
-r--r--r-- 1 ggs dba 2501 Oct 15 2010 ddl_staymetadata_on.sql
-r--r--r-- 1 ggs dba 2506 Oct 15 2010 ddl_staymetadata_off.sql
-r--r--r-- 1 ggs dba 8872 Oct 15 2010 ddl_status.sql
-r--r--r-- 1 ggs dba 1227 Oct 15 2010 ddl_purgeRecyclebin.sql
-r--r--r-- 1 ggs dba 1026 Oct 15 2010 ddl_pin.sql
-r--r--r-- 1 ggs dba 388 Oct 15 2010 ddl_nopurgeRecyclebin.sql
-r--r--r-- 1 ggs dba 692 Oct 15 2010 ddl_enable.sql
-r--r--r-- 1 ggs dba 746 Oct 15 2010 ddl_disable.sql
-r--r--r-- 1 ggs dba 4189 Oct 15 2010 ddl_ddl2file.sql
-r--r--r-- 1 ggs dba 1059 Oct 15 2010 ddl_cleartrace.sql
-r--r--r-- 1 ggs dba 739 Oct 15 2010 chkpt_ora_create.sql
-r--r--r-- 1 ggs dba 4539 Oct 15 2010 params.sql
-r--r--r-- 1 ggs dba 2520 Oct 15 2010 demo_ora_pk_befores_updates.sql
-r--r--r-- 1 ggs dba 1227 Oct 15 2010 demo_ora_pk_befores_insert.sql
-r--r--r-- 1 ggs dba 1269 Oct 15 2010 demo_ora_pk_befores_create.sql
-r--r--r-- 1 ggs dba 967 Oct 15 2010 demo_more_ora_insert.sql
-r--r--r-- 1 ggs dba 1217 Oct 15 2010 demo_more_ora_create.sql
-r--r--r-- 1 ggs dba 1053 Oct 15 2010 ddl_session.sql
-r--r--r-- 1 ggs dba 425 Oct 15 2010 ddl_session1.sql
-r--r--r-- 1 ggs dba 3686 Oct 15 2010 ddl_remove.sql
-r--r--r-- 1 ggs dba 3414 Oct 15 2010 ddl_mss.tpl
-r--r--r-- 1 ggs dba 206155 Nov 18 2010 notices.txt
-r--r--r-- 1 ggs dba 3102 Feb 10 2011 ddl_filter.sql
-r--r--r-x 1 ggs dba 12022 Feb 10 2011 ddl_ora10.sql
-r--r--r-x 1 ggs dba 5665 Feb 10 2011 ddl_ora10upCommon.sql
-r--r--r-x 1 ggs dba 2721 Feb 10 2011 ddl_trace_off.sql
-r--r--r-- 1 ggs dba 4375 Mar 9 2011 role_setup.sql
-r--r--r-- 1 ggs dba 460528 Apr 15 2011 ggMessage.dat
-r-xr-xr-x 1 ggs dba 5323945 May 11 2011 libxerces-c.so.28
-r-xr-xr-x 1 ggs dba 11360748 May 11 2011 libicudata.so.38
-r-xr-xr-x 1 ggs dba 4034679 May 11 2011 libicuuc.so.38
-r-xr-xr-x 1 ggs dba 5359083 May 11 2011 libicui18n.so.38
-r-xr-xr-x 1 ggs dba 235971 Jun 28 2011 ddl_setup.sql
-r--r--r-- 1 ggs dba 156062 Jul 18 2011 help.txt
-r-xr--r-- 1 ggs dba 32601 Aug 25 2011 sequence.sql
drwxr-xr-x 7 ggs dba 4096 Sep 30 2011 UserExitExamples
-rwxr-xr-x 1 ggs dba 22196744 Sep 30 2011 mgr
-rwxr-xr-x 1 ggs dba 16507931 Sep 30 2011 ggsci
-rwxr-xr-x 1 ggs dba 8141701 Sep 30 2011 cobgen
-rwxr-xr-x 1 ggs dba 8222253 Sep 30 2011 ddlcob
-rwxr-xr-x 1 ggs dba 8616351 Sep 30 2011 emsclnt
-rwxr-xr-x 1 ggs dba 104798 Sep 30 2011 keygen
-rwxr-xr-x 1 ggs dba 1349788 Sep 30 2011 logdump
-rwxr-xr-x 1 ggs dba 8029940 Sep 30 2011 retrace
-rwxr-xr-x 1 ggs dba 401251 Sep 30 2011 reverse
-rwxr-xr-x 1 ggs dba 13755650 Sep 30 2011 server
-rwxr-xr-x 1 ggs dba 8075202 Sep 30 2011 convchk
-rwxr-xr-x 1 ggs dba 9640407 Sep 30 2011 ddlgen
-rwxr-xr-x 1 ggs dba 9521588 Sep 30 2011 defgen
-rwxr-xr-x 1 ggs dba 39832798 Oct 4 2011 extract
-rwxr-xr-x 1 ggs dba 34120202 Oct 4 2011 replicat
-rw-rw-rw- 1 ggs dba 216268800 Oct 4 2011 fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxr-xr-x 1 ggs dba 28258 Oct 7 2011 Oracle_GoldenGate_11.1_README.txt
-rw-r--r-- 1 ggs dba 521703 Oct 8 2011 OGG_WinUnix_Rel_Notes_11.1.1.0.30_5.pdf
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirsql
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirtmp
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirdef
drwxrwxr-x 9 ggs dba 4096 Aug 20 2012 dirver
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirout
drwxrwxr-x 6 ggs dba 4096 Aug 23 2012 dirdat
-rw-rw-rw- 1 ggs dba 45 Sep 10 2012 GLOBAL
-rw-r--r-- 1 ggs dba 111 Sep 20 2012 afiedt.buf
-rw-rw-rw- 1 ggs dba 85 Sep 21 2012 ss
-rw-r----- 1 ggs dba 2041 Sep 21 2012 gglog-PCTR01.dmp
-rw-rw-rw- 1 ggs dba 38 Sep 21 2012 ff
-rw-r----- 1 ggs dba 3747 Sep 21 2012 gglog-R_22.dmp
drwxr-xr-x 2 ggs dba 4096 Sep 23 2012 dirdsc
-rw-rw-rw- 1 ggs dba 478 Sep 24 2012 s1.oby
-rw-r----- 1 ggs dba 7035 Oct 4 2012 gglog-RW2CCTA4.dmp
-rw-r----- 1 ggs dba 37593 Oct 15 2012 gglog-RW2CCTE2.dmp
-rw-r--r-- 1 ggs dba 155988 Mar 27 2014 1.txt
-rw-r----- 1 ggs dba 905 Apr 10 2014 gglog-mgr.dmp
-rw-rw-rw- 1 ggs dba 281167879 Dec 17 2014 debug509.txt.gz
-rw-r----- 1 ggs dba 19813637 Jan 28 2015 gglog-RW2CCTR5.dmp
-rwxr-xr-x 1 ggs dba 349 Apr 9 2015 check_trails.sh
-rw-r--r-- 1 ggs dba 20170 Jul 4 16:23 sql_tune.txt
-rw-rw-rw- 1 ggs dba 69168487 Nov 17 13:04 RCTR_T10_2.TRC
-rw-rw-rw- 1 ggs dba 77627411 Nov 17 13:04 RCTR_T10.TRC
-rw-rw-rw- 1 ggs dba 20395713 Nov 17 13:51 ggserr.log.12242014.gz
-rw-r----- 1 ggs dba 2388 Nov 20 08:26 gglog-RCTR_T.dmp
-rw-rw-rw- 1 ggs dba 2785921 Nov 23 12:16 TRACE2.TRC.gz
-rw-r--r-- 1 ggs dba 2786062 Nov 23 12:19 TRACE2.zip
-rw-r----- 1 ggs dba 19634289 Dec 8 17:13 gglog-RW2CCTR2.dmp
-rw-rw-rw- 1 ggs dba 4716131 Dec 8 23:04 RCTR_T10_TRACE1.TRC.gz
-rw-r----- 1 ggs dba 27014 Dec 9 00:45 gglog-ggsci.dmp
-rw-r----- 1 ggs dba 5514 Dec 12 21:36 gglog-TEST.dmp
-rw-r----- 1 ggs dba 777937 Dec 16 21:37 gglog-RCTR_T11.dmp
drwxrwxr-x 5 ggs dba 8192 Dec 17 16:09 dirprm
drwxrwxr-x 2 ggs dba 8192 Dec 17 16:17 dirchk
-rw-r----- 1 ggs dba 495296 Dec 17 22:25 gglog-RCTE_T10.dmp
-rw-r----- 1 ggs dba 22865211 Dec 17 22:25 gglog-RW2CCAD5.dmp
drwxrwxr-x 2 ggs dba 28672 Dec 19 09:52 dirrpt
-rw-r----- 1 ggs dba 3337539 Dec 19 11:21 gglog-RW2CCTA1.dmp
drwxrwxr-x 2 ggs dba 8192 Dec 19 11:21 dirpcs
-rw-rw-rw- 1 ggs dba 446696702 Dec 19 12:30 ggserr.log
./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared
object file: No such file or directory
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > export LD_LIBRARY_PATH
= $ORACLE_HOME/lib
-bash: export: `=': not a valid identifier
-bash: export: `/u01/app/oracle/product/11.2.0.3/db1/lib': not a valid identifier
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > export
LD_LIBRARY_PATH=$ORACLE_HOME/lib
Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.0.30_05 OGGCORE_11.1.1.0.31_PLATFORMS_110930.0600
Linux, x64, 64bit (optimized), Oracle 11g on Sep 30 2011 07:41:02
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RCTE_T10 06:04:21 00:11:50
REPLICAT ABENDED RCTR_T10 00:00:00 112:03:22
REPLICAT RUNNING RW2CCAD1 110:59:29 00:05:52
REPLICAT ABENDED RW2CCTA1 41:00:00 05:27:53
REPLICAT RUNNING RW2CCTR1 96:29:19 00:00:22
REPLICAT STOPPED TEST 00:00:00 158:55:11
MANAGER RUNNING
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 3> start REPLICAT RCTR_T10
Sending START request to MANAGER ...

REPLICAT RCTR_T10 starting
MANAGER RUNNING
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 5> info RCTR_T10
REPLICAT RCTR_T10 Last Started 2015-12-19 05:05 Status ABENDED

Checkpoint Lag 00:00:00 (updated 112:07:08 ago)
Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail/T1287091
First Record RBA 0

First Record RBA 0
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 7> start REPLICAT RW2CCTA1
Sending START request to MANAGER ...

REPLICAT RW2CCTA1 starting
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 8> info RW2CCTA1
REPLICAT RW2CCTA1 Last Started 2015-12-19 10:54 Status ABENDED

Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_TRANSA/rmttrail/T2013505
2015-12-17 14:04:42.223201 RBA 80910619
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 9> info RW2CCTA1
REPLICAT RW2CCTA1 Last Started 2015-12-19 10:54 Status ABENDED

Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_TRANSA/rmttrail/T2013505
2015-12-17 14:04:42.223201 RBA 80910619
MANAGER RUNNING
REPLICAT ABENDED RW2CCTR1 96:12:51 00:02:15

First Record RBA 0
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 12> info RW2CCAD2
REPLICAT RW2CCAD2 Last Started 2015-12-19 05:04 Status RUNNING

Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090125
2015-12-14 21:27:52.149926 RBA 85068857
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 13> info RW2CCAD2 detail
REPLICAT RW2CCAD2 Last Started 2015-12-19 05:04 Status RUNNING

Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090125
2015-12-14 21:27:52.149926 RBA 85068857
Extract Source Begin End
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090125 2015-12-14 21:07 2015-12-14

21:27
21:07
10:07
06:00
16:04
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1053545 * Initialized * 2015-01-28
17:39
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1048352 * Initialized * First
Record
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1048351 2014-12-17 06:33 First
Record
Record
Record
Record
Record
Record
Record
06:33
06:20
11:11
10:32
05:50
03:31
02:49
07:44
17:36
15:11
Record
Record
Record
Record
11:31
21:10
20:52
Record
Current directory /ggs/oracle/bin
Report file /ggs/oracle/bin/dirrpt/RW2CCAD2.rpt

Parameter file /ggs/oracle/bin/dirprm/rw2ccad2.prm
Checkpoint file /ggs/oracle/bin/dirchk/RW2CCAD2.cpr
Checkpoint table GGS.CHKPT
Process file /ggs/oracle/bin/dirpcs/RW2CCAD2.pcr
Stdout file /ggs/oracle/bin/dirout/RW2CCAD2.out
Error log /ggs/oracle/bin/ggserr.log
MANAGER RUNNING
REPLICAT ABENDED RW2CCAD3 110:57:28 00:22:49
REPLICAT RUNNING RW2CCTA1 41:00:00 05:59:52
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 15> info RW2CCTR3 detail
REPLICAT RW2CCTR3 Last Started 2015-12-19 03:39 Status ABENDED

Log Read Checkpoint File /ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1288472
2015-12-15 12:28:09.242848 RBA 36030694
Extract Source Begin End
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1288472 2015-12-14 21:07 2015-12-15

12:28
21:07
10:08
12:04
16:04
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1191221 * Initialized * 2015-01-28
17:43
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1179004 * Initialized * First
Record
06:33
06:33
06:33
06:33
06:33
06:33
06:33
06:33
06:33
06:33
06:20
11:11
05:50
02:50
07:44
06:09
Record
Record
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1032939 2013-04-21 11:31 First
Record
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1032939 2013-04-21 11:31 First
Record
11:31
22:34
16:03
Record
Current directory /ggs/oracle/bin
Report file /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

Parameter file /ggs/oracle/bin/dirprm/rw2cctr3.prm
Checkpoint file /ggs/oracle/bin/dirchk/RW2CCTR3.cpr
Checkpoint table GGS.CHKPT
Process file /ggs/oracle/bin/dirpcs/RW2CCTR3.pcr
Stdout file /ggs/oracle/bin/dirout/RW2CCTR3.out
Error log /ggs/oracle/bin/ggserr.log
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 16> cd /ggs/oracle/bin/dirrpt
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 17> date

ERROR: Invalid command.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 18> DATE
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 19> more /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 20> more /RW2CCTR3.rpt^[[D^[[D

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 21> more RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 22> cd /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

Invalid directory.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 23> view report RCTR_T10

ERROR: REPORT file RCTR_T10 does not exist.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 24> view report RW2CCTA1

ERROR: REPORT file RW2CCTA1 does not exist.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 25> view report RW2CCTR1

ERROR: REPORT file RW2CCTR1 does not exist.
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 26> sh tail 500f ggserr.log
tail: cannot open `500f' for reading: No such file or directory

tail: cannot open `ggserr.log' for reading: No such file or directory
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 27> exit

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.0.30_05 OGGCORE_11.1.1.0.31_PLATFORMS_110930.0600
Linux, x64, 64bit (optimized), Oracle 11g on Sep 30 2011 07:41:02
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
MANAGER RUNNING
REPLICAT ABENDED RW2CCAD3 110:57:28 00:34:55
REPLICAT RUNNING RW2CCTA1 41:00:00 06:11:58
GGSCI (ctedb-ch2-a1p.sys.comcast.net) 2> ls -lrt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 3> exit

ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > ls -lrt
total 1871716
-r--r--r-- 1 ggs dba 1476 Oct 15 2010 zlib.txt
-r--r--r-- 1 ggs dba 759 Oct 15 2010 tcperrs
-r--r--r-- 1 ggs dba 248 Oct 15 2010 sqlldr.tpl
-r--r--r-- 1 ggs dba 1668 Oct 15 2010 libxml2.txt
-r--r--r-- 1 ggs dba 1968 Oct 15 2010 freeBSD.txt
-r--r--r-- 1 ggs dba 2653 Oct 15 2010 ddl_tandem.tpl
-r--r--r-- 1 ggs dba 3523 Oct 15 2010 ddl_sybase.tpl
-r--r--r-- 1 ggs dba 2652 Oct 15 2010 ddl_sqlmx.tpl
-r--r--r-- 1 ggs dba 3458 Oct 15 2010 ddl_oracle.tpl
-r--r--r-- 1 ggs dba 2653 Oct 15 2010 ddl_nssql.tpl
-r--r--r-- 1 ggs dba 3481 Oct 15 2010 ddl_mysql.tpl
-r--r--r-- 1 ggs dba 2984 Oct 15 2010 ddl_informix.tpl
-r--r--r-- 1 ggs dba 3017 Oct 15 2010 ddl_db2.tpl
-r--r--r-- 1 ggs dba 3502 Oct 15 2010 ddl_db2_os390.tpl
-r--r--r-- 1 ggs dba 3334 Oct 15 2010 ddl_access.tpl
-r--r--r-- 1 ggs dba 159 Oct 15 2010 db2cntl.tpl
-r--r--r-- 1 ggs dba 1725 Oct 15 2010 bcrypt.txt
-r--r--r-- 1 ggs dba 426 Oct 15 2010 bcpfmt.tpl
-r--r--r-- 1 ggs dba 21197 Oct 15 2010 usrdecs.h
-r--r--r-- 1 ggs dba 1715 Oct 15 2010 marker_status.sql
-r--r--r-- 1 ggs dba 3702 Oct 15 2010 marker_setup.sql
-r--r--r-- 1 ggs dba 2162 Oct 15 2010 marker_remove.sql
-r--r--r-- 1 ggs dba 2275 Oct 15 2010 demo_ora_misc.sql
-r--r--r-- 1 ggs dba 4015 Oct 15 2010 demo_ora_lob_create.sql
-r--r--r-- 1 ggs dba 821 Oct 15 2010 demo_ora_insert.sql
-r--r--r-- 1 ggs dba 883 Oct 15 2010 demo_ora_create.sql
-r--r--r-- 1 ggs dba 2862 Oct 15 2010 ddl_trace_on.sql
-r--r--r-- 1 ggs dba 2955 Oct 15 2010 ddl_tracelevel.sql
-r--r--r-- 1 ggs dba 2501 Oct 15 2010 ddl_staymetadata_on.sql
-r--r--r-- 1 ggs dba 2506 Oct 15 2010 ddl_staymetadata_off.sql
-r--r--r-- 1 ggs dba 8872 Oct 15 2010 ddl_status.sql
-r--r--r-- 1 ggs dba 1227 Oct 15 2010 ddl_purgeRecyclebin.sql
-r--r--r-- 1 ggs dba 1026 Oct 15 2010 ddl_pin.sql
-r--r--r-- 1 ggs dba 388 Oct 15 2010 ddl_nopurgeRecyclebin.sql
-r--r--r-- 1 ggs dba 692 Oct 15 2010 ddl_enable.sql
-r--r--r-- 1 ggs dba 746 Oct 15 2010 ddl_disable.sql
-r--r--r-- 1 ggs dba 4189 Oct 15 2010 ddl_ddl2file.sql
-r--r--r-- 1 ggs dba 1059 Oct 15 2010 ddl_cleartrace.sql
-r--r--r-- 1 ggs dba 739 Oct 15 2010 chkpt_ora_create.sql
-r--r--r-- 1 ggs dba 4539 Oct 15 2010 params.sql
-r--r--r-- 1 ggs dba 2520 Oct 15 2010 demo_ora_pk_befores_updates.sql
-r--r--r-- 1 ggs dba 1227 Oct 15 2010 demo_ora_pk_befores_insert.sql
-r--r--r-- 1 ggs dba 1269 Oct 15 2010 demo_ora_pk_befores_create.sql
-r--r--r-- 1 ggs dba 967 Oct 15 2010 demo_more_ora_insert.sql
-r--r--r-- 1 ggs dba 1217 Oct 15 2010 demo_more_ora_create.sql
-r--r--r-- 1 ggs dba 1053 Oct 15 2010 ddl_session.sql
-r--r--r-- 1 ggs dba 425 Oct 15 2010 ddl_session1.sql
-r--r--r-- 1 ggs dba 3686 Oct 15 2010 ddl_remove.sql
-r--r--r-- 1 ggs dba 3414 Oct 15 2010 ddl_mss.tpl
-r--r--r-- 1 ggs dba 206155 Nov 18 2010 notices.txt
-r--r--r-- 1 ggs dba 3102 Feb 10 2011 ddl_filter.sql
-r--r--r-x 1 ggs dba 5665 Feb 10 2011 ddl_ora10upCommon.sql
-r--r--r-x 1 ggs dba 2721 Feb 10 2011 ddl_trace_off.sql
-r--r--r-- 1 ggs dba 4375 Mar 9 2011 role_setup.sql
-r--r--r-- 1 ggs dba 460528 Apr 15 2011 ggMessage.dat
-r-xr-xr-x 1 ggs dba 5323945 May 11 2011 libxerces-c.so.28
-r-xr-xr-x 1 ggs dba 11360748 May 11 2011 libicudata.so.38
-r-xr-xr-x 1 ggs dba 4034679 May 11 2011 libicuuc.so.38
-r-xr-xr-x 1 ggs dba 5359083 May 11 2011 libicui18n.so.38
-r-xr-xr-x 1 ggs dba 235971 Jun 28 2011 ddl_setup.sql
-r--r--r-- 1 ggs dba 156062 Jul 18 2011 help.txt
-r-xr--r-- 1 ggs dba 32601 Aug 25 2011 sequence.sql
drwxr-xr-x 7 ggs dba 4096 Sep 30 2011 UserExitExamples
-rwxr-xr-x 1 ggs dba 22196744 Sep 30 2011 mgr
-rwxr-xr-x 1 ggs dba 16507931 Sep 30 2011 ggsci
-rwxr-xr-x 1 ggs dba 8141701 Sep 30 2011 cobgen
-rwxr-xr-x 1 ggs dba 8222253 Sep 30 2011 ddlcob
-rwxr-xr-x 1 ggs dba 8616351 Sep 30 2011 emsclnt
-rwxr-xr-x 1 ggs dba 104798 Sep 30 2011 keygen
-rwxr-xr-x 1 ggs dba 1349788 Sep 30 2011 logdump
-rwxr-xr-x 1 ggs dba 8029940 Sep 30 2011 retrace
-rwxr-xr-x 1 ggs dba 401251 Sep 30 2011 reverse
-rwxr-xr-x 1 ggs dba 13755650 Sep 30 2011 server
-rwxr-xr-x 1 ggs dba 8075202 Sep 30 2011 convchk
-rwxr-xr-x 1 ggs dba 9640407 Sep 30 2011 ddlgen
-rwxr-xr-x 1 ggs dba 9521588 Sep 30 2011 defgen
-rwxr-xr-x 1 ggs dba 39832798 Oct 4 2011 extract
-rwxr-xr-x 1 ggs dba 34120202 Oct 4 2011 replicat
-rw-rw-rw- 1 ggs dba 216268800 Oct 4 2011 fbo_ggs_Linux_x64_ora11g_64bit.tar
-rwxr-xr-x 1 ggs dba 28258 Oct 7 2011 Oracle_GoldenGate_11.1_README.txt
-rw-r--r-- 1 ggs dba 521703 Oct 8 2011 OGG_WinUnix_Rel_Notes_11.1.1.0.30_5.pdf
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirsql
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirtmp
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirdef
drwxrwxr-x 9 ggs dba 4096 Aug 20 2012 dirver
drwxrwxr-x 2 ggs dba 4096 Aug 20 2012 dirout
drwxrwxr-x 6 ggs dba 4096 Aug 23 2012 dirdat
-rw-rw-rw- 1 ggs dba 45 Sep 10 2012 GLOBAL
-rw-r--r-- 1 ggs dba 111 Sep 20 2012 afiedt.buf
-rw-rw-rw- 1 ggs dba 85 Sep 21 2012 ss
-rw-rw-rw- 1 ggs dba 38 Sep 21 2012 ff
drwxr-xr-x 2 ggs dba 4096 Sep 23 2012 dirdsc
-rw-rw-rw- 1 ggs dba 478 Sep 24 2012 s1.oby
-rw-r--r-- 1 ggs dba 155988 Mar 27 2014 1.txt
-rw-r----- 1 ggs dba 905 Apr 10 2014 gglog-mgr.dmp
-rw-rw-rw- 1 ggs dba 281167879 Dec 17 2014 debug509.txt.gz
-rwxr-xr-x 1 ggs dba 349 Apr 9 2015 check_trails.sh
-rw-r--r-- 1 ggs dba 20170 Jul 4 16:23 sql_tune.txt
-rw-rw-rw- 1 ggs dba 69168487 Nov 17 13:04 RCTR_T10_2.TRC
-rw-rw-rw- 1 ggs dba 77627411 Nov 17 13:04 RCTR_T10.TRC
-rw-rw-rw- 1 ggs dba 20395713 Nov 17 13:51 ggserr.log.12242014.gz
-rw-r----- 1 ggs dba 2388 Nov 20 08:26 gglog-RCTR_T.dmp
-rw-rw-rw- 1 ggs dba 2785921 Nov 23 12:16 TRACE2.TRC.gz
-rw-r--r-- 1 ggs dba 2786062 Nov 23 12:19 TRACE2.zip
-rw-r----- 1 ggs dba 27014 Dec 9 00:45 gglog-ggsci.dmp
-rw-r----- 1 ggs dba 5514 Dec 12 21:36 gglog-TEST.dmp
drwxrwxr-x 5 ggs dba 8192 Dec 17 16:09 dirprm
drwxrwxr-x 2 ggs dba 8192 Dec 17 16:17 dirchk
-rw-r----- 1 ggs dba 495296 Dec 17 22:25 gglog-RCTE_T10.dmp
-rw-r----- 1 ggs dba 3337539 Dec 19 11:21 gglog-RW2CCTA1.dmp
drwxrwxr-x 2 ggs dba 28672 Dec 19 12:37 dirrpt
drwxrwxr-x 2 ggs dba 8192 Dec 19 12:45 dirpcs
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > ls -lrt *log
ctedb-ch2-a1p.sys.comcast.net:(pctepros1) /ggs/oracle/bin > tail -500f ggserr.log
2015-12-19 12:00:19 INFO OGG-01670 Oracle GoldenGate Collector: Closing
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail/T1292415.
2015-12-19 12:00:19 INFO OGG-01669 Oracle GoldenGate Collector: Opening
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail/T1292416 (byte -1, current EOF 0).
/ggs/oracle/bin/dirdat/CTE_TRANSA/rmttrail/T2013566.
/ggs/oracle/bin/dirdat/CTE_TRANSA/rmttrail/T2013567 (byte -1, current EOF 0).
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090608.
/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090609 (byte -1, current EOF 0).
2015-12-19 12:01:03 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle,
rw2ccad5.prm: Setting current schema for DDL operation to [CTE_ADMIN].
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1288431.
/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1288432 (byte -1, current EOF 0).
rw2ccad3.prm: Restoring current schema for DDL operation to [GGS].
rw2ccad2.prm: BATCHSQL resumed, recovered from error.
2015-12-19 12:35:50 INFO OGG-00987 Oracle GoldenGate Command Interpreter for
Oracle: GGSCI command (oracle): start REPLICAT RCTR_T10.
2015-12-19 12:35:50 INFO OGG-00963 Oracle GoldenGate Manager for Oracle,
mgr.prm: Command received from GGSCI on host 172.28.152.170 (START REPLICAT
RCTR_T10 ).
mgr.prm: REPLICAT RCTR_T10 starting.
rctr_t10.prm: REPLICAT RCTR_T10 starting.
2015-12-19 12:37:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for
Oracle: GGSCI command (oracle): start REPLICAT RW2CCTA1.
mgr.prm: Command received from GGSCI on host 172.28.152.170 (START REPLICAT
RW2CCTA1 ).
mgr.prm: REPLICAT RW2CCTA1 starting.
rw2ccta1.prm: REPLICAT RW2CCTA1 starting.
rctr_t10.prm: REPLICAT RCTR_T10 started.
2015-12-19 12:38:17 ERROR OGG-01091 Oracle GoldenGate Delivery for Oracle,
rctr_t10.prm: Unable to open file
"/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail/T1287091" (error 2, No such file or
directory).
rctr_t10.prm: PROCESS ABENDING.
2015-12-19 12:39:18 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle,
rw2ccad3.prm: Aborting BATCHSQL transaction. Detected inconsistent result:
executed 1 operations in batch, resulting in 0 affected rows.
rw2ccad3.prm: BATCHSQL suspended, continuing in normal mode.
rw2ccad3.prm: Repositioning to rba 59315096 in seqno 90126.
rw2cctr1.prm: SQL operation failed: Updating checkpoint table GGS.CHKPT, group
RW2CCTR1, key 525800864 (0x1f5715a0), SQL <UPDATE "GGS"."CHKPT" SET
last_update_ts = sysdate, seqno = :seqno, rba = :rba, audit_ts
= :audit_ts WHERE group_name = :group_name AND group_key = :key> SQL Error
3113: ORA-03113: end-of-file on communication channel Process ID: 15884 Session ID:
583 Serial number: 5.
rw2cctr1.prm: PROCESS ABENDING.
rw2cctr3.prm: SQL operation failed: Updating checkpoint table GGS.CHKPT, group
RW2CCTR3, key 1530369071 (0x5b37942f), SQL <UPDATE "GGS"."CHKPT" SET
28: ORA-00028: your session has been killed ORA-00028: your session has been
killed.
rw2cctr3.prm: PROCESS ABENDING.
rw2ccad3.prm: SQL operation failed: Updating checkpoint table GGS.CHKPT, group
RW2CCAD3, key 832436436 (0x319df8d4), SQL <UPDATE "GGS"."CHKPT" SET
3113: ORA-03113: end-of-file on communication channel Process ID: 12365 Session ID:
2687 Serial number: 213.
rw2ccad3.prm: PROCESS ABENDING.
rw2ccta1.prm: REPLICAT RW2CCTA1 started.
rw2ccad1.prm: BATCHSQL resumed, recovered from error.

GGS

Uploaded by

Copyright:

Available Formats

GGS

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

GGS

Uploaded by

Copyright:

Available Formats

login as: mkumar020c

Using keyboard-interactive authentication.

ctedb-ch2-a2p.sys.comcast.net:/home/oracle > ls -ltr *env

#Virtual Host IP's for Cluster

172.28.153.19 ctedb-ch2-a2p-bu.sys.comcast.net ctedb-ch2-a1p-bu

ctedb-ch2-a1p.sys.comcast.net:/home/oracle > ls ltr *env

Oracle GoldenGate Command Interpreter for Oracle

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 1> info all

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 2> info all

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 3> start REPLICAT RCTR_T10

Sending START request to MANAGER ...

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 5> info RCTR_T10

REPLICAT RCTR_T10 Last Started 2015-12-19 05:05 Status ABENDED

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 6> info RCTR_T10

REPLICAT RCTR_T10 Last Started 2015-12-19 05:05 Status ABENDED

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 7> start REPLICAT RW2CCTA1

Sending START request to MANAGER ...

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 8> info RW2CCTA1

REPLICAT RW2CCTA1 Last Started 2015-12-19 10:54 Status ABENDED

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 9> info RW2CCTA1

REPLICAT RW2CCTA1 Last Started 2015-12-19 10:54 Status ABENDED

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 11> info RCTR_T10

REPLICAT RCTR_T10 Last Started 2015-12-19 12:38 Status ABENDED

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 12> info RW2CCAD2

REPLICAT RW2CCAD2 Last Started 2015-12-19 05:04 Status RUNNING

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 13> info RW2CCAD2 detail

REPLICAT RW2CCAD2 Last Started 2015-12-19 05:04 Status RUNNING

Extract Source Begin End

/ggs/oracle/bin/dirdat/CTE_ADMIN/rmttrail/B1090125 2015-12-14 21:07 2015-12-14

Current directory /ggs/oracle/bin

Report file /ggs/oracle/bin/dirrpt/RW2CCAD2.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 14> info all

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 15> info RW2CCTR3 detail

REPLICAT RW2CCTR3 Last Started 2015-12-19 03:39 Status ABENDED

Extract Source Begin End

/ggs/oracle/bin/dirdat/CTE_TRANS/rmttrail2/T1288472 2015-12-14 21:07 2015-12-15

Current directory /ggs/oracle/bin

Report file /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 16> cd /ggs/oracle/bin/dirrpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 17> date

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 19> more /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 20> more /RW2CCTR3.rpt^[[D^[[D

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 21> more RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 22> cd /ggs/oracle/bin/dirrpt/RW2CCTR3.rpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 23> view report RCTR_T10

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 24> view report RW2CCTA1

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 25> view report RW2CCTR1

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 26> sh tail 500f ggserr.log

tail: cannot open `500f' for reading: No such file or directory

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 27> exit

Oracle GoldenGate Command Interpreter for Oracle

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 1> info all

Program Status Group Lag Time Since Chkpt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 2> ls -lrt

GGSCI (ctedb-ch2-a1p.sys.comcast.net) 3> exit