Forum Stats

  • 3,768,651 Users
  • 2,252,827 Discussions
  • 7,874,669 Comments

Discussions

OGG- DDL

AATP
AATP Member Posts: 324 Blue Ribbon

Hi Experts ,

We have gg setup between oracle to oracle with unidirectional setup , currently that setup are configured only for dml replication so we planning to enable ddl replciaiton now . to enable the ddl replciation the related database scripts , marke_setupr.sql,ddl_setup , role_setup, ddl_enable , will be executed in source database .

Can you please confirm these scripts can be taken from OGG_HOME directory and exec from different server ? or this must be connected the db from OGG_HOME and executed ? We are using intermediate server so would like to execute the scripts from database server once copied ?

Please advise .


Thanks

Arun.

Comments

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Hello,

    Intermediate server means? Are you connecting remotely and replicating? Remote Capture and Remote Apply?

    The server where the GG is running should have either Oracle Client installed or Oracle Database.

    1. From GG Home, (navigate to the gg home directory) .
    2. Go to sqlplus prompt
    3. Connect to the database where you need to enable DDL replication
    4. Run the scripts

    Regards,

    Veera

    AATP
  • AATP
    AATP Member Posts: 324 Blue Ribbon

    Hi Veera ,

    Thank you for the steps . Yes its remote capture and remote apply . Database is running on different server .

    Can we copy that scripts to database server and run ? is that possible ? Ot It mush be run from GG server ? Due to some other concern like dba dont want to connect the db with sysdba privs from other machine . So please let us know , is that .sql files can be copied and exec from database server ?


    Thanks

    Arun .

  • Gururaj0-Oracle
    Gururaj0-Oracle Member Posts: 78 Employee

    FYI, May be your DB is an old version ?

    When to Use Trigger-based DDL Capture

    You must use trigger-based DDL capture when Extract will operate in the following configurations:

    • Extract operates in classic capture mode against any version of Oracle database.
    • Extract operates in integrated mode against an Oracle database version 11.2.0.3 or earlier.

    If Extract will run in integrated mode against a version 11.2.0.4 or later Oracle database, the DDL trigger is not required. By default, DDL capture is handled transparently through the database logmining server.


    Regards

    Gururaj

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Hi Arun,


    Just an idea. Install OGG in the DB server and run the DDL scripts. So, you don't need to create any processes in there. Just the Binaries. The scripts are all the same across binaries.

    Once you are done. You can remove the Binaries from the DB server. This should work.


    Regards,

    Veera

    AATP