My Oracle Support Banner

GoldenGate Replicat Abends With ORA-38802: edition does not exist SQL ALTER SESSION SET EDITION="V_XXXXXXXX_XXXX" (Doc ID 2536542.1)

Last updated on DECEMBER 15, 2019

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Integrated Replicat abend with OGG-06532 due to ORA-38802 while executing Grants, source DB was Editioned db and target db was NON-Editioned db


2019-03-26T19:09:31.631-0400 ERROR OGG-06545 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Failed to switch to edition V_20180920_0813 before applying the following DDL: <DDL>/* GOLDENGATE_DDL_REPLICATION */ (size 94).
2019-03-26T19:09:31.633-0400 ERROR OGG-06532 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Failed to switch to Edition V_20180920_0813. OCI Error ORA-38802: edition does not exist SQL ALTER SESSION SET EDITION="V_20180920_0813" (status = 38802), SQL .
Since edition "V_20180920_0813" does not exist on target database, we'd like to ignore or discard this transaction

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.