Error
Error Code: ORA-28397

Oracle ORA-28397: Passphrase-Wrapped Key

📦 Oracle Database
📋

Description

The ORA-28397 error occurs when attempting to bring an encrypted tablespace file online that has been rewrapped using a passphrase. This happens after using the `DBMS_TTS.PASSPHRASE_REWRAP_KEY` procedure, making the file incompatible with direct online operations.
💬

Error Message

ORA-28397: cannot bring file string online since it has a passphrase-wrapped key
🔍

Known Causes

2 known causes
⚠️
Passphrase Rewrapping
The tablespace file was rewrapped using a passphrase instead of a master encryption key via `DBMS_TTS.PASSPHRASE_REWRAP_KEY`. This makes it incompatible for online use without conversion.
⚠️
Incorrect Online Attempt
An attempt was made to bring the tablespace file online before converting it with RMAN after passphrase rewrapping.
🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

  • Check the error message carefully for specific details
  • Review recent changes that might have caused the error
  • Search for the exact error code in the official documentation
  • Check log files for additional context
  • Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs