Wallet open and close in Transparent Data Encryption
wallet STATUS is not reflecting when it is closed.
To Close the wallet
SQL>ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE;
keystore altered.
Verify the STATUS of wallet
SQL>Select WRL_TYPE,STATUS ,WALLET_TYPE from v$encryption_wallet;
WRL_TYPE STATUS WALLET_TYPE
——– ———————————–
FILE OPEN AUTOLOGIN
To Open the wallet
SQL>ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY “*******”;
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY “*******”;
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY “*******”;
*
ERROR at line 1:
ORA-28354: Encryption wallet, auto login wallet, or HSM is already open
Note: when issued below command wallet STATUS don’t reflect as CLOSED. we need to move the file cwallet.sso.
ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE;
Solution
Move the cwallet.sso
| $cd /u01/app/odaorabase/oracle/wallet/ORCLT01/tde
$mv cwallet.sso cwallet.sso.bkp |
Now Close the wallet and verifythe STATUS of wallet
| SQL> administer key management set keystore close;
keystore altered. SQL> Select WRL_TYPE,STATUS ,WALLET_TYPE from v$encryption_wallet; |
See also