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 databaseinstance_groups                                                                  list of instance group namesresource_manager_cpu_allocation                                                  Resource Manager CPU allocationactive_instance_count                                                            number of active instances in the cluster databasebuffer_pool_keep                                                                 Number of database blocks/latches in keep buffer poolbuffer_pool_recycle                                                              Number of database blocks/latches in recycle buffer poollog_archive_start                                                                start archival process on SGA initializationstandby_archive_dest                                                             standby database archivelog destination text stringlog_archive_local_first                                                          Establish EXPEDITE attribute default valueparallel_server                                                                  if TRUE startup in parallel server modeparallel_server_instances                                                        number of instances to use for sizing OPS SGA structuresfast_start_io_target                                                             Upper bound on recovery readsserial_reuse                                                                     reuse the frame segmentsmax_enabled_roles                                                                max number of roles a user can have enabledremote_os_authent                                                                allow non-secure remote clients to use auto-logon accountsglobal_context_pool_size                                                         Global Application Context Pool Size in Bytescursor_space_for_time                                                            use more memory in order to get faster executionplsql_v2_compatibility                                                           PL/SQL version 2.x compatibility flagplsql_debug                                                                      PL/SQL debugbackground_dump_dest                                                             Detached process dump directoryNAME                                                                             DESCRIPTION-------------------------------------------------------------------------------- --------------------------------------------------------------------------------user_dump_dest                                                                   User process dump directorycommit_write                                                                     transaction commit log write behavioursql_trace                                                                        enable SQL traceparallel_automatic_tuning                                                        enable intelligent defaults for parallel execution parametersparallel_io_cap_enabled                                                          enable capping DOP by IO bandwidth25 rows selectedSQL>