DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle Golden Gate

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Red face Oracle Golden Gate

    Hi Friends ,

    it is long time since i have accessed dbasupport forum again .
    i strongly believe i will get some solution in here , as usual .

    i am installing and configuring goldengate for proof of concept .
    using following example
    http://setijoagus.wordpress.com/2010...ce-database-3/

    but for some reason extract process does not start
    could suggest any solution ?

    only difference is i am using 10g database on solaris

    GGSCI (orcl10) 6> add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract ext1
    EXTTRAIL added.

    GGSCI (orcl10) 7> edit params ext1
    –extract group–
    EXTRACT ext1
    –connection to database–
    USERID ggate, PASSWORD 123456
    –hostname and port for trail–
    RMTHOST orcl10, MGRPORT 7809
    –path and name for trail–
    rmttrail /u01/app/oracle/product/gg/dirdat/lt
    –DDL support
    ddl include mapped objname sumber.*
    –DML
    TABLE sumber.*;

    GGSCI (orcl10) 6> info all
    Program Status Group Lag Time Since Chkpt
    MANAGER RUNNING
    EXTRACT STOPPED EXT1 00:00:00 00:02:48

    GGSCI (orcl10) 7> start EXTRACT EXT1

    GGSCI (orcl10) 8> info all
    Program Status Group Lag Time Since Chkpt
    MANAGER RUNNING
    EXTRACT RUNNING EXT1 00:00:00 00:03:03
    siva prakash
    DBA

  2. #2
    Join Date
    May 2010
    Location
    Noida, Near DELHI(INIDA)
    Posts
    3
    Hi
    The following site will be helpful for you to extract and replicate through goldengate

    http://www.pythian.com/news/7225/ora...ernals-part-i/
    http://www.pythian.com/news/7459/ora...rnals-part-ii/
    http://www.pythian.com/news/7617/ora...iii/#more-7617


    Kaialsh Thakur

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    i followed exact steps in above weblink too .
    but extract process wouldn't start .

    i was wondering if we are missing anything very basic step.
    siva prakash
    DBA

  4. #4
    Join Date
    May 2010
    Location
    Noida, Near DELHI(INIDA)
    Posts
    3
    add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract ext1
    please type rt in place /dirdat/lt

    Kailash Thakur

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    sure will try and let you know , i thought it is just a directory or file
    should not be affected by name .

    anyway will let you know .
    siva prakash
    DBA

  6. #6
    Join Date
    May 2010
    Location
    France
    Posts
    1
    prakashs43, can you issue the following command in GGSCI and post the result :

    Code:
    GGSCI> info extract ext1 detail
    You can also check the report file, whose the path will be given by the above command (it is usually stored in the dirrpt subdirectory in the GoldenGate directory).

    If nothing relevant shows up, take a look at the ggserr.log and the sqlnet.log.

    Please keep us posted

    mimidatabase

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width