Goldengate Downstream | ORA-65011: Pluggable database dspdb01 does not exist

Configuring Goldengate on multitenant architecture is way different than classic architecture. Especially when configuring Goldengate with Downstream Mining Database.

Source Host: sourcedbadm01
Source Container DB: sdb01
Source Pluggable DB: spdb1

Downstream Host: downs001
Downstream container DB: dsdb01
Downstream Pluggable DB: dspdb01

To register integrated extract with the downstream mining database, I’ve followed the steps shown below:

1. Connecting to the source database:

GGSCI (sourcedbadm01) 2> dblogin userid c##ggsmgr@sdb01, password **********
Successfully logged into database CDB$ROOT.
GGSCI (sourcedbadm01 as c##ggsmgr@sdb01/CDB$ROOT) 3>

2. Connecting to the downstream database:

GGSCI (sourcedbadm01 as c##ggsmgr@sdb01/CDB$ROOT) 3> MININGDBLOGIN userid  c##ggsmgr@dsdb01, PASSWORD ***********
Successfully logged into mining database.
GGSCI (sourcedbadm01 as c##ggsmgr@dsdb01/CDB$ROOT) 3>

In order to be able to register the integrated extract with the downstream database we need to respectively connect to the source database root container, downstream database root container.

Get Omer Narman’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

3. Register the integrated extract with multitenant downstream database

GGSCI (sourcedbadm01 as c##ggsmgr@sdb01/CDB$ROOT) 4> register extract E_TEST database container(dspdb01);
ORA-65011: Pluggable database dspdb01 does not exist

dspdb01 is our downstream pluggable database name and the OGG complains that this pdb does not exist.

But when we check our downstream database, it shows the pdb is there.

SQL> show pdbs

CON_ID     CON_NAME       OPEN MODE   RESTRICTED
---------- ----------     ----------   ----------
2          PDB$SEED       READONLY     NO
3          DSPDB01        READ WRITE   NO

In order to register the integrated extract with downstream mining database, we need to respectively connect to source container database, downstream mining database and then register the extract on downstream mining pluggable database.

Login to source database and then to downstream mining database and register extract with the downstream mining pluggable database:

GGSCI (sourcedbadm01) 2> dblogin userid c##ggsmgr@sdb01, password **********
Successfully logged into database CDB$ROOT. 

GGSCI (sourcedbadm01 as c##ggsmgr@sdb01/CDB$ROOT) 3> MININGDBLOGIN userid  c##ggsmgr@dsdb01, PASSWORD ***********
Successfully logged into mining database.
GGSCI (sourcedbadm01 as c##ggsmgr@sdb01/CDB$ROOT) 4> register extract E_TEST database container(dspdb01) 
Extract E_TEST successfully registered with database at SCN 372217069.

Now the integrated extract is successfully registered.