Issue:
If the Oracle Wallet is defined in the default location (ORACLE_BASE) and there are no entries to the ORACLE_WALLET location in the sqlnet.ra file, the Oracle Wallet may not open after an offline backup and restore when either of the following is true:
-
The subclient is configured with no lights-out script (Subclient Properties dialog box, Advanced tab, Offline Arguments tab)
-
The Switch Database Mode for Restore option (Options tab) was used for the restore.
Solution
Use one of the following options to fix this issue.
-
Define the Oracle Wallet location in the sqlnet.ra file
-
Configure a post-script that opens the Oracle Wallet (Subclient Properties dialog box, Pre/Post Process tab, PostBackup Process box)