Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate error: does not have the required privileges to use integrated capture

paul brownSep 3 2024 — edited Sep 3 2024

I am on OCI: new to Golden Gate. DBs are autonomous v23

Working through this: https://docs.oracle.com/en/learn/oci-gg-to-streaming/index.html#task-16-set-up-oracle-goldengate-for-ggfororacle

Get as far as Task 16:

In Golden Gate, I create the credential and can connect to it fine, and have selected the tables for the trandata section. When I try and build the extract, I get this:

Oracle GoldenGate Capture for Oracle, EXT.prm: User ggadmin@(DESCRIPTION=(TRANSPORT_CONNECT_TIMEOUT=3)(CONNECT_TIMEOUT=60)(RECV_TIMEOUT=120)(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.uk-london-1.oraclecloud.com))(CONNECT_DATA=(COLOCATION_TAG=GG_ATP_TO_ADL_LAB)(FAILOVER_MODE=(TYPE=SESSION)(METHOD=BASIC)(OVERRIDE=TRUE))(service_name=g17c910a34097d0_sourcedbtest_low.adb.oraclecloud.com))(security=(MY_WALLET_DIRECTORY="/u02/connections/ocid1.goldengateconnection.oc1.uk-london-1.amaaaaaaclv4cdaa6phxbmwr5vjjmrydn4q6a3oxqzpmw7ugrvkvthb6ojva/wallet")(ssl_server_dn_match=yes))) does not have the required privileges to use integrated capture.

Triple checked everything in the tutorial: all looks good.

Did find this and tried it as the admin user in ATP, but got an error:

BEGIN 

dbms_goldengate_auth.grant_admin_privilege( grantee => 'FINDATA' );

END;

PLS-00201: identifier 'DBMS_GOLDENGATE_AUTH' must be declared

any ideas??

Duplicate Post
This post has already been added here:
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Marked as duplicate
Added on Sep 3 2024
0 comments
237 views