關於oracle中ora-32004: obsolete and/or deprecated .....問題的解決（原創）

今天重啟資料庫時竟然發現報如下的錯誤：

immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

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中 設定。

解決方法：

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

system reset sql_trace scope=spfile sid='*';

System altered.

>