Home » RDBMS Server » Server Administration » Error when start DB (Oracle DB 10.2.0.4.0)
Error when start DB [message #437814] Wed, 06 January 2010 02:36 Go to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 #437821 is a reply to message #437816] Wed, 06 January 2010 02:49 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
PS:

Here is the FAQ about pfiles/spfiles.

The quickest solution might be to restore the pfile or spfile (depending on which you use) from a known good backup.

[Updated on: Wed, 06 January 2010 02:50]

Report message to a moderator

Re: Error when start DB [message #437849 is a reply to message #437821] Wed, 06 January 2010 04:30 Go to previous message
John Watson
Messages: 6563
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.
Previous Topic: Oracle 11g event log file is full
Next Topic: Connect to Specific instance
Goto Forum:
  


Current Time: Fri Dec 02 16:31:35 CST 2016

Total time taken to generate the page: 0.44145 seconds