root@192.168.1.253's password:
Last login: Tue Apr 12 22:54:11 2016 from desktop-llop0gq.fios-router.home
[root@CyclopDB ~]# su - oracle
[oracle@CyclopDB ~]$ . 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 ~]$ cd /syed/gg_home
[oracle@CyclopDB gg_home]$ pwd
/syed/gg_home
[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> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (CyclopDB) 2> exit
[oracle@CyclopDB gg_home]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 15 00:23:40 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.
create user gg_admin identDatabase opened.
SQL> ified by india123;
User created.
SQL> grant dba to gg_admin;
Grant succeeded.
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> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (CyclopDB) 2> start manager
Manager started.
GGSCI (CyclopDB) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (CyclopDB) 4> edit params ./GLOBALS
GGSCI (CyclopDB) 5> dblogin userid gg_admin, password india123
Successfully logged into database.
GGSCI (CyclopDB) 6> add checkpointtable gg_admin.ggschkpt
Successfully created checkpoint table gg_admin.ggschkpt.
GGSCI (CyclopDB) 7> info checkpointtable
ERROR: Missing checkpoint table specification.
GGSCI (CyclopDB) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (CyclopDB) 9> info checkpointtable gg_admin.ggschkpt
Checkpoint table gg_admin.ggschkpt created 2016-04-15 00:26:16.
GGSCI (CyclopDB) 10> exit
[oracle@CyclopDB gg_home]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 15 00:27:06 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> desc gg_admin.ggschkpt
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NAME NOT NULL VARCHAR2(8)
GROUP_KEY NOT NULL NUMBER(19)
SEQNO NUMBER(10)
RBA NOT NULL NUMBER(19)
AUDIT_TS VARCHAR2(29)
CREATE_TS NOT NULL DATE
LAST_UPDATE_TS NOT NULL DATE
CURRENT_DIR NOT NULL VARCHAR2(255)
LOG_CSN VARCHAR2(129)
LOG_XID VARCHAR2(129)
LOG_CMPLT_CSN VARCHAR2(129)
LOG_CMPLT_XIDS VARCHAR2(2000)
VERSION NUMBER(3)
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]$ pwd
/syed/gg_home
[oracle@CyclopDB gg_home]$ ls -lrt
total 447144
-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-r--r-- 1 oracle oinstall 239042560 Apr 11 20:22 fbo_ggs_Linux_x64_ora11g_64bit.tar
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:29 dirtmp
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:29 dirsql
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:29 dirout
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:29 dirdef
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:29 dirchk
drwxr-x--- 2 oracle oinstall 4096 Apr 11 20:39 dirprm
drwxrwxr-x 2 oracle oinstall 4096 Apr 11 20:39 dirpcs
drwxrwxr-x 2 oracle oinstall 4096 Apr 12 23:47 dirdat
drwxrwxr-x 2 oracle oinstall 4096 Apr 15 00:24 dirrpt
-rw-rw-rw- 1 oracle oinstall 34 Apr 15 00:25 GLOBALS
-rw-rw-rw- 1 oracle oinstall 2198 Apr 15 00:26 ggserr.log
[oracle@CyclopDB gg_home]$ more ggserr.log
2016-04-11 20:39:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): edit params mgr.
2016-04-11 20:39:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): start manager.
2016-04-11 20:39:33 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mg
r.prm: Manager started (port 7809).
2016-04-12 13:52:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): add trandata syed.mytab.
2016-04-12 14:01:56 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): add trandata syed.*.
2016-04-12 23:47:38 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mg
r.prm: Command received from EXTRACT on host ::ffff:192.168.1.251:10851 (START
SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2016-04-12 23:47:38 INFO OGG-01677 Oracle GoldenGate Collector for Oracle:
Waiting for connection (started dynamically).
2016-04-12 23:47:38 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mg
r.prm: Command received from SERVER on host localhost.localdomain:35011 (REPORT
17120 7819).
2016-04-12 23:47:38 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mg
r.prm: Manager started collector process (Port 7819).
2016-04-12 23:47:39 INFO OGG-01228 Oracle GoldenGate Collector for Oracle:
Timeout in 300 seconds.
2016-04-12 23:47:44 INFO OGG-01229 Oracle GoldenGate Collector for Oracle:
Connected to ::ffff:192.168.1.251:56333.
2016-04-12 23:47:44 INFO OGG-01669 Oracle GoldenGate Collector for Oracle:
Opening ./dirdat/sa000000 (byte -1, current EOF 0).
2016-04-15 00:24:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): start manager.
2016-04-15 00:24:47 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mg
r.prm: Manager started (port 7809).
2016-04-15 00:25:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): edit params ./GLOBALS.
2016-04-15 00:26:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter fo
r Oracle: GGSCI command (oracle): add checkpointtable gg_admin.ggschkpt.
[oracle@CyclopDB gg_home]$
No comments:
Post a Comment