Enabling TDE in Oracle Privileged Account Manager Data Store

Before that, you need to read the documents:
https://docs.oracle.com/cd/E52734_01/core/INOAM/opam.htm#INOAM98442
and
https://docs.oracle.com/cd/E11882_01/network.112/e40393.pdf
[oracle@PTUDServer3 oracle]$ cd $ORACLE_HOME
[oracle@PTUDServer3 db_1]$ mkdir wallet        
[oracle@PTUDServer3 admin]$ more sqlnet.ora 
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ENCRYPTION_WALLET_LOCATION = (SOURCE=(METHOD=file)(METHOD_DATA=(DIRECTORY=$ORACLE_HOME/wallet)))

[oracle@PTUDServer3 db_1]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Aug 24 13:32:51 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter system set encryption key identified by " your_password ";

System altered.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

IAM_HOME/opam/sql/opamxencrypt.sql
[oracle@PTUDServer3 oracle]$ sqlplus opam_opam/******** @opamxencrypt.sql

SQL*Plus: Release 12.1.0.1.0 Production on Mon Aug 24 13:35:12 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Aug 24 2015 11:50:50 +07:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> alter table flexsecfield modify attr_val encrypt using 'AES256';

Table altered.

SQL> commit;

Commit complete.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Share this

Vtgdb