Oracle DBA Tasks

1. Log in to SQL*Plus as a user with the SYSDBA system privilege. For example:

   sqlplus sys/as sysdba
   Connected.
   Enter password: password
   

2. Run the prvtclkm.plb file that is installed in the Oracle admin directory. The prvtclkm.plb file creates the DBMS_INTERNAL_CLKM PL/SQL package, which enables Oracle GoldenGate to extract encrypted data from an Oracle Database.

   @?/app/oracle/product/orcl111/rdbms/admin/prvtclkm.plb
   

3. Grant EXEC privilege on DBMS_INTERNAL_CLKM PL/SQL package to the Extract database user.

   GRANT EXECUTE ON DBMS_INTERNAL_CLKM TO psmith;
   

4. Exit SQL*Plus.