Oracle DBMS_INTERNAL_CLKM
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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 12cR1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvtclkm.plb
 
GET_KEY (new 12.1)
Undocumented 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;

Grant succeeded.

Related Topics
DBMS_GOLDENGATE_AUTH
GoldenGate
Packages
Security
Transparent Data Encryption
Wallets
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved