How can I switch from auto_login wallet to password-protected encryption wallet in 12c
--Now the autologin wallet is in effect
SQL> select * from v$encryption_wallet
2 ;
WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
------------------------------ -------------------- --------- ---------
CON_ID
----------
FILE
/acfs3/wallet
OPEN AUTOLOGIN SINGLE NO
0
--I need to export the keys and it informs me to use password-based keystore
SQL> ADMINISTER KEY MANAGEMENT export KEYS with secret tde_1234 to '/home/oracle/dumpdir/orapdba.wallet' IDENTIFIED BY "tde_1234";
ADMINISTER KEY MANAGEMENT export KEYS with secret tde_1234 to '/home/oracle/dumpdir/orapdba.wallet' IDENTIFIED BY "tde_1234"
*
ERROR at line 1:
ORA-28417: password-based keystore is not open
--So I try to close the autologin keystore and open the password-based keystore, but the autologin keystore cannot be closed
SQL> administer key management set keystore close;
administer key management set keystore close
*
ERROR at line 1:
ORA-28365: wallet is not open
SQL> administer key management set keystore open identified by "tde_1234";
administer key management set keystore open identified by "tde_1234"
*
ERROR at line 1:
ORA-28354: Encryption wallet, auto login wallet, or HSM is already open
So My question is
How to switch from auto_login keystore to password-protected keystore ?