| Error when start DB [message #437814] |
Wed, 06 January 2010 02:36  |
mzarM
Messages: 8
Registered: August 2009
|
Junior Member |
|
|
Hi,
Today our application got problem. When i do some research, it said need to restart db.
So when i restart db, i got this kind of error:
ORA-32004: obsolete and/or deprecated parameter(s) specified
I don't know what wrong i not have training about db oracle. So i need some advice from expert here.
What i need to do?
Thank you.
|
|
|
|
| Re: Error when start DB [message #437816 is a reply to message #437814] |
Wed, 06 January 2010 02:42  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
ORA-32004: obsolete and/or deprecated parameter(s) specified
Cause: One or more obsolete and/or deprecated parameters were
specified in the SPFILE or the PFILE on the server side.
Action: See alert log for a list of parameters that are obsolete
or deprecated. Remove them from the SPFILE or the server
side PFILE.
Has anybody changed any database parameters since the last DB restart? Did you while troubleshooting?
Check the alert<SID>.log (in the Background Dump Destination directory), to find out which ones they are.
[Updated on: Wed, 06 January 2010 02:43] Report message to a moderator |
|
|
|
|
|
| Re: Error when start DB [message #437849 is a reply to message #437821] |
Wed, 06 January 2010 04:30 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Firstly, you should confirm whether you actually have a problem: does that ORA-32004 prevent the database from opening?
Secondly, you should remove deprecated parameters - if you query v$parameter like this,
SELECT name FROM v$parameter
WHERE isdeprecated = 'TRUE';
you will see all the deprecated parameters, so remove them from your initialization file.
Cheers, John.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
