When we configure TDE wallet , we need to explicitly open it after each database restart.
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <wallet password> ;
we can verify the status of the wallet as
select wallet_type from v$encryption_wallet
wallet_type
-------------
Password
We can configure the auto-login wallet also, In that you don’t need to explicitly open the wallet., the database will automatically open it. It will open for all the PDBs in the CDB database
Command to do it
ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE '<wallet location>' IDENTIFIED BY <Wallet password>;
This will generate an extra file cwallet. sso in the wallet directory. Now you can just restart the database and the Database will start using Autologin Wallet
Now we can verify the status of the wallet again as
select wallet_type from v$encryption_wallet wallet_type ------------- AUTOLOGIN
I hope you like this article
Related Articles
How To Restore TDE Wallet Files From Backup in Oracle Database
how to check if oracle database is encrypted
TDE encryption in Oracle 12c step by step
TDE encryption in oracle 11g step by step
https://docs.oracle.com/en/database/oracle/oracle-database/18/asoag/managing-keystore-and-tde-master-encryption-key.html
Leave a Reply