10 Replies Latest reply: May 7, 2014 2:27 PM by bs_gill RSS

    GoldenGate replication on the same physical server - REPLICAT always ABENDING

    bs_gill

      Dear GG experts,

       

      I am completely green with Golden Gate, so I would like some help on why my REPLICAT process abends right after I commit rows from my source database object.  I am following the writeup from Gavin Soorma -

       

      http://gavinsoorma.com/2011/08/goldengate-replication-with-source-and-target-on-the-same-physical-host/

       

      I am trying implement CDC on the same physical server.  I have an 11g source database that is using ASM and my target is 10g database which is using traditional filesystem management.  I am simply trying to map one object, ggs_owner.myobjects which I have created in both databases.  Both EXTRACT and REPLICAT startup fine, but as soon as I perform an insert in the 11g database and commit the rows, my REPLICAT process abends. 

       

      Version information:

       

      Oracle GoldenGate Command Interpreter for Oracle
      Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
      Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25

       

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

       

      GGSCI (localhost.localdomain) 3> DBLOGIN userid ggs_owner@ora11g, password ggs_owner
      Successfully logged into database.

       

      GGSCI (localhost.localdomain) 4> VERSIONS
      Operating System:
      Linux
      Version #1 SMP Tue Jan 4 15:24:05 EST 2011, Release 2.6.18-238.el5
      Node: localhost.localdomain
      Machine: i686

       

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

       

      GGSCI (localhost.localdomain) 7> DBLOGIN userid ggs_owner@ora10g, password ggs_owner
      Successfully logged into database.

       

      GGSCI (localhost.localdomain) 8> VERSIONS
      Operating System:
      Linux
      Version #1 SMP Tue Jan 4 15:24:05 EST 2011, Release 2.6.18-238.el5
      Node: localhost.localdomain
      Machine: i686

       

      Database:
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
      PL/SQL Release 10.2.0.1.0 - Production
      CORE    10.2.0.1.0      Production
      TNS for Linux: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production

       

      PRM file contents

       

      EXTRACT Param file contents

      extract extlocal
      setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
      setenv (ORACLE_SID="ora11g")
      userid ggs_owner, password ggs_owner
      rmthost localhost.localdomain , mgrport 7809
      rmttrail ./dirdat/aa
      TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD oracle
      table ggs_owner.myobjects;

       

      REPLICAT param file contents

      REPLICAT replocal
      SETENV (ORACLE_HOME="/opt/oracle/product/10.2.0.1")
      SETENV (ORACLE_SID="ora10g")
      ASSUMETARGETDEFS
      USERID ggs_owner, PASSWORD ggs_owner
      DISCARDFILE ./dirrpt/discard.txt, APPEND, MEGABYTES 20
      MAP ggs_owner.myobjects, TARGET ggs_owner.myobjects, KEYCOLS(object_id);

       

      Performed the following steps in GGSCI:

       

      GGSCI (localhost.localdomain) 103> add extract extlocal tranlog begin now
      EXTRACT added.

       


      GGSCI (localhost.localdomain) 104> add rmttrail ./dirdat/aa extract extlocal
      RMTTRAIL added.

       


      GGSCI (localhost.localdomain) 105> dblogin userid ggs_owner@ora10g, password ggs_owner
      Successfully logged into database.

       

      GGSCI (localhost.localdomain) 106> add replicat replocal exttrail ./dirdat/aa
      ERROR: No checkpoint table specified for ADD REPLICAT.

       


      GGSCI (localhost.localdomain) 107> add replicat replocal exttrail ./dirdat/aa NODBCHECKPOINT
      REPLICAT added.

       


      GGSCI (localhost.localdomain) 108> dblogin userid ggs_owner@ora11g, password ggs_owner
      Successfully logged into database.

       

      GGSCI (localhost.localdomain) 109> start extract extlocal

       

      Sending START request to MANAGER ...
      EXTRACT EXTLOCAL starting

       


      GGSCI (localhost.localdomain) 110> info all

       

      Program     Status      Group       Lag at Chkpt  Time Since Chkpt

       

      MANAGER     RUNNING                                          
      EXTRACT     RUNNING     EXTLOCAL    00:00:00      00:00:02   
      REPLICAT    STOPPED     REPLOCAL    00:00:00      00:01:27   

       


      GGSCI (localhost.localdomain) 111> start replicat replocal

       

      Sending START request to MANAGER ...
      REPLICAT REPLOCAL starting

       


      GGSCI (localhost.localdomain) 112> info all

       

      Program     Status      Group       Lag at Chkpt  Time Since Chkpt

       

      MANAGER     RUNNING                                          
      EXTRACT     RUNNING     EXTLOCAL    00:00:00      00:00:09   
      REPLICAT    RUNNING     REPLOCAL    00:00:00      00:00:04

       

      In another window, I perform the following:

      SQL> connect ggs_owner@ora11g
      Enter password:
      Connected.
      SQL> select count(*) from myobjects;

       

        COUNT(*)
      ----------
           71932

       

      SQL> truncate table myobjects;

       

      Table truncated.

       

      SQL> insert into MYOBJECTS select * from DBA_OBJECTS;

       

      71932 rows created.

       

      SQL> commit;

       

      Commit complete.

       

       

      When I go back to GGSCI, I can see that the process has abended:

       

      GGSCI (localhost.localdomain) 132> info all

       

      Program     Status      Group       Lag at Chkpt  Time Since Chkpt

       

      MANAGER     RUNNING                                          

      EXTRACT     RUNNING     EXTLOCAL    00:00:00      00:00:07   

      REPLICAT    ABENDED     REPLOCAL    00:00:00      00:00:02

       

      When can I look, or what can I add to the REPLICAT param file that would help me identify the root cause.

       

      Any help would be much appreciated.

       

      Thanks,

      Bal 

        • 1. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
          dbasolved

          Bal,

           

          Can you run VIEW REPORT REPLOCAL and post the output.  You will be looking for the information towards the bottom of the report.

           

          Thanks

           

          Bobby

          • 2. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
            dbasolved

            Bal,

             

            Updating here to keep thread clean.

             

            You are trying a truncate.  Are your extracts and replicats setup to replicat truncates?

             

            Bobby

            • 3. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
              bs_gill

              Hi Bobby,

               

              Thanks for your reply.  I haven't configured anything specific for truncates.  After I truncate, REPLICAT still appears to be running. Its after the commit in the source database, the process abends.  Here's the output from VIEW REPORT REPLOCAL:

               

              GGSCI (localhost.localdomain) 11> view report replocal

               


              ***********************************************************************
                               Oracle GoldenGate Delivery for Oracle
                  Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
                 Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:26:04

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

               


                                  Starting at 2014-04-22 13:00:00
              ***********************************************************************

               

              Operating System Version:
              Linux
              Version #1 SMP Tue Jan 4 15:24:05 EST 2011, Release 2.6.18-238.el5
              Node: localhost.localdomain
              Machine: i686
                                       soft limit   hard limit
              Address Space Size   :    unlimited    unlimited
              Heap Size            :    unlimited    unlimited
              File Size            :    unlimited    unlimited
              CPU Time             :    unlimited    unlimited

               

              Process id: 21773

               

              Description:

               

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

               

              2014-04-22 13:00:00  INFO    OGG-03035  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
              REPLICAT replocal
              SETENV (ORACLE_HOME="/opt/oracle/product/10.2.0.1")
              Set environment variable (ORACLE_HOME=/opt/oracle/product/10.2.0.1)
              SETENV (ORACLE_SID="ora10g")
              Set environment variable (ORACLE_SID=ora10g)
              ASSUMETARGETDEFS
              USERID ggs_owner, PASSWORD *********
              DISCARDFILE ./dirrpt/discard.txt, APPEND, MEGABYTES 20
              MAP ggs_owner.myobjects, TARGET ggs_owner.myobjects, KEYCOLS(object_id);

               

              2014-04-22 13:00:00  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/app/ggs/dirtmp.

               

              CACHEMGR virtual memory values (may have been adjusted)
              CACHESIZE:                              512M
              CACHEPAGEOUTSIZE (normal):                4M
              PROCESS VM AVAIL FROM OS (min):           1G
              CACHESIZEMAX (strict force to disk):    881M

               

              Database Version:
              Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
              PL/SQL Release 10.2.0.1.0 - Production
              CORE    10.2.0.1.0      Production
              TNS for Linux: Version 10.2.0.1.0 - Production
              NLSRTL Version 10.2.0.1.0 - Production

               

              Database Language and Character Set:
              NLS_LANG         = "american_america.AL32UTF8"
              NLS_LANGUAGE     = "AMERICAN"
              NLS_TERRITORY    = "AMERICA"
              NLS_CHARACTERSET = "AL32UTF8"

               

              ***********************************************************************
              **                     Run Time Messages                             **
              ***********************************************************************

               

              Opened trail file ./dirdat/aa000000 at 2014-04-22 13:00:00

               

              MAP resolved (entry ggs_owner.myobjects):
                MAP "GGS_OWNER"."MYOBJECTS", TARGET ggs_owner.myobjects, KEYCOLS(object_id);

               

              Bal

              • 4. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                dbasolved

                Bal,

                 

                Your report file looks ok.  I don't see anything out of place.  Is the GGSERR.LOG telling you anything?

                 

                Bobby

                • 5. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                  EmaxG

                  Is that all of the report?  What is the row count on target database?

                   

                  Your truncate does not replicate if you are only replicating DML since TRUNCATE is DDL.  Having said that, is there any chance the table in target already has the data and when you insert and commit in source the replicat abends because the rows are already there and not allowed to be inserted due to PK constraint?

                  • 6. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                    bs_gill

                    Hi N K,

                     

                    Yes, that is all the report.  With regards to the TRUNCATES, I added IGNORETRUNCATES to my replocal.prm file and repeated the steps in my original post, but this issue is clearly when the commit happens.  I can confirm that that the target table is emply.

                     

                    [oracle@localhost ggs]$ sqlplus ggs_owner/ggs_owner@ora11g

                     

                    SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 23 14:03:30 2014

                     

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

                     


                    Connected to:
                    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                    and Real Application Testing options

                     

                    SQL> truncate table MYOBJECTS;

                     

                    Table truncated.

                     

                    SQL> insert into myobjects select * from dba_objects;

                     

                    71932 rows created.

                     

                    SQL> commit;

                     

                    Commit complete.

                     

                    SQL> connect ggs_owner/ggs_owner@ora10g
                    Connected.
                    SQL> select count(*) from myobjects;

                     

                      COUNT(*)
                    ----------
                             0

                     

                    SQL>

                     

                    Keeping the thread clean, I'm also pasting the excerpt of the GGSERR.LOG in response to Bobby's post:

                     

                    2014-04-23 14:04:24  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): delete replicat replocal.
                    2014-04-23 14:04:35  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): delete extract extlocal.
                    2014-04-23 14:07:22  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add extract extlocal tranlog begin now.
                    2014-04-23 14:07:37  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add rmttrail ./dirdat/aa extract extlocal.
                    2014-04-23 14:07:53  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add replicat replocal exttrail ./dirdat/aa.
                    2014-04-23 14:09:04  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): add replicat replocal exttrail ./dirdat/aa CHECKPOINTTABLE ggs_owner.GGS_CHECKPOINT.
                    2014-04-23 14:09:52  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extract extlocal.
                    2014-04-23 14:09:52  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host localhost.localdomain (START EXTRACT EXTLOCAL ).
                    2014-04-23 14:09:52  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXTLOCAL starting.
                    2014-04-23 14:09:52  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, extlocal.prm:  EXTRACT EXTLOCAL starting.
                    2014-04-23 14:09:52  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
                    2014-04-23 14:09:52  INFO    OGG-03500  Oracle GoldenGate Capture for Oracle, extlocal.prm:  WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of WE8MSWIN1252.
                    2014-04-23 14:09:52  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, extlocal.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.
                    2014-04-23 14:09:52  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, extlocal.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/app/ggs/BR/EXTLOCAL.
                    2014-04-23 14:09:52  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, extlocal.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/app/ggs/dirtmp.

                    2014-04-23 14:09:52  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, extlocal.prm:  No valid default archive log destination directory found for thread 1.
                    2014-04-23 14:09:53  INFO    OGG-01515  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Positioning to begin time Apr 23, 2014 2:07:22 PM.
                    2014-04-23 14:09:54  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Positioned to Sequence 62, RBA 35359248, SCN 0.0, Apr 23, 2014 2:07:22 PM.
                    2014-04-23 14:09:54  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, extlocal.prm:  EXTRACT EXTLOCAL started.
                    2014-04-23 14:09:54  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host localhost.localdomain (START SERVER CPU -1 PRI -1  TIMEOUT 300 PARAMS ).
                    2014-04-23 14:09:54  INFO    OGG-01677  Oracle GoldenGate Collector for Oracle:  Waiting for connection (started dynamically).
                    2014-04-23 14:09:54  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from SERVER on host localhost.localdomain (REPORT 32747 7819).
                    2014-04-23 14:09:54  INFO    OGG-00974  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started collector process (Port 7819).
                    2014-04-23 14:09:54  INFO    OGG-01228  Oracle GoldenGate Collector for Oracle:  Timeout in 300 seconds.
                    2014-04-23 14:09:59  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Socket buffer size set to 27985 (flush size 27985).
                    2014-04-23 14:09:59  INFO    OGG-01229  Oracle GoldenGate Collector for Oracle:  Connected to localhost.localdomain:60672.
                    2014-04-23 14:09:59  INFO    OGG-01052  Oracle GoldenGate Capture for Oracle, extlocal.prm:  No recovery is required for target file ./dirdat/aa000000, at RBA 0 (file not opened).
                    2014-04-23 14:09:59  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Output file ./dirdat/aa is using format RELEASE 11.2.
                    2014-04-23 14:09:59  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening ./dirdat/aa000000 (byte -1, current EOF 0).
                    2014-04-23 14:09:59  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, extlocal.prm:  Position of first record processed Sequence 62, RBA 35359248, SCN 0.1891153, Apr 23, 2014 2:07:24 PM.
                    2014-04-23 14:10:29  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start replicat replocal.
                    2014-04-23 14:10:29  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host localhost.localdomain (START REPLICAT REPLOCAL ).
                    2014-04-23 14:10:29  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPLOCAL starting.
                    2014-04-23 14:10:29  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, replocal.prm:  REPLICAT REPLOCAL starting.
                    2014-04-23 14:10:29  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, replocal.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
                    2014-04-23 14:10:29  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, replocal.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/app/ggs/dirtmp.
                    2014-04-23 14:10:29  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, replocal.prm:  REPLICAT REPLOCAL started.
                    2014-04-25 07:44:04  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, extlocal.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p32704_extr: start=SeqNo: 63, RBA: 7678992, SCN: 0.1891830 (1891830), Timestamp: 2014-04-23 14:11:29.000000, Thread: 1, end=SeqNo: 63, RBA: 7682048, SCN: 0.1891830 (1891830), Timestamp: 2014-04-23 14:11:29.000000, Thread: 1.

                    • 7. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                      stevencallan

                      The GG owner is used to extract/replicate or map *other* users, not its own objects. Do you put user data into the system tablespace, or use system to do its own thing for non-Oracle data? No. Then why would you use the GoldenGate user to do essentially the same thing? Don't.

                       

                      "I haven't configured anything specific for truncates." Therein lies your problem. Where is your DDL parameter?

                       

                      7.6 Enabling DDL support

                      By default, the status of DDL replication support is as follows:

                      ■ On the source, Oracle GoldenGate DDL support is disabled by default. You must

                      configure Extract to capture DDL by using the DDL parameter.

                      ■ On the target, DDL support is enabled by default, to maintain the integrity of

                      transactional data that is replicated. By default, Replicat will process all DDL

                      operations that the trail contains. If needed, you can use the DDL parameter to

                      configure Replicat to ignore or filter DDL operations.

                      • 8. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                        bs_gill

                        Hi Steven,

                         

                        Thanks for your reply.  I have been following the example from Gavin Soorma mentioned in my first post.  I understand your explanation that the ggs_owner user should not be used to map its own objects, but I'm simply following Gavin's example on how to setup Golden Gate when source and target are on the same server, and this is how he has setup his test case.

                         

                        Thanks,

                        Bal

                        • 9. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                          bs_gill

                          Hi Steven,

                           

                          I decided to stop trying to replicate a copy of DBA_OBJECTS as GGS_OWNER.MYOBJECTS and created a smaller table instead called GOLDEN with one column called GOLD.  This table exists on both the source, an 11g database, and on the target, a 10g database.

                           

                          SQL> desc GOLDEN
                          Name                                      Null?    Type
                          ----------------------------------------- -------- ----------------------------
                          GOLD                                               NUMBER(10)

                           

                           

                           

                          I changed my extract and replicat param files to reflect this:

                           

                          extract extlocal
                          setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
                          setenv (ORACLE_SID="ora11g")
                          userid ggs_owner, password ggs_owner
                          rmthost localhost.localdomain , mgrport 7809
                          rmttrail ./dirdat/aa
                          TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD oracle

                          ddl include all
                          table ggs_owner.golden;

                           

                          REPLICAT replocal
                          SETENV (ORACLE_HOME="/opt/oracle/product/10.2.0.1")
                          SETENV (ORACLE_SID="ora10g")
                          ASSUMETARGETDEFS
                          USERID ggs_owner@ora10g, PASSWORD ggs_owner
                          DISCARDFILE ./dirrpt/discard.txt, APPEND, MEGABYTES 20
                          ddl include all
                          MAP ggs_owner.golden, TARGET ggs_owner.golden, KEYCOLS(gold);

                           

                          I do not perform any DDL, i.e. truncate of the table GOLDEN whilst EXTRACT is running, I simply insert a row into GOLDEN from the source database.

                           

                          SQL> connect ggs_owner@ora11g
                          Enter password:
                          Connected.

                           

                          SQL> insert into golden values(1);
                          1 row created.

                           

                          SQL> commit;

                           

                          Commit complete.

                           

                          I seemed to be getting more information out of Golden Gate but the REPLICAT still abends.  Here's what's at the end of the GGSERR.LOG :

                           

                          2014-04-29 08:36:20  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, replocal.prm:  REPLICAT REPLOCAL started.
                          2014-04-29 08:36:37  ERROR   OGG-00665  Oracle GoldenGate Delivery for Oracle, replocal.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 = :own.
                          2014-04-29 08:36:37  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, replocal.prm:  PROCESS ABENDING.

                           

                          I think I know the reason why but not sure how to resolve it.  It looks like EXTRACT is performing the above query but can't find the column VISIBILITY from ALL_INDEXES, as this column does not exist in 10g, and only exists from 11g onwards to my knowledge.  Any help in identifying where I have slipped up would be greatly appreciated.

                           

                          SQL> connect ggs_owner@ora10g
                          Enter password:
                          Connected.

                          SQL> desc all_indexes;
                          Name                                      Null?    Type
                          ----------------------------------------- -------- ----------------------------
                          OWNER                                     NOT NULL VARCHAR2(30)
                          INDEX_NAME                                NOT NULL VARCHAR2(30)
                          INDEX_TYPE                                         VARCHAR2(27)
                          TABLE_OWNER                               NOT NULL VARCHAR2(30)
                          TABLE_NAME                                NOT NULL VARCHAR2(30)
                          TABLE_TYPE                                         CHAR(5)
                          UNIQUENESS                                         VARCHAR2(9)
                          COMPRESSION                                        VARCHAR2(8)
                          PREFIX_LENGTH                                      NUMBER
                          TABLESPACE_NAME                                    VARCHAR2(30)
                          INI_TRANS                                          NUMBER
                          MAX_TRANS                                          NUMBER
                          INITIAL_EXTENT                                     NUMBER
                          NEXT_EXTENT                                        NUMBER
                          MIN_EXTENTS                                        NUMBER
                          MAX_EXTENTS                                        NUMBER
                          PCT_INCREASE                                       NUMBER
                          PCT_THRESHOLD                                      NUMBER
                          INCLUDE_COLUMN                                     NUMBER
                          FREELISTS                                          NUMBER
                          FREELIST_GROUPS                                    NUMBER
                          PCT_FREE                                           NUMBER
                          LOGGING                                            VARCHAR2(3)
                          BLEVEL                                             NUMBER
                          LEAF_BLOCKS                                        NUMBER
                          DISTINCT_KEYS                                      NUMBER
                          AVG_LEAF_BLOCKS_PER_KEY                            NUMBER
                          AVG_DATA_BLOCKS_PER_KEY                            NUMBER
                          CLUSTERING_FACTOR                                  NUMBER
                          STATUS                                             VARCHAR2(8)
                          NUM_ROWS                                           NUMBER
                          SAMPLE_SIZE                                        NUMBER
                          LAST_ANALYZED                                      DATE
                          DEGREE                                             VARCHAR2(40)
                          INSTANCES                                          VARCHAR2(40)
                          PARTITIONED                                        VARCHAR2(3)
                          TEMPORARY                                          VARCHAR2(1)
                          GENERATED                                          VARCHAR2(1)
                          SECONDARY                                          VARCHAR2(1)
                          BUFFER_POOL                                        VARCHAR2(7)
                          USER_STATS                                         VARCHAR2(3)
                          DURATION                                           VARCHAR2(15)
                          PCT_DIRECT_ACCESS                                  NUMBER
                          ITYP_OWNER                                         VARCHAR2(30)
                          ITYP_NAME                                          VARCHAR2(30)
                          PARAMETERS                                         VARCHAR2(1000)
                          GLOBAL_STATS                                       VARCHAR2(3)
                          DOMIDX_STATUS                                      VARCHAR2(12)
                          DOMIDX_OPSTATUS                                    VARCHAR2(6)
                          FUNCIDX_STATUS                                     VARCHAR2(8)
                          JOIN_INDEX                                         VARCHAR2(3)
                          IOT_REDUNDANT_PKEY_ELIM                            VARCHAR2(3)
                          DROPPED                                            VARCHAR2(3)

                           

                          SQL>

                          SQL> connect ggs_owner@ora11g
                          Enter password:
                          Connected.
                          SQL> desc ALL_INDEXES;
                          Name                                      Null?    Type
                          ----------------------------------------- -------- ----------------------------
                          OWNER                                     NOT NULL VARCHAR2(30)
                          INDEX_NAME                                NOT NULL VARCHAR2(30)
                          INDEX_TYPE                                         VARCHAR2(27)
                          TABLE_OWNER                               NOT NULL VARCHAR2(30)
                          TABLE_NAME                                NOT NULL VARCHAR2(30)
                          TABLE_TYPE                                         CHAR(5)
                          UNIQUENESS                                         VARCHAR2(9)
                          COMPRESSION                                        VARCHAR2(8)
                          PREFIX_LENGTH                                      NUMBER
                          TABLESPACE_NAME                                    VARCHAR2(30)
                          INI_TRANS                                          NUMBER
                          MAX_TRANS                                          NUMBER
                          INITIAL_EXTENT                                     NUMBER
                          NEXT_EXTENT                                        NUMBER
                          MIN_EXTENTS                                        NUMBER
                          MAX_EXTENTS                                        NUMBER
                          PCT_INCREASE                                       NUMBER
                          PCT_THRESHOLD                                      NUMBER
                          INCLUDE_COLUMN                                     NUMBER
                          FREELISTS                                          NUMBER
                          FREELIST_GROUPS                                    NUMBER
                          PCT_FREE                                           NUMBER
                          LOGGING                                            VARCHAR2(3)
                          BLEVEL                                             NUMBER
                          LEAF_BLOCKS                                        NUMBER
                          DISTINCT_KEYS                                      NUMBER
                          AVG_LEAF_BLOCKS_PER_KEY                            NUMBER
                          AVG_DATA_BLOCKS_PER_KEY                            NUMBER
                          CLUSTERING_FACTOR                                  NUMBER
                          STATUS                                             VARCHAR2(8)
                          NUM_ROWS                                           NUMBER
                          SAMPLE_SIZE                                        NUMBER
                          LAST_ANALYZED                                      DATE
                          DEGREE                                             VARCHAR2(40)
                          INSTANCES                                          VARCHAR2(40)
                          PARTITIONED                                        VARCHAR2(3)
                          TEMPORARY                                          VARCHAR2(1)
                          GENERATED                                          VARCHAR2(1)
                          SECONDARY                                          VARCHAR2(1)
                          BUFFER_POOL                                        VARCHAR2(7)
                          FLASH_CACHE                                        VARCHAR2(7)
                          CELL_FLASH_CACHE                                   VARCHAR2(7)
                          USER_STATS                                         VARCHAR2(3)
                          DURATION                                           VARCHAR2(15)
                          PCT_DIRECT_ACCESS                                  NUMBER
                          ITYP_OWNER                                         VARCHAR2(30)
                          ITYP_NAME                                          VARCHAR2(30)
                          PARAMETERS                                         VARCHAR2(1000)
                          GLOBAL_STATS                                       VARCHAR2(3)
                          DOMIDX_STATUS                                      VARCHAR2(12)
                          DOMIDX_OPSTATUS                                    VARCHAR2(6)
                          FUNCIDX_STATUS                                     VARCHAR2(8)
                          JOIN_INDEX                                         VARCHAR2(3)
                          IOT_REDUNDANT_PKEY_ELIM                            VARCHAR2(3)
                          DROPPED                                            VARCHAR2(3)
                          VISIBILITY                                         VARCHAR2(9)
                          DOMIDX_MANAGEMENT                                  VARCHAR2(14)
                          SEGMENT_CREATED                                    VARCHAR2(3)

                           

                          SQL>

                          • 10. Re: GoldenGate replication on the same physical server - REPLICAT always ABENDING
                            bs_gill

                            Hi,

                             

                            Since no one has replied, I can go with my assumptions that the replicat process performs a lookup at the data dictionary level, and since this is an 11g Golden Gate executable, its not backward compatible with 10g.  To this end, I duplicated my ora11g database with RMAN DUPLICATE, creating another database called ora11g2, changed my REPLOCAL.PRM file as follows(changes in bold):

                             

                            REPLICAT replocal
                            SETENV (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
                            SETENV (ORACLE_SID="ora11g2")
                            ASSUMETARGETDEFS
                            USERID ggs_owner@ora11g2, PASSWORD ggs_owner
                            DISCARDFILE ./dirrpt/discard.txt, APPEND, MEGABYTES 20
                            DDL INCLUDE ALL
                            MAP ggs_owner.golden, TARGET ggs_owner.golden, KEYCOLS(gold);

                             

                            I then restarted the components again, and finally, I managed to replicate changes from the table GGS_OWNER.GOLDEN in ora11g, to the same table in ora11g2.

                             

                            Thanks to all.

                             

                            Bal