Database backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem
- If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment variable was not set, the wallet is not opened correctly.
Fix :
To fix the problem, start the database using the srvctl utility:
Srvctl start database –d (db_unique_name)
2 . Missing TDE Wallet File
The TDE wallet file (ewallet.p12) can cause backups to fail if it is missing, or if it has incompatible file system permissions or ownership. Check the file as shown in the following example
[oracle@doy tde]$ ls –lrt /opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME/ewallet.p12
rwx—— 1 oracle oinstall 5680 Apr 18 13:09
/opt/oracle/dcs/commonstore/wallets/tde/orclbkp_doy/ewaller.p12
The TDE wallet file should have file permissions with the octal value “700” (-rwx——), and the owner of this file should be a part of the oinstall operating system group.
3. Missing Auto Login Wallet File
The auto login wallet file (cwallet.sso) can cause backups to fail if it is missing, or if it has incompatible file system permissions or ownership. Check the file as shown in the following example:
[oracle@doy tde]$ ls – lrt /opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME/cwallet.ssorwx—— 1 oracle oinstall 5725 Apr 18 13:09
/opt/oracle/dcs/commonstore/wallets/tde/orclbkp_doy/cwallet.sso
The auto login wallet file should have file permissions with the octal value “700” (-rwx——), and the owner of this file should be a part of the oinstall operating system group.