环境：
OEL+Oracle11.2.0.1
ORACLE_SID=orcl2
问题描述：
重启数据库时出现如下情况：
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 418484224 bytes Fixed Size 1336932 bytes Variable Size 314575260 bytes Database Buffers 96468992 bytes Redo Buffers 6103040 bytes Database mounted. Database opened.
SQL>
错误信息：ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
[oracle@DBA2 ~]$ oerr ora 32004 32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance" // *Cause: Obsolete or deprecated parameters for this instance type // 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文件有下面的提示：
Spfile /u/oracle/product/11.2/dbs/spfileorcl2.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
和：
Deprecated system parameters with specified values: sql_trace
由于这个库是自己用的实验测试库，前一阶段一直在做SQL的语法分析和执行计划相关的实验，所以打开了sql_trace
查看数据库弃用的系统参数：
SQL> select name from v$parameter where isdeprecated = 'TRUE'; NAME -------------------------------------------------------------------------------- lock_name_space instance_groups resource_manager_cpu_allocation active_instance_count buffer_pool_keep buffer_pool_recycle log_archive_start standby_archive_dest log_archive_local_first parallel_server parallel_server_instances NAME -------------------------------------------------------------------------------- fast_start_io_target serial_reuse max_enabled_roles remote_os_authent global_context_pool_size cursor_space_for_time plsql_v2_compatibility plsql_debug background_dump_dest user_dump_dest commit_write NAME --------------------------------------------------------------------------------sql_trace parallel_automatic_tuning parallel_io_cap_enabled 25 rows selected.
解决方案：
通过修改pfile启动参数来重建spfile：
[oracle@DBA2 dbs]$ vi initorcl2.ora
将其中的sql_trace项注释掉或者直接删除
SQL>create pfile from spfile;
然后重新启动数据库：
SQL> startup ORACLE instance started. Total System Global Area 418484224 bytes Fixed Size 1336932 bytes Variable Size 314575260 bytes Database Buffers 96468992 bytes Redo Buffers 6103040 bytes Database mounted. Database opened.
--------------------------------------------------------------------------------------------
版权所有，转载请注明作者及原文链接，否则追究法律责任!
QQ: 584307876
作者: Seven
原文链接: http://blog.csdn.net/sunjiapeng/article/details/8834902
邮箱: seven_ginna@foxmail.com转载于:https://www.cnblogs.com/seven-dba/archive/2013/04/22/4354917.html
相关资源：JAVA上百实例源码以及开源项目