Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-07452: specified resource manager plan does not exist in
the data dictionary
- 4 Answers
- 22087 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / maher habash
solution 1:
if you are using spfile, just disable the resource plan
that is not available in data dictionary by the following
command:
alter system set resource_manager_plan='' ;
solution 2:
if you are using init file just comment the resource plan
line
Regards
Maher
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / artur wosinski
if using spfile:
startup mount;
alter system set resource_manager_plan='' ;
alter database open;
if using pfile:
comment out line with resource plan.
startup;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / binod
If the ora-07452 occurs, then this is b'coz we have tried to specified the resource manager plan that is not available in the data dictionary..remember the plan should be exist otherwise the error will occur.. To solve the error follow the enumerated steps
1. First of all try to look the alert log file in the bdump dir
2.There is bdump you will find the cause of the error
3.shutdown immediate/normal
4.startup mount
5.alter system set resource_manager_plan='' ;
Thank you
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
Cause: User tried to load a resource manager plan that does
not exist.
Action: Use a resource manager plan that exists in the data
dictionary.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-19851: OS error while managing auxiliary database string
ORA-24149: invalid rule name
DRG-51030: wildcard query expansion resulted in too many terms
RMAN-06069: the filename for datafile string is missing in the controlfile
TNS-00541: underlying transport does not exist.
ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
ORA-02444: Cannot resolve referenced object in referential constraints
RMAN-08589: channel string: starting datafile conversion
ORA-07504: scgcmn: $hiber unexpected return
ORA-02712: osnpop: malloc failed
ORA-02376: invalid or redundant resource
RMAN-04031: initialization parameters used for automatic instance: string
Oracle Errors 
