首页 » ORACLE » ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-32004: obsolete and/or deprecated parameter(s) specified

SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size                  2085256 bytes
Variable Size            1627393656 bytes
Database Buffers          452984832 bytes
Redo Buffers               14688256 bytes
Database mounted.
SQL> host oerr ora 32004

SQL> host oerr ora 32004
32004, 00000, “obsolete and/or deprecated parameter(s) specified”
// *Cause:  One or more obsolete and/or parameters 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.

查看alert 日志
….
Deprecated system parameters with specified values:
sql_trace
…..

SQL> alter system reset sql_trace scope=spfile sid=’*’;
System altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size                  2085256 bytes
Variable Size            1627393656 bytes
Database Buffers          452984832 bytes
Redo Buffers               14688256 bytes
Database mounted.

有问题多看看alert日志吧

打赏

对不起,这篇文章暂时关闭评论。