Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-07452: specified resource manager plan does not exist in
the data dictionary

Answers were Sorted based on User's Feedback



ORA-07452: specified resource manager plan does not exist in the data dictionary..

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

ORA-07452: specified resource manager plan does not exist in the data dictionary..

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

ORA-07452: specified resource manager plan does not exist in the data dictionary..

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

ORA-07452: specified resource manager plan does not exist in the data dictionary..

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

Post New Answer

More Oracle Errors Interview Questions

NNL-00908: UNKNOWN TYPE responses sent: number

1 Answers  


ORA-13382: geometry metadata (table:string column:string) not found in spatial network:string

1 Answers  


LFI-01505: fclose() failed(OSD return value = string) in string.

1 Answers  


ORA-32505: too many watchpoints

1 Answers  


ORA-02054: transaction string in-doubt

1 Answers  


ORA-23484: internal internet Application Server error: string

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  


DRG-10762: index owner does not have access to procedure string

1 Answers  


NNC-00405: network failure

1 Answers  


ORA-19601: output file is string string (string)

1 Answers  


SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

1 Answers  


ORA-12531: TNS:cannot allocate memory

1 Answers  


Categories