Home » RDBMS Server » Server Administration » ORA-01109 and ORA-32004
ORA-01109 and ORA-32004 [message #263066] Wed, 29 August 2007 00:26 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hi all,


i got error in 2 places.
SQL> shutdown immediate;
ORA-01109: database not open
and
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

my database is working properly but how to solve these errors.


SQL> connect / as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 415236096 bytes
Fixed Size 1249320 bytes
Variable Size 276828120 bytes
Database Buffers 134217728 bytes
Redo Buffers 2940928 bytes




SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 415236096 bytes
Fixed Size 1249320 bytes
Variable Size 276828120 bytes
Database Buffers 134217728 bytes
Redo Buffers 2940928 bytes
Database mounted.
Database opened.

thanks and regards,
Anamika

Re: ORA-01109 and ORA-32004 [message #263069 is a reply to message #263066] Wed, 29 August 2007 00:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-01109:


You can ignore this error. As your database not open so error came.


And about
Quote:
ORA-32004:


You can also ignore it. But I will better say you check your alert log to see which parameter of your spfile is obsolete.I am pretty much sure that in your spfile there is a parameter that is obsolete.

If you don't want to check alert log then start your database with a prior pfile and then create spfile from that pfile.
Re: ORA-01109 and ORA-32004 [message #263075 is a reply to message #263066] Wed, 29 August 2007 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-32004: obsolete and/or deprecated parameter(s) specified
 *Cause:  One or more obsolete and/or 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.

As you can open your database, it is just a warning.
But after the next upgrade you may not be able to open your database. Follow the "action" section.

Regards
Michel
Re: ORA-01109 and ORA-32004 [message #322716 is a reply to message #263075] Mon, 26 May 2008 01:13 Go to previous messageGo to next message
tauseef_rehman
Messages: 2
Registered: May 2008
Location: Islamabad, Pakistan
Junior Member
Find this from the Alert log:
Deprecated system parameters with specified values:

Now there you will see list(s) of parameters under this.
make your database shutdown and create pfile from spfile

then removies these parameters from the pfile and create spfile now from you new pfile.
and issue the command: startup open.

hope this will solve your issue
Re: ORA-01109 and ORA-32004 [message #322718 is a reply to message #263066] Mon, 26 May 2008 01:20 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Whats your database version?
If its 10g then normally while setting up database in archive log mode,most of teh time people set LOG_ARCHIVE_START=TRUE which is an obsolete parameter in 10g and hence the error.
Re: ORA-01109 and ORA-32004 [message #322726 is a reply to message #263066] Mon, 26 May 2008 01:46 Go to previous message
tauseef_rehman
Messages: 2
Registered: May 2008
Location: Islamabad, Pakistan
Junior Member
Yes i m using oracle 10g
Previous Topic: Delete bdump cdump udump
Next Topic: oem10g
Goto Forum:
  


Current Time: Fri Dec 09 13:53:13 CST 2016

Total time taken to generate the page: 0.08710 seconds