GG implementation issue - Multitenant Container DB - 12c RAC
edited Jul 19, 2017 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hi Experts,
I was trying to implement GG 12c in CDB/PDB environment. It's a 2 node RAC DB. I was following the oracle documentation for the same.
1. I have created the common user (C##GGUSER), provided DBA role.
2. Executed exec dbms_goldengate_auth.grant_admin_privilege('C##GGUSER',container=>'ALL'); --- at CDB level
Then logged in to the root container as the common user (CDB$ROOT) from ggsci command prompt, and tried to register the extract process, but got the below issue :
GGSCI (bld12241006) 4> dblogin userid C##GGUSER@<remote_cdb_tns_alias>, password <pwd>
Successfully logged into database CDB$ROOT.
Tagged:
0