ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 19 17:35:45 2014

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area 1987641344 bytes

Fixed Size                  2256504 bytes

Variable Size            1006633352 bytes

Database Buffers          973078528 bytes

Redo Buffers                5672960 bytes

Database mounted.

Database opened.

SQL>

 

 

Solution:

This log mainly happen when you reset the parameter ,so to avoid this error appear to reset the parameters

alter system reset log_archive_start scope = spfile;

SQL> alter system reset log_archive_start scope = spfile;

The system has been changed.

SQL> shutdown immediate;
The database has been shut down.
The database has been uninstalled.
ORACLE instance shut down. 

SQL> startup
ORACLE instance started.

Thanks

Yoonus