ORA-28365: Wallet Is Not Open On Standby Db (Doc ID 2176823.1)

In this Document

APPLIES TO:

SYMPTOMS

MRP0 started with pid=59, OS id=4688
MRP0: Background Managed Standby Recovery process started (DB1)
started logmerger process
Wed Jul 20 08:43:26 2016
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 32 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Wed Jul 20 08:43:27 2016
Media Recovery Log +DATA/db1_sd/standbyarchive/1_98482_826419945.dbf
Media Recovery Log +DATA/db1_sd/standbyarchive/2_95617_826419945.dbf
kcrf_decrypt_redokey: wallet is not opened..
Errors with log +DATA/db1_sd/standbyarchive/2_95617_826419945.dbf
MRP0: Background Media Recovery terminated with error 28365
Errors in file /u00/app/oracle/diag/rdbms/atgprd_sd/DB1/trace/DB1_pr00_4694.trc:
ORA-28365: wallet is not open
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change XXXXXXXXXXXXXX
Completed: ALTER DATABASE RECOVER managed standby database using current logfile disconnect from session
MRP0: Background Media Recovery process shutdown (DB1)
 

CAUSE

Transparent Database Encryption (TDE) wallets files (ewallet.p12 and ewallet.sso) were found in the Grid account and not in the Oracle account. The location of said wallets (ENCRYPTION_WALLET_LOCATION) was set in the Grid sqlnet.ora file.

SOLUTION

Add the ENCRYPTION_WALLET_LOCATION parameter to the the database Oracle Home sqlnet.ora file for the Standby database and not in the Grid account.
 

REFERENCES