Showing posts with label OPAM. Show all posts
Showing posts with label OPAM. Show all posts

Friday, September 4, 2015

Disable TDE in Oracle Privileged Account Manager Data Store

export ORACLE_HOME=/home/omss/fmw/Oracle_IDM1
export ANT_HOME=/home/omss/fmw/modules/org.apache.ant_1.7.1
export JAVA_HOME=/home/omss/setup/jdk
export ANT_OPTS="-Xmx512M -XX:MaxPermSize=512m"
$ORACLE_HOME/opam/bin/opam.sh -url https://192.168.2.149:18102/opam -x modifyglobalconfig -propertyname tdemode -propertyvalue false -u weblogic -p your_password

Columns are encrypted but TDE wallet is not open

Problem: Columns are encrypted but TDE wallet is not open
Solution: create and open the wallet.
oracle@PTUDServer3 bin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Fri Sep 4 16:43:24 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 "**************";

System altered.

SQL> commit;

Commit complete.