RMAN duplicate command failing due to Wallet is not open

Leave a reply

While executing the duplicate command for creating a new environment, we are getting the error in RMAN 

RMAN-03002: failure of Duplicate Db command at 01/02/2024 19:44:32
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script

While checking the alert log file, we are getting the error because of wallet is not in open state:

ORA-00283: recovery session canceled due to errors
ORA-28365: wallet is not open

Following are the steps follow to configure the wallet on clone database server for run the duplicate command:

  1. Go to the wallet location of source database and check location from sqlnet.ora file of source database
  2. Copy the wallet file ewallet.p12 from source database to the clone database server.
  3. Update the wallet location in clone database in SQLNET.ORA file of clone database:
ENCRYPTION_WALLET_LOCATION =
  (SOURCE = (METHOD = FILE)
  (METHOD_DATA =
  (DIRECTORY = /u02/wallet/)
  )
  )

4. Use orapki utility on the clone database server to make the wallet auto-login:

orapki wallet create -wallet /u02/wallet/ -pwd "password" -auto_login

5. A new file is created after successful of 4th step i.e. in the same directory: cwallet.sso

6. Now open the database in nomount state and connect with RMAN.

7. Try to execute the duplicate command now

Leave a Reply