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

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;

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

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

TNS-01304: ns secondary err code: number

1 Answers  

---

ORA-32735: DIAG process is not running in the instance

1 Answers  

---

QSM-02050: subquery using the ALL clause in mv

1 Answers  

---

DRG-10834: upper-case form of section name string too long

1 Answers  

---

ORA-02422: missing or invalid schema element

1 Answers  

---

ORA-16115: loading Log Miner dictionary data

1 Answers  

---

ORA-00603: ORACLE server session terminated by fatal error

2 Answers  

---

LFI-00120: Unable to parse root filename string.

1 Answers  

---

NZE-28806: Cannot write to the data source.

1 Answers  

---

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  

---

DRG-13011: language column must be specified when using the multi lexer

1 Answers  

---

EXP-00068: tablespace string is offline

1 Answers  

---