ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started.
-- Oracle啟動的時候報告一些警告，提示使用了一些棄用的參數
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 1319546880 bytes
Fixed Size 2114656 bytes
Variable Size 503319456 bytes
Database Buffers 805306368 bytes
Redo Buffers 8806400 bytes
-- 查看alter文件，究竟的那個棄用參數被使用了
Deprecated system parameters with specified values:
sql_trace
End of deprecated system parameter listing
-- 查看棄用參數
SQL> show parameter sql_trace;
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
sql_trace boolean FALSE
-- 重設棄用參數
SQL> alter system reset sql_trace;
System altered.
-- 關閉數據 + 重啟數據庫 （ORA23240 消失
）
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1319546880 bytes
Fixed Size 2114656 bytes
Variable Size 503319456 bytes
Database Buffers 805306368 bytes
Redo Buffers 8806400 bytes
Database mounted.
Database opened. 查看Alter日志的方法：SQL> show parameter background_dump_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string e:\app\wpeng\diag\rdbms\wpeng\wpeng\trace
SQL> select name,value from v$parameter v where v.name like '%background%';
NAME VALUE
-------------------- ----------------------------------------
background_core_dump partial
background_dump_dest e:\app\wpeng\diag\rdbms\wpeng\wpeng\trace