oracle11g init.ora,Oracle11g R2 ORA-32004故障解决

oracle11g R2手动在裸设备(RAW)上建库后，数据库可正常使用，当每次启动数据库时总报ORA-32004错误，如下：

SQL>startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area284565504 bytes

Fixed Size1336036 bytes

Variable Size100666652 bytes

Database Buffers176160768 bytes

Redo Buffers6402048 bytes

Database mounted.

Database opened.

解决步骤：

(1)查看告警日志中有什么报错信息

[oracle@oracle bdump]$ vi alert_test.log

Fri Feb 11 17:04:36 2011

WARNING: The background_dump_dest init.ora parameter has been deprecated.

WARNING: Please remove the background_dump_dest parameter from the init.ora file.

WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data

WARNING: The new location for the background logs and traces is /u01/oracle/diag/rdbms/test/test/trace

Fri Feb 11 17:04:36 2011

WARNING: The user_dump_dest init.ora parameter has been deprecated.

WARNING: Please remove the user_dump_dest parameter from the init.ora file.

WARNING: The diagnostic_dest init.ora parameter now determines the location of the diagnostic data

WARNING: The new location for the user logs and traces is /u01/oracle/diag/rdbms/test/test/trace(2)根据告警日志中的信息查看哪些参数被抛弃了

SQL> select name,description from v$parameter where isdeprecated='TRUE';NAMEDESCRIPTION

---------------------------------------- ----------------------------------------------------------------------------------------------------

lock_name_spacelock name space used for generating lock names for standby/clone database

instance_groupslist of instance group names

resource_manager_cpu_allocationResource Manager CPU allocation

active_instance_countnumber of active instances in the cluster database

buffer_pool_keepNumber of database blocks/latches in keep buffer pool

buffer_pool_recycleNumber of database blocks/latches in recycle buffer pool

log_archive_startstart archival process on SGA initialization

standby_archive_deststandby database archivelog destination text string

log_archive_local_firstEstablish EXPEDITE attribute default value

parallel_serverif TRUE startup in parallel server mode

parallel_server_instancesnumber of instances to use for sizing OPS SGA structures

fast_start_io_targetUpper bound on recovery reads

serial_reusereuse the frame. segments

max_enabled_rolesmax number of roles a user can have enabled

remote_os_authentallow non-secure remote clients to use auto-logon accounts

global_context_pool_sizeGlobal Application Context Pool Size in Bytes

cursor_space_for_timeuse more memory in order to get faster execution

plsql_v2_compatibilityPL/SQL version 2.x compatibility flag

plsql_debugPL/SQL debug

background_dump_destDetached process dump directory

user_dump_destUser process dump directory

commit_writetransaction commit log write behaviour

sql_traceenable SQL trace

parallel_automatic_tuningenable intelligent defaults for parallel execution parameters

parallel_io_cap_enabledenable capping DOP by IO bandwidth

25 rows selected.