PLS-00201 on dbms_goldengate_auth.grant_admin_privilege
edited Oct 22, 2017 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
We installed Goldengate 11.2.1.0.28 on legacy system(which is at v10.2.0.3) as we are preparing for database migration to 12c using Goldengate. However in the legacy db, I can not run dbms_goldengate_auth.grant_admin_privilege to grant privleges. Is this package not available in v10 rdbms - what would be the substitute ?
njundesra182<oracle>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Oct 12 09:54:54 2017
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> exec dbms_goldengate_auth.grant_admin_privilege('ggs');
0