ORA-32004错误的解决方法

启动Oracle数据库时出现下列错误

SYS@PROD>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  534462464 bytes
Fixed Size                  2254952 bytes
Variable Size             369100696 bytes
Database Buffers          159383552 bytes
Redo Buffers                3723264 bytes
Database mounted.
Database opened.

 

解决方法

SYS@PROD>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@PROD>create spfile from pfile;

File created.

SYS@PROD>startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2257840 bytes
Variable Size             528485456 bytes
Database Buffers          301989888 bytes
Redo Buffers                2371584 bytes
Database mounted.
Database opened.

问题解决