ORACE TDE

最新推荐文章于 2024-09-05 07:31:46 发布

wgz7747147820

最新推荐文章于 2024-09-05 07:31:46 发布

阅读量421

点赞数

分类专栏： orale 文章标签： oracle

orale 专栏收录该内容

206 篇文章

订阅专栏

Error in Opening KeyStore in Oracle 12c R2

ORA-28367: wallet does not exist

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9537204100346602799

Transparent Data Encryption (TDE) 12c Multitenant. Setup, tablespaces, columns, datapump, RMAN duplication. Part 1.

https://rbikblog.wordpress.com/2018/09/06/transparent-data-encryption-tde-12c-multitenant-setup-tablespaces-columns-datapump-rman-duplication-part-1/

SQL> administer key management set key identified by “wgz” with backup;
administer key management set key identified by “wgz” with backup
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet

alter system set “_db_discard_lost_masterkey”=true;
show parameter “_db_discard_lost_masterkey”;
administer key management set key identified by with backup;

SQL> administer key management set key identified by “wgz”;
administer key management set key identified by “wgz”
*
ERROR at line 1:
ORA-01031: insufficient privileges

这个错误的原因是使用了lockdown，限制了权限，需要将权限放开。