RMAN duplicate failed with RMAN-11003 ORA-28365 WALLET NOT OPEN
(Doc ID 2395631.1)
Last updated on JULY 27, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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 '<PATH>/dbs/<FILE_NAME>.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=/<PATH>/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 /<PATH>/wallet UNKNOWN NOT_AVAILABLE
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |