• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3318
  • Last Modified:

Why would my Oracle RMAN backup often fail with wallet not open on database with TDE?

I have an RMAN online backup that sporadically succeeds.  Most of the time it gets an error:
ORA-28365: wallet is not open
continuing other job steps, job failed will not be re-run

My wallet status shows open:
  1* select * from v$encryption_wallet
SQL> /

WRL_TYPE   WRL_PARAMETER             STATUS
----------         -------------------------         --------
file                 /oracle/RB1/112_64/dbs    OPEN

The oracle wallet was displayed from the command prompt and worked without requesting a password which means the auto open file is working.

orapki wallet display -wallet $ORACLE_HOME/dbs

Thank you,
Kim

0
KimiD12
Asked:
KimiD12
  • 3
  • 3
1 Solution
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Are  you using Oracle Wallet in this database?
If yyes, with every restart of the instance, the wallet has to be explicitly opened with the command.
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY <your wallet password> ;

0
 
KimiD12Author Commented:
I will check with security to see if this database has been shutdown and restarted and if there is something to put in place reopening the wallet.  I will get back with this information this morning.

Thank you,
Kim
0
 
KimiD12Author Commented:
The wallet has auto open.  This is version 11g.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Chakravarthi AyyalaDatabase AdministratorCommented:
Do you have this command as part of your RMAN backup?
" SET ENCRYPTION ON IDENTIFIED BY password ONLY".

Ref: http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfa.htm
Subsection: Password Encryption of Backups
0
 
KimiD12Author Commented:
No, that is not part of the RMAN backup script.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Looks like you need to have that in your backup scripts.
Copy/pasting that text from Oracle Manuals here for your easy reference.
========================================================================================================================================Password Encryption of Backups
Password encryption requires that the DBA provide a password when creating and restoring encrypted backups. Restoring a password-encrypted backup requires the same password used to create the backup.

Password encryption is useful for backups that will be restored at remote locations, but which must remain secure in transit. Password encryption cannot be persistently configured. You do not need to configure an Oracle wallet if password encryption will be used exclusively.

Caution:

If you forget or lose the password that you used to encrypt a password-encrypted backup, then you will be unable to restore the backup.
To use password encryption, use the SET ENCRYPTION ON IDENTIFIED BY password ONLY command in your RMAN scripts.
========================================================================================================================================
0
 
TolomirAdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now