Topic: Backup & Recovery >> ORA-02097 -- When trying 2 enable resource manager
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-02097 -- When trying 2 enable resource manager |
| Stan |
Posted: Dec 09, 2003 02:24:44 PM |
Total Post: 2
Joined: Dec, 2003
|
Whenever I try to enable the RESOURCE_MANAGER_PLAN I get the following error messages:
ORA-02097 Parameter cannot be modified because specified value is invalid
Cause: Though the initialization parameter is modifiable, the modified value is not acceptable to the parameter.
Action: Check the Oracle9i Database Administrator’s Guide for range of acceptable values for this parameter.
ORA-00439 Feature not enabled: string
Cause: The specified feature is not enabled.
Action: Do not attempt to use this feature.
I am trying to do exports of certain users (parameter supplied). Prior to executing the export I am trying to run the following command:
alter system quiesce restricted
To temporarily halt any updates to the database, so that I may export the requested data.
I get an error message telling me that the RESOURCE_MANAGER_PLAN is not on:
ORA-29373 Resource manager is not on
Cause: An attempt was made to execute an operation that cannot be executed with the resource manager being off.
Action: Turn on the resource manager and try again.
According to the Admin’s Guide it says that the RESOURCE_MANAGER_PLAN can be enabled one of two ways:
With Enterprise Manager
Click on ‘Activate This Plan’
ALTER SYSTEM SET resource_manager_plan = 'CCC_DOE'
ALTER SYSTEM SET resource_manager_plan = 'SYSTEM_PLAN'
AND
ALTER SYSTEM SET resource_manager_plan = CCC_DOE
ALTER SYSTEM SET resource_manager_plan = SYSTEM_PLAN
Or
By issuing the alter system command
alter System set resource_manager_plan = 'CCC_DOE'
alter System set resource_manager_plan = 'SYSTEM_PLAN'
AND
alter System set resource_manager_plan = CCC_DOE
alter System set resource_manager_plan = SYSTEM_PLAN
This is a valid plan that has been created.
I have tried both ways and received the error messages noted above. In all cases I was logged on as either SYS or SYSTEM as SYSDBA.
Database Information: Oracle 9i Release 9.0.1.1.1 Production with the Objects option
Restricted Mode = NO
Archive Log Mode = ARCHIVELOG
Operating System: Windows NT Version: 5.0
|
|
|
 vasu |
| Posted: Dec 09, 2003 04:23:04 PM |  |
|
Total Post: 50
Joined: Jan, 2003
|
Have you created plans? Looks like you are setting undefined value in the system.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
