AUTO_LOGIN not reflecting in the v$encryption_wallet view

(Doc ID 2333646.1)

Last updated on APRIL 09, 2018

Applies to:

Advanced Networking Option - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms