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

客户安装12.2 db，重启库，提示过期参数报错ORA，需要一个好的解释说明。

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

　

ORA报错解释

SQL> !oerr ora 32004
32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause:  Obsolete or deprecated parameters for this instance type 
//          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.

SQL>查询数据库中存在的过期参数

查询数据库中，废弃的参数值
SQL>select name,description from v$parameter where isdeprecated='TRUE';
参数名称-参数解释说明

ORA-32004只是提示作用，当出现低版本已废弃的参数时，数据库启动均会报此ORA，可以忽略。