Oracle技术专区 收藏本版 已有160 收藏本版 发新帖

dongxujian

高级会员

  1. 84 主题
  2. 168 评论
  3. 7 关注
  • 1今日版块发帖数
  • 11昨日版块发帖数
  • 1823昨日版块发帖数
  • 160板块关注人数

相关帖子

鸟哥的Linux私房菜服务器架设篇(第三版)
Linux6.5安装Oracle-11g-RAC(1)【视频教
Oracle.11g.从入门到精通
linux下安装oracle
Linux6.5安装Oracle-11g-RAC(2)【视频教

客服中心

010-63942882

服务时段:9:00-20:00

[分享] goldengate 12.2.0.1.1 downstream capture 集成抽取downstream捕获方式

[复制链接]
发表于 2017-10-19 22:06:27 | 显示全部楼层 |阅读模式
1.两主机IP及主机名称规划,dg2 为下端捕获数据库:



[oracle@dg2 ~]$ hostname
dg2
[oracle@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
[oracle@dg2 ~]$ 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
[oracle@dg2 ~]$ arch
x86_64
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$


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

   添加到上游数据库连接串                                                                                                                                 
[oracle@dg2 admin]$ 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)
    )
  )
测试网络连通性:


[oracle@dg2 admin]$ 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)
[oracle@dg2 admin]$ 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)
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$

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


[oracle@dg2 admin]$ 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:
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@dg1 admin]$ vi tnsnames.ora                                                                                                                                               
[oracle@dg1 admin]$ 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)
    )
  )

[oracle@dg1 admin]$
[oracle@dg1 admin]$
[oracle@dg1 admin]$

   测试网络连通性:
   
[oracle@dg1 admin]$ 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)
[oracle@dg1 admin]$ 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)
[oracle@dg1 admin]$




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

[oracle@dg1 admin]$
[oracle@dg1 admin]$ 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.目标端数据调整为归档模式:



[oracle@dg2 admin]$ 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 安装要求:


[oracle@dg2 admin]$
[oracle@dg2 admin]$ 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 supplemental  log 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安装要求:


[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$ 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
[oracle@dg2 admin]$
[oracle@dg2 admin]$

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


[oracle@dg2 admin]$ 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 软件:

[oracle@dg2 admin]$ hostname
dg2

[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$ mkdir -p /u01/ogg
[oracle@dg2 admin]$ cd /u01/ogg
[oracle@dg2 ogg]$ pwd
/u01/ogg
[oracle@dg2 ogg]$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb  3  2016 V100692-01.zip
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ cd                                                                                                                                    
[oracle@dg2 ~]$ 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/binORACLE_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

[oracle@dg2 ~]$ echo $GGHOME

[oracle@dg2 ~]$ source .bash_profile
[oracle@dg2 ~]$ echo $GGHOME
/u01/ogg
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 ogg]$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb  3  2016 V100692-01.zip
[oracle@dg2 ogg]$ 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  
[oracle@dg2 ogg]$ exit
logout
[root@dg2 ~]# export DISPLAY=192.168.1.1:0.0
[root@dg2 ~]# XHOST +
-bash: XHOST: command not found
[root@dg2 ~]# xhost +
access control disabled, clients can connect from any host
[root@dg2 ~]# su - oracle
[oracle@dg2 ~]$ xhost +
access control disabled, clients can connect from any host
[oracle@dg2 ~]$ ls
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 ogg]$ ls
fbo_ggs_Linux_x64_shiphome  OGG-12.2.0.1.1-ReleaseNotes.pdf  OGG-12.2.0.1-README.txt  V100692-01.zip
[oracle@dg2 ogg]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/
[oracle@dg2 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) [n] y


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

[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$


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


[oracle@dg2 Disk1]$ cd
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 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> info all

Program     Status      Group       Lag at Chkpt  Time 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 Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          


GGSCI (dg2) 5>

GGSCI (dg2) 5>

GGSCI (dg2) 5>

GGSCI (dg2) 5> exit


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


[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ ssh dg1
oracle@dg1's password:
Last login: Mon Oct 16 01:30:03 2017 from dg2
[oracle@dg1 trace]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
[oracle@dg1 trace]$ tail -20f alert_orcl.log
------------------------------------------------------------
PING[ARC2]: 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[ARC2]: 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[ARC2]: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.



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

    拷贝口令文件至下游主机dg2:
[oracle@dg1 trace]$ cd $ORACLE_HOME/dbs/
-rw-r-----. 1 oracle oinstall 1536 Aug  8  2015 orapworcl

[oracle@dg1 dbs]$ 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   
[oracle@dg1 dbs]$
   下游主机重命名口令文件:
[oracle@dg2 ogg]$ cd $ORACLE_HOME/dbs
[oracle@dg2 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 15  2009 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
[oracle@dg2 dbs]$ mv orapworcl orapworcl1
[oracle@dg2 dbs]$ ls -ltr
total 20
-rw-r--r--. 1 oracle oinstall 2851 May 15  2009 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:


[oracle@dg2 dbs]$
[oracle@dg2 dbs]$
[oracle@dg2 dbs]$
[oracle@dg2 dbs]$ cd $GGHOME
[oracle@dg2 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> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          


GGSCI (dg2) 2> exit
[oracle@dg2 ogg]$ 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.


[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 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>

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:53  ERROR   OGG-02060  The 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
[oracle@dg2 ogg]$ 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:59  INFO    OGG-01788  SCHEMATRANDATA has been added on schema scott.

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

GGSCI (dg2 as ogg@orcl) 8>


重新注册下端流集成抽取进程ext1:
[oracle@dg2 ogg]$ pwd
/u01/ogg
[oracle@dg2 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:06  INFO    OGG-02003  Extract 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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:39  INFO    OGG-03059  Operating system character set identified as US-ASCII.

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

2017-10-16 02:18:39  INFO    OGG-03522  Setting 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:39  WARNING 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:39  INFO    OGG-01635  BOUNDED RECOVERY: reset to initial or altered checkpoint.

2017-10-16 02:18:39  INFO    OGG-01815  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.

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

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

2017-10-16 02:18:39  INFO    OGG-01815  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.

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:39  WARNING OGG-02045  Database does not have streams_pool_size initialization parameter configured.

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

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

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

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

2017-10-16 02:18:41  WARNING OGG-02901  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:41  WARNING OGG-02083  DDLOPTIONS with ADDTRANDATA is no longer supported.

Source Context :
  SourceModule            : [ggdb.ora.ddl]
  SourceID                : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbora/ddlora.c]
  SourceFunction          : [metadata_from_logminer]
  SourceLine              : [971]
  ThreadBacktrace         : [14] elements
                          : [/u01/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f82c3246f1b]]
                          : [/u01/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f82c32410a4]]
                          : [/u01/ogg/libgglog.so(_MSG_ERR_INTEGRATED_DICT_MISSING_PATCH(CSourceContext*, CMessageFactory::MessageDisposition)+0x29) [0x7f82c3211965]]
                          : [/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) [0x6fdba4]]
                          : [/u01/ogg/extract() [0x76204f]]
                          : [/u01/ogg/extract(REDO_validate_config(bool, unsigned int*, bool&)+0x72e) [0x7687ee]]
                          : [/u01/ogg/extract(ggs::er::OraTranLogDataSource::setup()+0x6c) [0x75bd2c]]
                          : [/u01/ogg/extract() [0x5f3c56]]
                          : [/u01/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d05b0]]
                          : [/u01/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d179d]]
                          : [/u01/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d1881]]
                          : [/u01/ogg/extract(main+0x3b) [0x5f50eb]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x33e281ecdd]]
                          : [/u01/ogg/extract() [0x563159]]

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

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


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



上传接下相关补丁:

GGSCI (dg2 as ogg@orcl) 50> exit
[oracle@dg2 ogg]$ cd
[oracle@dg2 ~]$ ls
p17030189_112040_Generic.zip
[oracle@dg2 ~]$ 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  
  
关闭下游数据库,准备打补丁:
      
[oracle@dg2 ~]$ 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
[oracle@dg2 ~]$ ls -l
total 68
drwxrwxr-x. 4 oracle oinstall  4096 May 26  2015 17030189
-rw-r--r--. 1 root   root     57558 Mar  3  2016 p17030189_112040_Generic.zip
-rw-rw-r--. 1 oracle oinstall  2344 May 26  2015 PatchSearch.xml

[oracle@dg2 17030189]$ pwd
/home/oracle/17030189
[oracle@dg2 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 脚本:


[oracle@dg2 17030189]$ 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:


[oracle@dg2 17030189]$ cd $GGHOME
[oracle@dg2 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> info all

Program     Status      Group       Lag at Chkpt  Time 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 Chkpt  Time Since Chkpt

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




GGSCI (dg2) 5> view ggsevt

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






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



GGSCI (dg2) 6>  info all

Program     Status      Group       Lag at Chkpt  Time 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
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$




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




[oracle@dg2 ogg]$ 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
[oracle@dg2 ogg]$






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



[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 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> info all

Program     Status      Group       Lag at Chkpt  Time 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:39  WARNING OGG-02045  Database 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:41  WARNING OGG-02901  Replication 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:41  WARNING OGG-02083  DDLOPTIONS 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.*;
回复

使用道具 举报

精彩评论 2

跳转到指定楼层
dongxujian 发表于 2017-10-20 09:39:47
这个步骤有点问题,以后发改进版吧
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

甲骨论是什么| 甲骨论   | ( 京ICP备12024223号 )

Copyright © 2017 Bosenrui Inc.   All Rights Reserved.

快速回复 返回顶部 返回列表