ORA-32004: obsolete or deprecated parameter（s） specified for RDBMS instance

环境：OEL+Oracle11.2.0.1ORACLE_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.更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle 10g更改用户名称的操作方法手动创建数据库的整体流程 Oracle 11g相关资讯 ORA-32004

ORA-32004错误数据库无法启动解（10/27/2013 17:17:03）

ORA-32004: obsolete and/or （12/03/2012 10:02:08）

本文评论查看全部评论（0）