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