OGG- DDL

ARUN-A

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.

ORASCN

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
5. 
   

Regards,

Veera

ARUN-A

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

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

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