Índice do fórum Workshops Workshop Zero Downtime Miration Erro ao configurar o GG para migrar 11g para 12c Multitanent

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

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


Mensagens: 0
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

Mensagens: 457
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."


Mensagens: 0
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

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


Voltar para Workshop Zero Downtime Miration

cron