ORA-32004: obsolete and/or deprecated parameter(s) specified

1.启动数据库的时候发现如下错误提示：原因是使用了不推荐的或者已经废弃的参数（deprecated）

SQL> startupORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area  285212672 bytesFixed Size                  1218968 bytesVariable Size              88082024 bytesDatabase Buffers          188743680 bytesRedo Buffers                7168000 bytesDatabase mounted.Database opened.

2.查看错误日志：

SQL> host oerr ora 3200432004, 00000, "obsolete and/or deprecated parameter(s) specified"// *Cause:  One or more obsolete and/or parameters 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.

3.根据错误提示：查看警告日志

到oracle_home 的admin文件夹下：

[oracle@localhost bdump]$ more alert_orclsid.log .....Starting up ORACLE RDBMS Version: 10.2.0.1.0.System parameters with non-default values:  processes                = 150  __shared_pool_size       = 109051904  __large_pool_size        = 4194304  __java_pool_size         = 4194304  __streams_pool_size      = 0  sga_target               = 285212672  control_files            = /home/oracle/oracle/product/10.2.0/oradata/orcl/control01.ctl, /home/oracle/oracle/product/10.2.0/oradata/orcl/control02.ctl, /home/oracle/oracle/product/10.2.0/oradata/orcl/control03.ctl  db_block_size            = 8192  __db_cache_size          = 159383552  compatible               = 10.2.0.1.0  log_archive_start        = TRUE  db_file_multiblock_read_count= 32  db_recovery_file_dest    = /home/oracle/oracle/product/10.2.0/flash_recovery_area/  db_recovery_file_dest_size= 2147483648  undo_management          = AUTO  undo_tablespace          = UNDOTBS1  remote_login_passwordfile= EXCLUSIVE  db_domain                =   dispatchers              = (PROTOCOL=TCP) (SERVICE=orclsidXDB)  job_queue_processes      = 10  background_dump_dest     = /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/bdump  user_dump_dest           = /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump  core_dump_dest           = /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/cdump  audit_file_dest          = /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/adump  db_name                  = orcl  open_cursors             = 300  star_transformation_enabled= TRUE  pga_aggregate_target     = 94371840Deprecated system parameters with specified values:  log_archive_start        End of deprecated system parameter listing.....

4.查询到如下信息：

Deprecated system parameters with specified values:  log_archive_start 

原来在oracle中 log_archive_start已经是deprecated的：

5.可以查询表：SELECT NAME, DESCRIPTION FROM V$PARAMETER WHERE ISDEPRECATED = 'TRUE';

来查看已经Deprecated的参数：

1lock_name_spacelock name space used for generating lock names for standby/clone database2buffer_pool_keepNumber of database blocks/latches in keep buffer pool3buffer_pool_recycleNumber of database blocks/latches in recycle buffer pool4max_commit_propagation_delayMax age of new snapshot in .01 seconds5remote_archive_enableremote archival enable setting6log_archive_startstart archival process on SGA initialization7parallel_serverif TRUE startup in parallel server mode8parallel_server_instancesnumber of instances to use for sizing OPS SGA structures9fast_start_io_targetUpper bound on recovery reads10logmnr_max_persistent_sessionsmaximum number of threads to mine11serial_reusereuse the frame segments12max_enabled_rolesmax number of roles a user can have enabled13global_context_pool_sizeGlobal Application Context Pool Size in Bytes14plsql_compiler_flagsPL/SQL compiler flags15sql_traceenable SQL trace16parallel_automatic_tuningenable intelligent defaults for parallel execution parameters17drs_startstart DG Broker monitor (DMON process)

6.使用下列命令来重置参数：

SQL> alter system reset log_archive_start scope=spfile sid='*';System altered.

7.重启数据库，就不会再有提示了：

SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area  285212672 bytesFixed Size                  1218968 bytesVariable Size              92276328 bytesDatabase Buffers          184549376 bytesRedo Buffers                7168000 bytesDatabase mounted.Database opened.