ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
This package, not installed by default during database creation supports Transparent Data Encryption according to the GoldenGate docs. Certainly the "KM" in the name does point to "Key Management"
AUTHID
DEFINER
Dependencies
DBMS_INTERNAL_CLKM_LIB
Documented
No
First Available
12.1
Package Installation
SQL> @?/rdbms/admin/prvtclkm.plb
SQL> @?/rdbms/admin/prvtclkm.plb
SP2-0808: Package created with compilation warnings
Library created.
SP2-0810: Package Body created with compilation warnings
SQL> sho err
Errors for PACKAGE BODY DBMS_INTERNAL_CLKM:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8/13 PLW-06010: keyword "KEY" used as a defined name
8/13 PLW-07203: parameter 'KEY' may benefit from use of the NOCOPY
compiler hint
36/13 PLW-07203: parameter 'KEY_VAL' may benefit from use of the NOCOPY
compiler hint
dbms_internal_clkm.get_key(
client IN VARCHAR2,
master_key_id IN VARCHAR2,
wrapped_key IN VARCHAR2,
flags IN BINARY_INTEGER,
key OUT VARCHAR2);
-- if GoldenGate is installed and the database utilizes TDE cd to the $GG_HOME directory, run the prvtclkm.plb script, and grant EXECUTE to the GoldenGate user.
Enter user-name: / as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> desc DBMS_INTERNAL_CLKM
ERROR:
ORA-04043: object DBMS_INTERNAL_CLKM does not exist
SQL> @?/rdbms/admin/prvtclkm.plb
SP2-0808: Package created with compilation warnings
Library created.
SP2-0810: Package Body created with compilation warnings
SQL> GRANT execute ON dbms_internal_clkm TO ggadmin;
dbms_internal_clkm.get_key_for_obj(
client IN VARCHAR2,
objno IN BINARY_INTEGER,
key_val OUT VARCHAR2,
key_val_len OUT BINARY_INTEGER,
enc_alg OUT BINARY_INTEGER,
int_alg OUT BINARY_INTEGER);