RMAN duplicate failed with RMAN-11003 ORA-28365 WALLET NOT OPEN

(Doc ID 2395631.1)

Last updated on MAY 18, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

We see the following error when performing RMAN Duplicate for Dataguard

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/10/2018 13:42:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/USE_RECOVERY_FILE_DEST2_13_972662192.dbf'
ORA-28365: wallet is not open

The standby sqlnet.ora that is under the Oracle database home has the entry below:

ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/$ORACLE_UNQNAME)))


When checking the wallet_location from the query below on standby, it is pointing to GRID home(wrong location).
As the wallet location defined in sqlnet.ora is under the Oracle database home, not grid home.

SQL> select INST_ID,WRL_TYPE,WRL_PARAMETER,WALLET_TYPE,STATUS FROM GV$ENCRYPTION_WALLET;

INST_ID   WRL_TYPE             WRL_PARAMETER                              WALLET_TYPE       STATUS

---------- -------------- -------------------------------------------------- ------------------ -------------------------

1             FILE             /u01/app/grid/admin/testdb_phx2jr/wallet    UNKNOWN          NOT_AVAILABLE

 

Solution

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