ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
1、启动报错
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE 例程已经启动。
Total System Global Area 1887350784 bytes
Fixed Size 2176848 bytes
Variable Size 1325402288 bytes
Database Buffers 553648128 bytes
Redo Buffers 6123520 bytes
数据库装载完毕。
数据库已经打开。
2、查看告警日志中有如下告警内容
显示已经Deprecated的参数
Deprecated system parameters with specified values:
remote_os_authent
End of deprecated system parameter listing
Wed Mar 11 11:04:24 2015
3、修改参数文件：INITorcl.ORA
I:\app\Administrator\product\11.2.0\dbhome_1\database\INITorcl.ORA
删除参数：remote_os_authent
4、从pfile重新创建spfile
SQL> create spfile from pfile;
文件已创建。
5、启动正常
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 1887350784 bytes
Fixed Size 2176848 bytes
Variable Size 1325402288 bytes
Database Buffers 553648128 bytes
Redo Buffers 6123520 bytes
数据库装载完毕。
数据库已经打开。
SQL>
6、查看已过期的参数
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 NAME DESCRIPTION -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- 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 SQL>
