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

ORA-32004: obsolete or deprecated parameter




SQL> startup ;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance


go to alert log file and find out Deprecated parameter

in this case

Deprecated system parameters with specified values: remote_os_authent


SQL> alter system reset remote_os_authent scope=spfile;

System altered.


example


SQL> alter system reset log_archive_start scope=spfile sid='*' ;

System altered.






SQL> !hostname
apt-amd-02

SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.



SQL> startup; <<<<<<<<<<<<<<<< this time no error
ORACLE instance started.

Total System Global Area 839282688 bytes
Fixed Size 2217992 bytes
Variable Size 629147640 bytes
Database Buffers 205520896 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.



SQL> select name, isspecified from v$obsolete_parameter where isspecified='TRUE';

no rows selected