Erro ao configurar o GG para migrar 11g para 12c Multitanent

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Golden Gate.
Post Reply
fernando_dba

Erro ao configurar o GG para migrar 11g para 12c Multitanent

Post by fernando_dba » Sun Jan 07, 2018 9:41 pm

Boa noite Portilho,

Estou montando um laboratório de migração do Oracle com o Golden Gate e me deparei com o erro abaixo.
Pesquisei no Google e não encontrei a solução.

Não é possível utilizar o GoldenGate em um pdb?

*** Trigger based DDL Replication is not supported on a Multitenant database.




[oracle@target goldengate]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jan 7 19:50:54 2018

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


Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter session set container=orclpdb;

Session altered.

SQL> @marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ggadmin


Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGADMIN

MARKER TABLE
-------------------------------
OK

MARKER SEQUENCE
-------------------------------
OK

Script complete.
SQL>
SQL>
SQL> @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...
BEGIN
*
ERROR at line 1:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Trigger based DDL Replication is not supported on a Multitenant database.
ORA-06512: at line 14


Disconnected from Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

portilho
Site Admin
Posts: 482
Joined: Wed May 29, 2013 8:51 am

Re: Erro ao configurar o GG para migrar 11g para 12c Multita

Post by portilho » Mon Jan 08, 2018 10:21 am

Oi.
Não encontrei no Post a versão do OGG.
No Documento do MOS 1960719.1 (Oracle GoldenGate 12c Tutorial Oracle to Oracle Replication with Oracle Multitenant Version 12.1) fala a respeito de replicação de DDL:

"DDL INCLUDE MAPPED enables capture of DDL changes for mapped objects. DDL replication for Oracle 12c
does not require any setup. It just needs to be enabled in the extract parameter file."

"DDLOPTIONS REPORT enables DDL processing information to be written to the report file."

"For DDL replication which is enabled in this tutorial, use ADD SCHEMATRANDATA to ensure supplemental logging is
automatically enabled for altered or new tables."

fernando_dba

Re: Erro ao configurar o GG para migrar 11g para 12c Multita

Post by fernando_dba » Mon Jan 08, 2018 12:30 pm

Obrigado pela nota e esclarecimento Portilho.
Vou tentar seguir com o Lab sem executar o script (ddl_setup.sql) pra ver no que vai dar. E fazer as configurações no "extract parameter file".

Valeu

portilho
Site Admin
Posts: 482
Joined: Wed May 29, 2013 8:51 am

Re: Erro ao configurar o GG para migrar 11g para 12c Multita

Post by portilho » Sun Jan 14, 2018 8:41 am

Não deixe de baixar o Doc.
Beleza, se puder conte se funcionou.

Post Reply