Friday, September 4, 2015

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.

Share this

0 Comment to "Columns are encrypted but TDE wallet is not open"

Post a Comment