Errors OGG-00664, ORA-65011 Or OGG-08234 When Trying To Register GoldenGate Extract When PDB Is Lowercase Even After Applying Fix For Bug 31175404.
(Doc ID 2799446.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
Cannot Register IE When PDB is in the lowercase form, or have mixed cases.
2021-07-01 11:06:38 ERROR OGG-08234 ERROR: Database container TEST does not exist.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 test READ WRITE NO
The Oracle RDBMS Errorstack trace will show the failing command misses the double-quotes when dealing with mixed-cases wording:
<error barrier> at 0x7ffedc857440 placed dbkda.c@296
ORA-65011: Pluggable database TEST does not exist.
----- Current SQL Statement for this session (sql_id=3j67bu2nw9k6r) -----
ALTER SESSION SET CONTAINER=test ==========> Here, missing the double-quotes to handle case sensitive.
SQL*Plus testcase:
ERROR:
ORA-65011: Pluggable database TEST does not exist.
SQL> alter session set container="test";
Session altered.
Changes
Using Oracle Container database with PDBs named in lower or mixed-cases.
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 |
Changes |
Cause |
Solution |
References |