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??