WALLET_TYPE value is unknown in V$encryption_wallet configured AUTO LOGIN option

I am using with autologin wallet but when i tried to find the value in WALLET_TYPE Column, its value show UNKNOWN instead of AUTOLOGIN value in V$encryption_wallet table.

Check the status of wallet_type in V$encryption_wallet.

select wallet_type from v$encryption_wallet;
wallet_type
-----------
unknown

Solution:

Note: If mkstore utility is used for create keystore, then the WALLET_TYPE is UNKNOWN.

  1. Change the name of the autologin wallet file. Find wallet location in sqlnet.ora file.
mv cwallet.sso cwallet.sso.bkp

2. Close autologin with following command:

alter system set wallet close;

3. open the password based wallet with following command:

administer key management set keystore open identified by wallet_password;

4. Re-enable the autologin setting by executing the following command:

administer key management create AUTO_LOGIN keystore from keystore 'wallet location' identified by wallet_password ;

5. Close password wallet so that the auto_login wallet works automatically:

administer key management set keystore close identified by wallet_password;

6. Verify the value again in the table.

select wallet_type from v$encryption_wallet;
wallet_type
-----------
AUTOLOGIN

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.