| Avnish |
Posted: Dec 13, 2007 03:54:12 AM |
Total Post: 142
Joined: Dec, 2007
|
HI,
Recently i modified some parameters with scope to spfile & pfile;
After one day i got two errors :
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
How i will know that which modification is problemetic as indicating these error. is there any way to know parameter modification date? |
|
|
 Vinod |
| Posted: Dec 13, 2007 04:35:19 AM |  |
|
Total Post: 54
Joined: Oct, 2007
|
Hi Avnish,
The parameter modification made to database can be found from the alert log ,the ORA- error which you had mentioned can happen when the value to which you had modyfied is invalid .
Thanks & Regards,
Vinod
|
|
|
|
|
| Avnish |
| Posted: Dec 13, 2007 05:29:40 AM | |
|
Total Post: 142
Joined: Dec, 2007
|
Hi Thanks For reply
I know i'll find commanda in alert.log
how i'll know which modification is problemetic..
& i'll also inform you when i done modification oracle doesnt provide any error at the time i modified parameters.
but after one day it provide me errors..
i just want to know which modification is problemetic...?
|
|
|
|
|
| Vinod |
| Posted: Dec 13, 2007 07:21:26 AM | |
|
Total Post: 54
Joined: Oct, 2007
|
Hi ,
Plz copy paste the init file and the parameter which you had modifyed ,will have a look into it .
Thanks & Regards,
Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 13, 2007 09:49:43 AM | |
|
Total Post: 709
Joined: Jul, 2007
|
http://forums.oracle.com/forums/thread.jspa?threadID=421025
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
