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.