Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39

  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

    Database Administrators

«
»

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

Posted by Mir Sayeed Hassan on February 14th, 2018

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

Find the below error while starting of the database

SQL>; startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 4.8103E+10 bytes
Fixed Size                  2264256 bytes
Variable Size            7516193600 bytes
Database Buffers         4.0534E+10 bytes
Redo Buffers               50454528 bytes
Database mounted.
Database opened.

Set the below parameter to resolve the above issue:

SQL>; alter system reset log_archive_start scope=spfile sid='*' ;
System altered.
SQL>; shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>; startup
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              88081764 bytes
Database Buffers           75497472 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.

=====Hence tested & verified in our test env=====

This entry was posted on Wednesday, February 14th, 2018 at 11:12 am and is filed under ORA-Error. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

«
»