OraFAQ Forum: Server Administration » ORA-01109 and ORA-32004

Home » RDBMS Server » Server Administration » ORA-01109 and ORA-32004

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01109 and ORA-32004 [message #263066]

Wed, 29 August 2007 00:26

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

Report message to a moderator

Re: ORA-01109 and ORA-32004 [message #263069 is a reply to message #263066]

Wed, 29 August 2007 00:33

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.

Report message to a moderator

Re: ORA-01109 and ORA-32004 [message #263075 is a reply to message #263066]

Wed, 29 August 2007 00:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-01109 and ORA-32004 [message #322716 is a reply to message #263075]

Mon, 26 May 2008 01:13

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

Report message to a moderator

Re: ORA-01109 and ORA-32004 [message #322718 is a reply to message #263066]

Mon, 26 May 2008 01:20

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.

Report message to a moderator

Re: ORA-01109 and ORA-32004 [message #322726 is a reply to message #263066]

Mon, 26 May 2008 01:46

tauseef_rehman
Messages: 2
Registered: May 2008
Location: Islamabad, Pakistan

Junior Member

Yes i m using oracle 10g

Report message to a moderator

Previous Topic:	Delete bdump cdump udump
Next Topic:	oem10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 00:58:33 CST 2024