OGG复制进程出现 OGG-00868， 904-ORA-00904 "VISIBILITY"

OGG无论是源端还是目标端出现 904-ORA-00904: “VISIBILITY”错误时，常见问题之一就是OGG软件版本和数据库版本不匹配。 比如OGG11.2.1.0.1版本for oracle10g和for oracle11g很容易在下载介质时候搞错。 如果数据库是10.2.0.4版本，OGG用的是11.2.1.0.1 for 11g版本，在同步的时候就会出现下列报错。这是个低级错误，也是比较容易出现的错误。 下面来看看“事故现场”

目标端复制进程中断,错误信息如下所示：

cd $OGG_HOME

tail -100f ggserr.log 

2015-07-13 09:16:49  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rt1.prm:  REPLICAT RT1 started.

2015-07-13 09:16:49  ERROR   OGG-00868  Oracle GoldenGate Delivery for Oracle, rt1.prm:  OCI error (904-ORA-00904: "VISIBILITY": invalid identifier) building query to fetch unique key, SQL < SELECT key.key_name,         key.column_name,         key.descend    FROM (SELECT  c.constraint_name key_name,                 c.column_name column_name,                 c.position position,                 'ASC' descend            FROM all_cons_columns c           WHERE c.owner = :owner1             AND c.table_name = :table1             AND c.constraint_name in (                   SELECT  con1.name                     FROM sys.user$ user1,                          sys.user$ user2,                          sys.cdef$ cdef,                          sys.con$ con1,                          sys.con$ con2,                          sys.obj$ obj1,                          sys.obj$ obj2                    WHERE user1.name = :owner2                      AND obj1.name = :table2                      AND cdef.type# = 3                      AND bitand(cdef.defer, 36) = 4                      AND (cdef.type# = 5 OR                           cdef.enabled is not null)                      AND con2.owner# = user2.user#(+)                      AND cdef.robj# = obj2.obj#(+)                      AND cdef.rcon# = con2.con#(+)                      AND obj1.owner# = user1.user#                      AND cdef.con# = con1.con#                      AND cdef.obj# = obj1.obj#)           UNION           SELECT  i.index_name key_name,                  c.column_name column_name,                  c.column_position position,                  c.descend descend             FROM all_indexes i,                  all_ind_columns c            WHERE i.table_owner = :owner3              AND i.table_name = :table3              AND i.uniqueness = 'UNIQUE'              AND i.owner = c.index_owner              AND i.index_name = c.index_name              AND :owner7 = c.table_owner              AND :table7 = c.table_name              AND i.index_name in (                   SELECT  index_name                     FROM all_indexes                    WHERE table_.

2015-07-13 09:16:49  ERROR   OGG-00665  Oracle GoldenGate Delivery for Oracle, rt1.prm:  OCI Error describe for query (status = 904-ORA-00904: "VISIBILITY": invalid identifier), SQL< SELECT key.key_name,         key.column_name,         key.descend    FROM (SELECT  c.constraint_name key_name,                 c.column_name column_name,                 c.position position,                 'ASC' descend            FROM all_cons_columns c           WHERE c.owner = :owner1             AND c.table_name = :table1             AND c.constraint_name in (                   SELECT  con1.name                     FROM sys.user$ user1,                          sys.user$ user2,                          sys.cdef$ cdef,                          sys.con$ con1,                          sys.con$ con2,                          sys.obj$ obj1,                          sys.obj$ obj2                    WHERE user1.name = :owner2                      AND obj1.name = :table2                      AND cdef.type# = 3                      AND bitand(cdef.defer, 36) = 4                      AND (cdef.type# = 5 OR                           cdef.enabled is not null)                      AND con2.owner# = user2.user#(+)                      AND cdef.robj# = obj2.obj#(+)                      AND cdef.rcon# = con2.con#(+)                      AND obj1.owner# = user1.user#                      AND cdef.con# = con1.con#                      AND cdef.obj# = obj1.obj#)           UNION           SELECT  i.index_name key_name,                  c.column_name column_name,                  c.column_position position,                  c.descend descend             FROM all_indexes i,                  all_ind_columns c            WHERE i.table_owner = :owner3              AND i.table_name = :table3              AND i.uniqueness = 'UNIQUE'              AND i.owner = c.index_owner              AND i.index_name = c.index_name              AND :owner7 = c.table_owner              AND :table7 = c.table_name              AND i.index_name in (                   SELECT  index_name                     FROM all_indexes                    WHERE table_owner = .

2015-07-13 09:16:49  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rt1.prm:  PROCESS ABENDING.

 

源端数据库版本10.2.0.4.4

源端OGG版本如下：

cd $OGG_HOME

./ggsci

 

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Apr 23 2012 07:27:46

 

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

 

 

 

GGSCI (bejsym02) 1> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     RUNNING     DP1         00:00:00      00:00:01   

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

 

目标端数据库版本10.2.0.4.8

目标端OGG版本如下：

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.6 16211226 OGGCORE_11.2.1.0.6_PLATFORMS_130418.1829

HP/UX, IA64, 64bit (optimized), Oracle 11g on Apr 18 2013 20:29:17  

version不一致不要紧，但是for oracle11g就肯定不行了！

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

 

 

GGSCI (bejtdb01) 1> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

REPLICAT    ABENDED     RT1         00:00:22      56:35:41 

解决问题很简单，重新下载 for 10g版本的介质。

我的环境是异构的，源端AIX，目标端HPUX。 目标端下载介质位置如下：

https://edelivery.oracle.com

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29047826/viewspace-1731357/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29047826/viewspace-1731357/