Issue :
OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED,
Observation :
– Took a complete database backup
– Used the backup to restore the database
After the restore, we found that the wallet was in CLOSED status and an attempt to OPEN is also failed:
SQL> col wrl_parameter format a40
SQL> select * from v$encryption_wallet;
WRL_TYPE WRL_PARAMETER STATUS
——————– —————————————- ——————
file /opt/oracle/dcs/commonstore/wallets/tde/ CLOSED <<<<<<<<<<<<<<< wallet found to be closed here
$ORACLE_UNQNAME
SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY “XXXXXXXX”;
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY “XXXXXXXX” <<<<<<<<<<< OPEN COMMAND failed
*
ERROR at line 1:
ORA-28353: failed to open wallet
Reason :
While opening it using the command, we get the error as the ORACLE_UNQNAME was not set.
[oracle@test11204 ~]$ echo $ORACLE_UNQNAME <<<<<<<<< environment not set [oracle@test11204 ~]$ exit
System altered.
SQL> select * from v$encryption_wallet;
WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS
——————
file
/opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME
