My Oracle Support Banner

How to restore TDE wallet file from Storage Container Backup in OCI - Classic (Doc ID 2468333.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

By default TDE is enabled in DBaaS OCI. If TDE wallet is accidentally deleted at OS level, all activity related to encrypted object will fail with ORA-28365

Example :

SQL>  create table emp(id number) tablespace users;
 create table emp(id number) tablespace users
*
ERROR at line 1:
ORA-28365: wallet is not open

sqlplus " / as sysdba"
SQL>  select * from v$encryption_wallet

WRL_TYPE             WRL_PARAMETER                                                                    STATUS                         WALLET_TYPE          WALLET_OR FULLY_BAC     CON_ID
-------------------- -------------------------------------------------------------------------------- ------------------------------ -------------------- --------- --------- ----------
FILE                 /u01/app/oracle/admin/ORCL/tde_wallet/                                           NOT_AVAILABLE                  UNKNOWN              SINGLE    UNDEFINED          0


$ls -ltr /u01/app/oracle/admin/ORCL/tde_wallet
total 0

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.