Error
Error Code: ORA-29358

Oracle ORA-29358: Invalid Plan Name

📦 Oracle Database
📋

Description

The ORA-29358 error occurs in Oracle Database when using the `DBMS_RESOURCE_MANAGER` package. It indicates that the resource plan name provided to the `UPDATE_PLAN` or `UPDATE_CDB_PLAN` procedure does not exist in the database.
💬

Error Message

ORA-29358: resource plan string does not exist
🔍

Known Causes

3 known causes
⚠️
Typographical Error
The resource plan name was misspelled when calling `UPDATE_PLAN` or `UPDATE_CDB_PLAN`. Double-check the spelling against existing plan names.
⚠️
Non-Existent Plan
The specified resource plan does not exist in the database. Verify the plan was created and has not been dropped.
⚠️
Incorrect Case Sensitivity
Resource plan names might be case-sensitive depending on the database configuration. Ensure the case matches the plan's actual name.
🛠️

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