How to open and close the Oracle Wallet for accessing data

For Close the wallet:

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE IDENTIFIED BY MyWalletPass;
keystore altered.

SQL> select * from sensitive_data ;
select * from sensitive_data
              *
ERROR at line 1:
ORA-28365: wallet is not open

For Open the wallet:

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY MyWalletPass;
keystore altered.

SQL> select * from sensitive_data ;
no rows selected
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply