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 |