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>