RMAN backup failing with ORA-19914 ORA-28365 and WRL_PARAMETER null in v$encryption_wallet (Doc ID 2995025.1)

Last updated on AUGUST 23, 2024

Applies to:

Symptoms

RMAN encrypted backup failing with error wallet is not open :

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/18/2023 11:20:10
ORA-19914: unable to encrypt backup
ORA-28365: wallet is not open

wallet_root parameter was set to /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME and wallet was physically present in /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde location :

oracle@hostname ~]$ cd /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde
[oracle@hostname tde]$ ls -ltr *wallet*
-rw------- 1 oracle asmadmin 8571 Dec  7 22:25 ewallet.p12
-rw------- 1 oracle asmadmin 2555 Dec  7 22:25 ewallet_2022120721074871_defaultTag.p12
-rw------- 1 oracle asmadmin 8616 Dec  7 22:25 cwallet.sso
-rw------- 1 oracle asmadmin 5819 Dec  7 22:25 ewallet_2023031713533336.p12
-rw------- 1 oracle oinstall    0 Dec  7 22:25 ewallet.p12.lck
-rw------- 1 oracle oinstall    0 Dec  7 22:25 cwallet.sso.lck

But still database was not able to identify the wallet location , below query shows WRL_PARAMETER as null :

SQL> select * from v$encryption_wallet;


--------------------------------------------------------------------------------------------------------------------
WRL_TYPE    WRL_PARAMETER     STATUS            WALLET_TYPE      WALLET_OR KEYSTORE FULLY_BACKED_UP           CON_ID
------------------------------ -------------------- --------- -------- --------- --------------------------------------------------------------------------
FILE         NULL                  NOT_AVAILABLE        UNKNOWN              SINGLE    UNITED   UNDEFINED          1 

Changes

Cause

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