今天重启数据库时竟然发现报如下的错误：

SYS@DBtest>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@DBtest>startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1056964608 bytes
Fixed Size                  1223416 bytes
Variable Size             503317768 bytes
Database Buffers          549453824 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.

查看警告日志文件信息：

audit_file_dest          = /u01/ora10g/admin/DBtest/adump
db_name                  = DBtest
sql_trace                = FALSE
pga_aggregate_target     = 209715200
statistics_level         = ALL
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing

原来参数sql_trace属于要废弃的参数，不需要在spfile中设置。

解决方法：

SYS@DBtest>alter system reset sql_trace scope=spfile sid='DBtest';
alter system reset sql_trace scope=spfile sid='DBtest'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE

SYS@DBtest>alter system reset sql_trace scope=spfile sid='*';

System altered.

SYS@DBtest>

ITPub博客

关于oracle中ora-32004: obsolete and/or deprecated .....问题的解决（原创）

最新文章