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 Area  284565504 bytes                                                                                                                                                               

Fixed Size                  1336036 bytes                                                                                                                                                              

Variable Size             100666652 bytes                                                                                                                                                              

Database Buffers          176160768 bytes                                                                                                                                                               

Redo Buffers                6402048 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';                                                                                                                                                                                                                                                   NAME                                     DESCRIPTION

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

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

instance_groups                          list of instance group names

resource_manager_cpu_allocation          Resource Manager CPU allocation

active_instance_count                    number of active instances in the cluster database

buffer_pool_keep                         Number of database blocks/latches in keep buffer pool

buffer_pool_recycle                      Number of database blocks/latches in recycle buffer pool

log_archive_start                        start archival process on SGA initialization

standby_archive_dest                     standby database archivelog destination text string

log_archive_local_first                  Establish EXPEDITE attribute default value

parallel_server                          if TRUE startup in parallel server mode

parallel_server_instances                number of instances to use for sizing OPS SGA structures

fast_start_io_target                     Upper bound on recovery reads

serial_reuse                             reuse the frame. segments

max_enabled_roles                        max number of roles a user can have enabled

remote_os_authent                        allow non-secure remote clients to use auto-logon accounts

global_context_pool_size                 Global Application Context Pool Size in Bytes

cursor_space_for_time                    use more memory in order to get faster execution

plsql_v2_compatibility                   PL/SQL version 2.x compatibility flag

plsql_debug                              PL/SQL debug

background_dump_dest                     Detached process dump directory

user_dump_dest                           User process dump directory

commit_write                             transaction commit log write behaviour

sql_trace                                enable SQL trace

parallel_automatic_tuning                enable intelligent defaults for parallel execution parameters

parallel_io_cap_enabled                  enable capping DOP by IO bandwidth

 

25 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23898243/viewspace-687087/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23898243/viewspace-687087/