4 Replies Latest reply: Jan 30, 2013 7:50 AM by 982808 RSS

    GG with 2 db instances in the same pc

    976188
      Hi all!

      I've installed 2 oracle enterprise dbs in the same pc. The SID for the first instance is "orcl" and for the second instance, "orcl1". The problem now is that I don't know how to distinguish the 2 instances in goldengate.

      So far I've inserted the following lines in both the extract & replicat processes:

      extract
      setenv (ORACLE_HOME = "D:\app\Administrator\product\11.2.0\dbhome_1")
      setenv (ORACLE_SID = "orcl")

      replicat
      setenv (ORACLE_HOME = "D:\app\Administrator\product\11.2.0\dbhome_2")
      setenv (ORACLE_SID2 = "orcl1")

      The processes are running well with a couple of minor warnings but no data was replicated in the replicat side. I'm running on windows 7, by the way.

      Thanks!
        • 1. Re: GG with 2 db instances in the same pc
          Annamalai A
          you may have mistakenly configured and assigned the RMTTRAIL file to extract/pump process,

          recheck with info extract <ext name> , detail command

          also check in your rmttrail location, there is any new trail file opened.

          Paste your configuration steps( add extract and rmt trail).

          HTH

          Annamalai
          • 2. Re: GG with 2 db instances in the same pc
            976188
            Hi! Thanks for the quick reply.

            Here's the extract configuration:

            extract ext
            setenv (ORACLE_HOME = "D:\app\Administrator\product\11.2.0\dbhome_1")
            setenv (ORACLE_SID = "orcl")
            userid ggate, password oracle
            rmthost 192.168.105.11, mgrport 7809
            rmttrail d:\goldengate\dirdat\ab
            table test.a;


            and here's what the info command showed me:

            EXTRACT EXT Last Started 2013-01-30 18:59 Status RUNNING
            Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
            Log Read Checkpoint Oracle Redo Logs
            2013-01-30 20:03:57 Seqno 44, RBA 38417920
            SCN 0.2149715 (2149715)

            Target Extract Trails:

            Remote Trail Name Seqno RBA Max MB

            d:\goldengate\ab 0 0 100
            d:\goldengate\dirdat\ab 2 1059 100

            Extract Source Begin End

            D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG 2013-01-29 20:59 2013-01-30 20:
            03
            D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG 2013-01-29 19:39 2013-01-29 20:
            59
            D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG 2013-01-29 19:17 2013-01-29 19:
            39
            Not Available * Initialized * 2013-01-29 19:17
            Not Available * Initialized * 2013-01-29 19:17
            Not Available * Initialized * 2013-01-29 19:17


            Current directory D:\GoldenGate

            Report file D:\GoldenGate\dirrpt\EXT.rpt
            Parameter file D:\GoldenGate\dirprm\EXT.prm
            Checkpoint file D:\GoldenGate\dirchk\EXT.cpe
            Process file D:\GoldenGate\dirpcs\EXT.pce
            Error log D:\GoldenGate\ggserr.log

            -----

            Maybe this may help so I might as well post the replicat configuration.

            REPLICAT REP

            setenv (ORACLE_HOME = "D:\app\Administrator\product\11.2.0\dbhome_2")
            setenv (ORACLE_SID2 = "orcl1")

            ASSUMETARGETDEFS
            USERID receiver, PASSWORD oracle

            map sender.test, target receiver.test;
            • 3. Re: GG with 2 db instances in the same pc
              Annamalai A
              Hi,

              Extract Table parameter table name (test.a) and replicat MAP parameter table name(sender.test) are mentioned different ,
              it should be same <schemaname>.<table name > in both places.

              and whats the output of stats extract ext and stats replicat rep ?
              • 4. Re: GG with 2 db instances in the same pc
                982808
                Also.. one thing to consider.

                If you are going to the same laptop.

                Why the rmttrail?
                Consider using a local trail:

                exttrail instead.