AUTO_LOGIN not reflecting in the v$encryption_wallet view (Doc ID 2333646.1)

Last updated on APRIL 03, 2021

Applies to:

Symptoms

auto_login is not showing in the v$encryption_wallet view but instead PASSWORD meanwhile you have an auto-login wallet, you can actually see the auto login wallet in the wallet location OR the below error can occur:

ORA-19914: unable to encrypt backup
ORA-28365: wallet is not open

select * from v$encryption_wallet;

WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_ORDER FULLY_BACKED_UP CON_ID
-------------------------- ---------------------------------------------------------------------------------------------------- ------------------------------------ -------------------------- ------------------ --------------------- ----------------
FILE /u01/app/oracle/admin/OUTFRONT/tde_wallet/ OPEN PASSWORD SINGLE NO 0

cd  wallet location===>/u01/app/oracle/admin/OUTFRONT/tde_wallet/

-rw------- 1 oracle oinstall 8461 Jun 4 16:05 cwallet.sso
-rw------- 1 oracle oinstall 8408 Jun 4 15:56 ewallet.p12

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.