专题 › Oracle技术专区 › goldengate 12.2.0.1.1 downstream capture 集成抽取downstream捕获方式

dongxujian 发表于 2017-10-19 22:06:27

goldengate 12.2.0.1.1 downstream capture 集成抽取downstream捕获方式

1.两主机IP及主机名称规划，dg2 为下端捕获数据库：



$ hostname
dg2
$ cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.1.88 dg2
192.168.1.87 dg1
192.168.1.27 cc12
$ uname -a
Linux dg2 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
$ arch
x86_64
$
$
$
$
$


2.下端捕获数据库tnsnames.ora 文件配置：

   添加到上游数据库连接串                                                                                                                                 
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl1)
    )
)


ORCL =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)
测试网络连通性：


$ tnsping orcl1

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:29:33

Copyright (c) 1997, 2013, Oracle.All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl1)))
OK (10 msec)
$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:29:36

Copyright (c) 1997, 2013, Oracle.All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
$
$
$
$
$
$

3.调整上游数据库tnsnames.ora文件，添加到下游数据库的网络连接串：


$ ssh dg1
The authenticity of host 'dg1 (192.168.1.87)' can't be established.
RSA key fingerprint is 28:5d:76:19:60:ac:26:ca:3e:84:83:5e:fe:7e:51:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'dg1,192.168.1.87' (RSA) to the list of known hosts.
oracle@dg1's password:
$
$
$
$
$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
$ vi tnsnames.ora                                                                                                                                             
$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)

ORCL1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl1)
    )
)

$
$
$

   测试网络连通性：
   
$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:30:43

Copyright (c) 1997, 2013, Oracle.All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
$ tnsping orcl1

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:30:45

Copyright (c) 1997, 2013, Oracle.All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl1)))
OK (10 msec)
$




4上游数据库归档模式检查：

$
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:30:50 2017

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

SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode            Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   4
Next log sequence to archive   6
Current log sequence         6
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


5.目标端数据调整为归档模式：



$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:31:03 2017

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

SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode            No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   4
Current log sequence         6
SQL>   
SQL>
SQL>
SQL>

SQL> connect /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             989858976 bytes
Database Buffers          603979776 bytes
Redo Buffers                7319552 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode            Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   4
Next log sequence to archive   6
Current log sequence         6
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE      VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size         big integer 4182M
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit

6.调整上游数据库配置相关参数，以满足goldengate 安装要求：


$
$ sqlplus sys/oracle@orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:35:04 2017

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


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

SQL> select database_role,log_mode,force_logging from v$database;

DATABASE_ROLE    LOG_MODE   FOR
---------------- ------------ ---
PRIMARY          ARCHIVELOG   NO

SQL> alter database force logging;

Database altered.

SQL> alter system set streams_pool_size=512M scope=both;

System altered.

SQL> alter database add supplementallog data;

Database altered.

SQL> alter system set enable_goldengate_replication = true;

System altered.

SQL> create user ogg identified by oracle account unlock;

User created.

SQL> grant resource,dba,connect to ogg identified by oracle;

Grant succeeded.

SQL> exec dbms_streams_auth.grant_admin_privilege('ogg');

PL/SQL procedure successfully completed.

SQL> grant become user to ogg;

Grant succeeded.

SQL> alter user scott identified by oracle account unlock;

User altered.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options





7.调整下游数据库相关配置及参数以满足goldengate安装要求：


$
$
$
$
$
$ sqlplus sys/oracle@orcl1 as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:38:32 2017

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


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

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select database_role,log_mode,force_logging from v$database;

DATABASE_ROLE    LOG_MODE   FOR
---------------- ------------ ---
PRIMARY          ARCHIVELOG   NO


SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

SUPPLEME
--------
NO

SQL>
SQL>
SQL>
SQL>
SQL> create user ogg identified by oracle account unlock;

User created.
SQL> alter system set streams_pool_size=512M scope=both;

System altered.

SQL> grant resource,dba,connect to ogg identified by oracle;

Grant succeeded.

SQL> exec dbms_streams_auth.grant_admin_privilege('ogg');

PL/SQL procedure successfully completed.

SQL> grant become user to ogg;

Grant succeeded.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>

8.下游数据库自身在线日志归档目录调整：

SQL>
SQL> host mkdir -p /u01/arc_dest/local

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u01/arc_dest/local VALID_FOR=(ONLINE_LOGFILE, PRIMARY_ROLE)'
2;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE
2;

System altered.


9.下游数据库指定上游数据库在线日志归档目录调整：


SQL> host mkdir -p /u01/arc_dest/srl_dbms1         

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/u01/arc_dest/srl_dbms1 VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)';

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl1)';

System altered.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$
$

10.上游数据库相关调整操作：


$ sqlplus sys/oracle@orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:45:18 2017

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


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

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl1)';

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=ORCL1 ASYNC OPTIONAL NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl1';

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

System altered.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



11.下游主机安装goldengate 12.2.0.1.1 软件：

$ hostname
dg2

$
$
$ mkdir -p /u01/ogg
$ cd /u01/ogg
$ pwd
/u01/ogg
$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb32016 V100692-01.zip
$
$
$
$ cd                                                                                                                                    
$ cat .bash_profile
# ---------------------------------------------------
# OS User:      oracle
# Application:Oracle Database Software Owner
# Version:      Oracle 11g release 2
# ---------------------------------------------------

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi
export GGHOME=/u01/ogg
ORACLE_SID=orcl1; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022

$ echo $GGHOME

$ source .bash_profile
$ echo $GGHOME
/u01/ogg
$
$
$
$ cd $GGHOME
$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb32016 V100692-01.zip
$ unzip V100692-01.zip
Archive:V100692-01.zip
   creating: fbo_ggs_Linux_x64_shiphome/
   creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
...........中间忽略...........................
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf
$ exit
logout
# export DISPLAY=192.168.1.1:0.0
# XHOST +
-bash: XHOST: command not found
# xhost +
access control disabled, clients can connect from any host
# su - oracle
$ xhost +
access control disabled, clients can connect from any host
$ ls
$ cd $GGHOME
$ ls
fbo_ggs_Linux_x64_shiphomeOGG-12.2.0.1.1-ReleaseNotes.pdfOGG-12.2.0.1-README.txtV100692-01.zip
$ cd fbo_ggs_Linux_x64_shiphome/Disk1/
$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 20290 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1999 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) y


>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-10-16_01-52-18AM. Please wait ...$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2017-10-16_01-52-18AM.log

$
$
$
$


12. 确认goldnegate 软件安装正常，创建goldengate相关工作目录：


$ cd
$ cd $GGHOME
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          


GGSCI (dg2) 2> view params mgr

PORT 7809


GGSCI (dg2) 3> create subdirs

Creating subdirectories under current directory /u01/ogg

Parameter files                /u01/ogg/dirprm: already exists
Report files                   /u01/ogg/dirrpt: already exists
Checkpoint files               /u01/ogg/dirchk: already exists
Process status files         /u01/ogg/dirpcs: already exists
SQL script files               /u01/ogg/dirsql: already exists
Database definitions files   /u01/ogg/dirdef: already exists
Extract data files             /u01/ogg/dirdat: already exists
Temporary files                /u01/ogg/dirtmp: already exists
Credential store files         /u01/ogg/dircrd: already exists
Masterkey wallet files         /u01/ogg/dirwlt: already exists
Dump files                     /u01/ogg/dirdmp: already exists


GGSCI (dg2) 4> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          


GGSCI (dg2) 5>

GGSCI (dg2) 5>

GGSCI (dg2) 5>

GGSCI (dg2) 5> exit


13. 此时登录上游主机dg1查看数据库告警日志，发现有如下报错：


$
$
$
$
$ ssh dg1
oracle@dg1's password:
Last login: Mon Oct 16 01:30:03 2017 from dg2
$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
$ tail -20f alert_orcl.log
------------------------------------------------------------
PING: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.
Mon Oct 16 01:54:22 2017
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.
Mon Oct 16 01:55:23 2017
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.



此错误的原因为上游数据库的口令文件 $ORACLE_HOME/dbs/orapworcl未拷贝至下游数据库相关目录（记住还要rename to orapworcl1),下面为相关调整步骤：

    拷贝口令文件至下游主机dg2:
$ cd $ORACLE_HOME/dbs/
-rw-r-----. 1 oracle oinstall 1536 Aug82015 orapworcl

$ scp orapworcl dg2:`pwd`
The authenticity of host 'dg2 (192.168.1.88)' can't be established.
RSA key fingerprint is 28:5d:76:19:60:ac:26:ca:3e:84:83:5e:fe:7e:51:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'dg2,192.168.1.88' (RSA) to the list of known hosts.
oracle@dg2's password:
orapworcl                                                                                                                                                         100% 1536   1.5KB/s   00:00   
$
   下游主机重命名口令文件:
$ cd $ORACLE_HOME/dbs
$ ls -l
total 24
-rw-rw----. 1 oracle oinstall 1544 Oct 16 01:32 hc_orcl1.dat
-rw-r--r--. 1 oracle oinstall 2851 May 152009 init.ora
-rw-r-----. 1 oracle oinstall   24 Oct 11 03:36 lkORCL1
-rw-r-----. 1 oracle oinstall 1536 Oct 16 01:56 orapworcl
-rw-r-----. 1 oracle oinstall 1536 Oct 11 03:38 orapworcl1
-rw-r-----. 1 oracle oinstall 3584 Oct 16 01:44 spfileorcl1.ora
$ mv orapworcl orapworcl1
$ ls -ltr
total 20
-rw-r--r--. 1 oracle oinstall 2851 May 152009 init.ora
-rw-r-----. 1 oracle oinstall   24 Oct 11 03:36 lkORCL1
-rw-rw----. 1 oracle oinstall 1544 Oct 16 01:32 hc_orcl1.dat
-rw-r-----. 1 oracle oinstall 3584 Oct 16 01:44 spfileorcl1.ora
-rw-r-----. 1 oracle oinstall 1536 Oct 16 01:56 orapworcl1



14.下游主机dg2配置下端流抽取进程 ext1:


$
$
$
$ cd $GGHOME
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          


GGSCI (dg2) 2> exit
$ ggsci -v

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38

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


$
$
$
$
$
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> dblogin userid ogg@orcl,password oracle
Successfully logged into database.

GGSCI (dg2 as ogg@orcl) 2> miningdblogin userid ogg@orcl1,password oracle
Successfully logged into mining database.

GGSCI (dg2 as ogg@orcl) 3>

GGSCI (dg2 as ogg@orcl) 3>

GGSCI (dg2 as ogg@orcl) 3>

GGSCI (dg2 as ogg@orcl) 3> register extract ext1 database

2017-10-16 02:00:53ERROR   OGG-02060The Oracle mining database is not configured properly to support integrated capture. The following configuration error must be fixed:Operation not supported because enable_goldengate_replication is not set to true.
此错误为 下游数据库参数enable_goldengate_replicate 参数未调整为true,调整此参数如下：

GGSCI (dg2 as ogg@orcl) 4> exit
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:01:21 2017

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

SQL> connect /as sysdba
Connected.
SQL> alter system set enable_goldengate_replication = true;

System altered.

SQL> show parameter goldengate

NAME                                 TYPE      VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication      boolean   TRUE
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


登录上游数据库，开启用户级别附件日志：

GGSCI (dg2 as ogg@orcl) 6> dblogin userid ogg@orcl,password oracle
Successfully logged into database.

GGSCI (dg2 as ogg@orcl) 7> add schematrandata scott

2017-10-16 02:07:59INFO    OGG-01788SCHEMATRANDATA has been added on schema scott.

2017-10-16 02:07:59INFO    OGG-01976SCHEMATRANDATA for scheduling columns has been added on schema scott.

GGSCI (dg2 as ogg@orcl) 8>


重新注册下端流集成抽取进程ext1:
$ pwd
/u01/ogg
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> dblogin userid ogg@orcl,password oracle
Successfully logged into database.

GGSCI (dg2 as ogg@orcl) 2>miningdblogin userid ogg@orcl1,password oracle
Successfully logged into mining database.

GGSCI (dg2 as ogg@orcl) 3> register extract ext1 database

2017-10-16 02:02:06INFO    OGG-02003Extract EXT1 successfully registered with database at SCN 1015610.






编辑抽取进程参数文件：

GGSCI (dg2 as ogg@orcl) 4> edit params ext1





GGSCI (dg2 as ogg@orcl) 10> edit params ext1
extract ext1
userid ogg@orcl,password oracle
tranlogoptions mininguser ogg,miningpassword oracle
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*;

GGSCI (dg2 as ogg@orcl) 8> ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW
EXTRACT (Integrated) added.

GGSCI (dg2 as ogg@orcl) 13> add exttrail ./dirdat/lr, extract ext1, megabytes 200
EXTTRAIL added.

GGSCI (dg2 as ogg@orcl) 14> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STOPPED   EXT1      00:00:00      00:01:59   


GGSCI (dg2 as ogg@orcl) 15> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting










GGSCI (dg2 as ogg@orcl) 33> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (dg2 as ogg@orcl) 34> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STARTING    EXT1      00:00:00      00:08:59   





GGSCI (dg2 as ogg@orcl) 41> view params ext1




GGSCI (dg2 as ogg@orcl) 42> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STOPPED   EXT1      00:00:00      00:10:10   


GGSCI (dg2 as ogg@orcl) 43> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (dg2 as ogg@orcl) 44> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STARTING    EXT1      00:00:00      00:10:13   


GGSCI (dg2 as ogg@orcl) 45> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STARTING    EXT1      00:00:00      00:10:16   


GGSCI (dg2 as ogg@orcl) 46> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STOPPED   EXT1      00:00:00      00:10:39   


GGSCI (dg2 as ogg@orcl) 47> view report ext1


***********************************************************************
               Oracle GoldenGate Capture for Oracle
    Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
   Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:10:08

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


                  Starting at 2017-10-16 02:18:39
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Tue Jan 29 11:47:41 EST 2013, Release 2.6.32-358.el6.x86_64
Node: dg2
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 6317

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2017-10-16 02:18:39INFO    OGG-03059Operating system character set identified as US-ASCII.

2017-10-16 02:18:39INFO    OGG-02695ANSI SQL parameter syntax is used for parameter parsing.
extract ext1
userid ogg@orcl,password ***

2017-10-16 02:18:39INFO    OGG-03522Setting session time zone to source database time zone 'GMT'.
tranlogoptions mininguser ogg,miningpassword ***
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS

2017-10-16 02:18:39WARNING OGG-04033   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*;

2017-10-16 02:18:39INFO    OGG-01635BOUNDED RECOVERY: reset to initial or altered checkpoint.

2017-10-16 02:18:39INFO    OGG-01815Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.

Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR      = /u01/ogg

2017-10-16 02:18:39INFO    OGG-01851filecaching started: thread ID: 140199436269312.

2017-10-16 02:18:39INFO    OGG-01815Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default):               8M
PROCESS VM AVAIL FROM OS (min):         128G
CACHESIZEMAX (strict force to disk):   96G

Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANGUAGE   = "AMERICAN"
NLS_TERRITORY    = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"

2017-10-16 02:18:39WARNING OGG-02045Database does not have streams_pool_size initialization parameter configured.

2017-10-16 02:18:39INFO    OGG-02248Logmining server DDL filtering enabled.

2017-10-16 02:18:40INFO    OGG-02068Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.

2017-10-16 02:18:41INFO    OGG-02089Source redo compatibility version is: 11.2.0.4.0.

2017-10-16 02:18:41INFO    OGG-02086Integrated Dictionary will be used.

2017-10-16 02:18:41WARNING OGG-02901Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.

2017-10-16 02:18:41WARNING OGG-02083DDLOPTIONS with ADDTRANDATA is no longer supported.

Source Context :
SourceModule            :
SourceID                :
SourceFunction          :
SourceLine            :
ThreadBacktrace         : elements
                        : ]
                        : ]
                        : ]
                        : [/u01/ogg/extract(metadata_from_logminer(ggs::gglib::ggunicode::UString const*, unsigned long, unsigned int, unsigned int, ggs::gglib::ggunicode::UString const&, bool, DD
LPropertyBuffer&, bool)+0x2b44) ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]
                        : ]

2017-10-16 02:18:41ERROR   OGG-02912Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.

2017-10-16 02:18:41ERROR   OGG-01668PROCESS ABENDING.


此错误为下游数据库未打必要的补丁导致的：



上传接下相关补丁：

GGSCI (dg2 as ogg@orcl) 50> exit
$ cd
$ ls
p17030189_112040_Generic.zip
$ unzip p17030189_112040_Generic.zip
Archive:p17030189_112040_Generic.zip
   creating: 17030189/
inflating: 17030189/postdeinstall.sql
   creating: 17030189/etc/
   creating: 17030189/etc/config/
inflating: 17030189/etc/config/inventory.xml
inflating: 17030189/etc/config/deploy.xml
inflating: 17030189/etc/config/actions.xml
   creating: 17030189/etc/xml/
inflating: 17030189/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 17030189/etc/xml/GenericActions.xml
   creating: 17030189/files/
   creating: 17030189/files/sqlpatch/
   creating: 17030189/files/sqlpatch/17030189/
inflating: 17030189/files/sqlpatch/17030189/postdeinstall.sql
inflating: 17030189/files/sqlpatch/17030189/postinstall.sql
   creating: 17030189/files/rdbms/
   creating: 17030189/files/rdbms/admin/
inflating: 17030189/files/rdbms/admin/prvtlmcb.plb
inflating: 17030189/README.txt   
inflating: 17030189/postinstall.sql
inflating: PatchSearch.xml

关闭下游数据库，准备打补丁：
      
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:21:21 2017

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

SQL> connect /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ ls -l
total 68
drwxrwxr-x. 4 oracle oinstall4096 May 262015 17030189
-rw-r--r--. 1 root   root   57558 Mar32016 p17030189_112040_Generic.zip
-rw-rw-r--. 1 oracle oinstall2344 May 262015 PatchSearch.xml

$ pwd
/home/oracle/17030189
$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from         : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17030189_Oct_16_2017_02_23_51/apply2017-10-16_02-23-50AM_1.log

Applying interim patch '17030189' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Verifying the update...
Patch 17030189 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17030189_Oct_16_2017_02_23_51/apply2017-10-16_02-23-50AM_1.log

OPatch succeeded.

开启下游数据库并执行后继步骤，执行相关sql 脚本：


$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:30:17 2017

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

SQL> connect /as sysdba
Connected.
SQL> @postinstall.sql

.......中间内容略..........
PL/SQL procedure successfully completed.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

下游主机登录 ggsci 并重新启动下游抽取进程ext1:


$ cd $GGHOME
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   STOPPED   EXT1      00:00:00      00:22:46   


GGSCI (dg2) 2> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (dg2) 3> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   RUNNING   EXT1      00:22:51      00:00:01   




GGSCI (dg2) 5> view ggsevt

2017-10-16 01:54:18INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): CREATE SUBDIRS.
2017-10-16 01:54:19INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): START MGR.
2017-10-16 01:54:19WARNING OGG-01877Oracle GoldenGate Manager for Oracle, mgr.prm:Missing explicit accessrule for server collector.
2017-10-16 01:54:19INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #6).
2017-10-16 01:54:19INFO    OGG-00983Oracle GoldenGate Manager for Oracle, mgr.prm:Manager started (port 7809).
2017-10-16 01:54:20INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle, oby.oby:GGSCI command (oracle): CREATE DATASTORE.
2017-10-16 01:55:03INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 01:55:12INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): create subdirs.
2017-10-16 01:55:16INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 01:59:45INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:00:13INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:00:31INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): miningdblogin userid ogg@orcl1 password ***.
2017-10-16 02:00:53INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): register extract ext1 database.
2017-10-16 02:00:53ERROR   OGG-02060Oracle GoldenGate Command Interpreter for Oracle:The Oracle mining database is not configured properly to support integrated capture. The following configur
ation error must be fixed:Operation not supported because enable_goldengate_replication is not set to true.
2017-10-16 02:01:48INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:01:54INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): miningdblogin userid ogg@orcl1 password ***.
2017-10-16 02:01:59INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): register extract ext1 database.
2017-10-16 02:02:06INFO    OGG-02003Oracle GoldenGate Command Interpreter for Oracle:Extract EXT1 successfully registered with database at SCN 1015610.
2017-10-16 02:02:48INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:07:54INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:07:59INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add schematrandata scott.
2017-10-16 02:07:59INFO    OGG-01788Oracle GoldenGate Command Interpreter for Oracle:SCHEMATRANDATA has been added on schema scott.
2017-10-16 02:07:59INFO    OGG-01976Oracle GoldenGate Command Interpreter for Oracle:SCHEMATRANDATA for scheduling columns has been added on schema scott.
2017-10-16 02:08:26INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW.
2017-10-16 02:08:51INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:09:10INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:10:24INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): add exttrail ./dirdat/lrextract ext1, megabytes 200.
2017-10-16 02:10:26INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:10:29INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:10:29INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48521 (START EXTRACT EXT1 ).
2017-10-16 02:10:29INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:10:29INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:10:29INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:10:29INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:10:29INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:10:29ERROR   OGG-10151Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, parameter has unrecognized keyword or extra value "oracle"
.
2017-10-16 02:10:29ERROR   OGG-10151Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, parameter has unrecognized keyword or extra value "passwor
d".
2017-10-16 02:10:29ERROR   OGG-10151Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, parameter has unrecognized keyword or extra value "ogg@orc
l1".
2017-10-16 02:10:29ERROR   OGG-10151Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, parameter has unrecognized keyword or extra value "userid"
.
2017-10-16 02:10:29ERROR   OGG-10151Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, parameter has unrecognized keyword or extra value "miningd
blogin".
2017-10-16 02:10:29ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:10:31INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:10:33INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:11:59INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:12:49INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:12:49INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48559 (START EXTRACT EXT1 ).
2017-10-16 02:12:49INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:12:49INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:12:49INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:12:49INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:12:49INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:12:49WARNING OGG-10143Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parameter is unrecognized and will be ignored.No parameter definition wi
th that name could be found.
2017-10-16 02:12:49INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:12:49ERROR   OGG-00303Oracle GoldenGate Capture for Oracle, ext1.prm:Unrecognized parameter (miningdblogin).
2017-10-16 02:12:49ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:12:50INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:15:18INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:16:07INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:16:07INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48612 (START EXTRACT EXT1 ).
2017-10-16 02:16:07INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:16:07INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:16:07INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:16:07INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:16:07INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:16:07ERROR   OGG-10152Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, option for parameter has unrecognized value "
oracle".
2017-10-16 02:16:07ERROR   OGG-10152Oracle GoldenGate Capture for Oracle, ext1.prm:(ext1.prm) line 3: Parsing error, option for parameter has unrecognized value "
password".
2017-10-16 02:16:07ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:16:15INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:17:07INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:17:24INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:17:24INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48634 (START EXTRACT EXT1 ).
2017-10-16 02:17:24INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:17:24INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:17:24INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:17:24INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:17:24INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:17:24INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:17:24WARNING OGG-04033Oracle GoldenGate Capture for Oracle, ext1.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:17:24INFO    OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:17:25INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.
2017-10-16 02:17:25INFO    OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 139880133555968.
2017-10-16 02:17:25INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2017-10-16 02:17:26INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:17:28INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:17:29ERROR   OGG-02032Oracle GoldenGate Capture for Oracle, ext1.prm:Failed to set TRANLOGOPTIONS INTEGRATEDPARAMS (DOWNSTREAM_REAL_TIME_MINE, Y).
2017-10-16 02:17:29ERROR   OGG-02042Oracle GoldenGate Capture for Oracle, ext1.prm:OCI Error 26761.
2017-10-16 02:17:29ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:17:45INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:18:10INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:18:21INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): edit params ext1.
2017-10-16 02:18:37INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:18:38INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:18:38INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48656 (START EXTRACT EXT1 ).
2017-10-16 02:18:38INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:18:38INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:18:39INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:18:39INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:18:39INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:18:39INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:18:39WARNING OGG-04033Oracle GoldenGate Capture for Oracle, ext1.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:18:39INFO    OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:18:39INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.
2017-10-16 02:18:39INFO    OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 140199436269312.
2017-10-16 02:18:39INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2017-10-16 02:18:39WARNING OGG-02045Oracle GoldenGate Capture for Oracle, ext1.prm:Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:18:39INFO    OGG-02248Oracle GoldenGate Capture for Oracle, ext1.prm:Logmining server DDL filtering enabled.
2017-10-16 02:18:40INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:18:40INFO    OGG-02068Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:18:41INFO    OGG-02089Oracle GoldenGate Capture for Oracle, ext1.prm:Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:18:41INFO    OGG-02086Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated Dictionary will be used.
2017-10-16 02:18:41WARNING OGG-02901Oracle GoldenGate Capture for Oracle, ext1.prm:Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:18:41WARNING OGG-02083Oracle GoldenGate Capture for Oracle, ext1.prm:DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:18:41ERROR   OGG-02912Oracle GoldenGate Capture for Oracle, ext1.prm:Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:18:41ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:18:43INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:19:06INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:19:46INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:20:31INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:24:49INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:24:52INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:24:52INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48758 (START EXTRACT EXT1 ).
2017-10-16 02:24:52INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:24:52INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:24:52INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:24:52INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:24:52INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:24:52INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:24:52WARNING OGG-04033Oracle GoldenGate Capture for Oracle, ext1.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:24:52INFO    OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:24:52INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.
2017-10-16 02:24:52INFO    OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 140685021243136.
2017-10-16 02:24:52INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2017-10-16 02:24:53WARNING OGG-02045Oracle GoldenGate Capture for Oracle, ext1.prm:Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:24:53INFO    OGG-02248Oracle GoldenGate Capture for Oracle, ext1.prm:Logmining server DDL filtering enabled.
2017-10-16 02:24:54INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:24:54INFO    OGG-02068Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:24:54INFO    OGG-02089Oracle GoldenGate Capture for Oracle, ext1.prm:Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:24:54INFO    OGG-02086Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated Dictionary will be used.
2017-10-16 02:24:54WARNING OGG-02901Oracle GoldenGate Capture for Oracle, ext1.prm:Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:24:54WARNING OGG-02083Oracle GoldenGate Capture for Oracle, ext1.prm:DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:24:55ERROR   OGG-02912Oracle GoldenGate Capture for Oracle, ext1.prm:Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:24:55ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:25:12INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:27:36INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:27:39INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:27:39INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48807 (START EXTRACT EXT1 ).
2017-10-16 02:27:39INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:27:39INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:27:39INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:27:39INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:27:39INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:27:40INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:27:40WARNING OGG-04033Oracle GoldenGate Capture for Oracle, ext1.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:27:40INFO    OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:27:40INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.
2017-10-16 02:27:40INFO    OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 140525671798528.
2017-10-16 02:27:40INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2017-10-16 02:27:40WARNING OGG-02045Oracle GoldenGate Capture for Oracle, ext1.prm:Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:27:40INFO    OGG-02248Oracle GoldenGate Capture for Oracle, ext1.prm:Logmining server DDL filtering enabled.
2017-10-16 02:27:41INFO    OGG-02068Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:27:41INFO    OGG-02089Oracle GoldenGate Capture for Oracle, ext1.prm:Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:27:41INFO    OGG-02086Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated Dictionary will be used.
2017-10-16 02:27:41WARNING OGG-02901Oracle GoldenGate Capture for Oracle, ext1.prm:Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:27:41WARNING OGG-02083Oracle GoldenGate Capture for Oracle, ext1.prm:DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:27:41ERROR   OGG-02912Oracle GoldenGate Capture for Oracle, ext1.prm:Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:27:41ERROR   OGG-01668Oracle GoldenGate Capture for Oracle, ext1.prm:PROCESS ABENDING.
2017-10-16 02:27:42INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:28:00INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:31:13INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
2017-10-16 02:31:15INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): start ext1.
2017-10-16 02:31:15INFO    OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host :48866 (START EXTRACT EXT1 ).
2017-10-16 02:31:15INFO    OGG-00960Oracle GoldenGate Manager for Oracle, mgr.prm:Access granted (rule #5).
2017-10-16 02:31:15INFO    OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXT1 starting.
2017-10-16 02:31:15INFO    OGG-00992Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 starting.
2017-10-16 02:31:15INFO    OGG-03059Oracle GoldenGate Capture for Oracle, ext1.prm:Operating system character set identified as US-ASCII.
2017-10-16 02:31:15INFO    OGG-02695Oracle GoldenGate Capture for Oracle, ext1.prm:ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:31:16INFO    OGG-03522Oracle GoldenGate Capture for Oracle, ext1.prm:Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:31:16WARNING OGG-04033Oracle GoldenGate Capture for Oracle, ext1.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:31:16INFO    OGG-01635Oracle GoldenGate Capture for Oracle, ext1.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:31:16INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/BR/EXT1.
2017-10-16 02:31:16INFO    OGG-01851Oracle GoldenGate Capture for Oracle, ext1.prm:filecaching started: thread ID: 140002868037376.
2017-10-16 02:31:16INFO    OGG-01815Oracle GoldenGate Capture for Oracle, ext1.prm:Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)anon free: munmap
    file alloc: mmap(MAP_SHARED)file free: munmap
    target directories:
    /u01/ogg/dirtmp.
2017-10-16 02:31:16WARNING OGG-02045Oracle GoldenGate Capture for Oracle, ext1.prm:Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:31:16INFO    OGG-02248Oracle GoldenGate Capture for Oracle, ext1.prm:Logmining server DDL filtering enabled.
2017-10-16 02:31:17INFO    OGG-02068Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:31:17INFO    OGG-02089Oracle GoldenGate Capture for Oracle, ext1.prm:Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:31:17INFO    OGG-02086Oracle GoldenGate Capture for Oracle, ext1.prm:Integrated Dictionary will be used.
2017-10-16 02:31:17WARNING OGG-02901Oracle GoldenGate Capture for Oracle, ext1.prm:Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:31:17WARNING OGG-02083Oracle GoldenGate Capture for Oracle, ext1.prm:DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:31:17INFO    OGG-00993Oracle GoldenGate Capture for Oracle, ext1.prm:EXTRACT EXT1 started.
2017-10-16 02:31:17INFO    OGG-01052Oracle GoldenGate Capture for Oracle, ext1.prm:No recovery is required for target file ./dirdat/lr000000000, at RBA 0 (file not opened).
2017-10-16 02:31:17INFO    OGG-01478Oracle GoldenGate Capture for Oracle, ext1.prm:Output file ./dirdat/lr is using format RELEASE 12.2.
2017-10-16 02:31:18INFO    OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.






下游抽取进程ext1正常启动：



GGSCI (dg2) 6>info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   RUNNING   EXT1      00:04:46      00:00:01   





此时上游数据库未执行DML DDL 操作，ext1 抽取进程未捕获相关事务：


GGSCI (dg2) 7>

GGSCI (dg2) 7>

GGSCI (dg2) 7>

GGSCI (dg2) 7> stats ext1

Sending STATS request to EXTRACT EXT1 ...




No active extraction maps
DDL replication statistics (for all trails):

*** Total statistics since extract started   ***
      Operations                                       0.00
      Mapped operations                                  0.00
      Unmapped operations                              0.00
      Other operations                                 0.00
      Excluded operations                              0.00
.


GGSCI (dg2) 8>
GGSCI (dg2) 8>
GGSCI (dg2) 8>
GGSCI (dg2) 8> exit
$
$
$
$
$




登录上游数据库被复制用户scott,执行 ddl dml 操作并提交,并执行
alter system switch logfile命令，使归档日志传送到下有数据库
log_archive_dest_2 目录以使ext1抽取相关操作：




$ sqlplus scott/oracle@orcl

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:32:26 2017

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


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

SQL> select tname from tab;

TNAME
------------------------------
BONUS
DEPT
EMP
SALGRADE


SQL> create table ttt as select * from user_objects;

Table created.

SQL> select tname from tab;

TNAME
------------------------------
BONUS
DEPT
EMP
SALGRADE
TTT


SQL> delete from emp;

14 rows deleted.

SQL> commit;

Commit complete.
SQL> alter system switch logfile;
/
/
/

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$






下游主机dg2登录ggsci,验证相关操作被正常抽取：



$
$
$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

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



GGSCI (dg2) 1> info all

Program   Status      Group       Lag at ChkptTime Since Chkpt

MANAGER   RUNNING                                          
EXTRACT   RUNNING   EXT1      00:05:56      00:00:05   


GGSCI (dg2) 2> stats ext1

Sending STATS request to EXTRACT EXT1 ...

Start of Statistics at 2017-10-16 02:36:58.

DDL replication statistics (for all trails):

*** Total statistics since extract started   ***
      Operations                                       1.00
      Mapped operations                                  1.00
      Unmapped operations                              0.00
      Other operations                                 0.00
      Excluded operations                              0.00

Output to ./dirdat/lr:

Extracting from SCOTT.EMP to SCOTT.EMP:

*** Total statistics since 2017-10-16 02:36:28 ***
      Total inserts                                    0.00
      Total updates                                    0.00
      Total deletes                                     14.00
      Total discards                                     0.00
      Total operations                                  14.00

*** Daily statistics since 2017-10-16 02:36:28 ***
      Total inserts                                    0.00
      Total updates                                    0.00
      Total deletes                                     14.00
      Total discards                                     0.00
      Total operations                                  14.00

*** Hourly statistics since 2017-10-16 02:36:28 ***
      Total inserts                                    0.00
      Total updates                                    0.00
      Total deletes                                     14.00
      Total discards                                     0.00
      Total operations                                  14.00

*** Latest statistics since 2017-10-16 02:36:28 ***
      Total inserts                                    0.00
      Total updates                                    0.00
      Total deletes                                     14.00
      Total discards                                     0.00
      Total operations                                  14.00

End of Statistics.


GGSCI (dg2) 3>


告警1：
2017-10-16 02:18:39WARNING OGG-02045Database does not have streams_pool_size initialization parameter configured.

处理：

上游及下游数据库设置streams_pool_size 参数大小

alter system set streams_pool_size=512M scope=both;



告警2：
2017-10-16 02:18:41WARNING OGG-02901Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.


处理：

忽略




告警3：
2017-10-16 02:18:41WARNING OGG-02083DDLOPTIONS with ADDTRANDATA is no longer supported.


处理：

注销相关行
GGSCI (dg2 as ogg@orcl) 10> edit params ext1
extract ext1
userid ogg@orcl,password oracle
tranlogoptions mininguser ogg,miningpassword oracle
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS
----DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*;

dongxujian 发表于 2017-10-20 09:39:47

这个步骤有点问题，以后发改进版吧

查看完整版本: goldengate 12.2.0.1.1 downstream capture 集成抽取downstream捕获方式