1. Start error
Sql> Startup
Ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instance
The ORACLE routine has been started.
Total System Global area 1887350784 bytes
Fixed Size 2176848 bytes
Variable Size 1325402288 bytes
Database buffers 553648128 bytes
Redo buffers 6123520 bytes
The database is loaded.
The database is already open.
2, check the alarm log has the following alarm content
Show parameters that have been deprecated
Deprecated system parameters with specified values:
Remote_os_authent
End of deprecated system parameter listing
Wed Mar 11 11:04:24 2015
3, modify the parameter file: Initorcl.ora
I:\app\Administrator\product\11.2.0\dbhome_1\database\INITorcl.ORA
Delete parameter: remote_os_authent
4. Re-create SPFile from Pfile
Sql> create SPFile from Pfile;
The file was created.
5, start the normal
Sql> Startup
The ORACLE routine has been started.
Total System Global area 1887350784 bytes
Fixed Size 2176848 bytes
Variable Size 1325402288 bytes
Database buffers 553648128 bytes
Redo buffers 6123520 bytes
The database is loaded.
The database is already open.
Sql>
6. View parameters that have expired
Sql> SelectName,description fromV$parameterwhereisdeprecated='TRUE'; NAME DESCRIPTION-------------------------------------------------------------------------------- ----------------------------- ---------------------------------------------------Lock_name_space Lock NameSpaceUsed forGenerating lock names forStandby/CloneDatabaseinstance_groups List ofInstanceGroupnamesresource_manager_cpu_allocation Resource Manager CPU allocation Active_instance_count Number ofActive instancesinchThe clusterDatabaseBuffer_pool_keep Number of DatabaseBlocks/LatchesinchKeep Buffer poolbuffer_pool_recycle Number of DatabaseBlocks/LatchesinchRecycle buffer poollog_archive_start start archival PR Ocess onSGA initializationstandby_archive_dest StandbyDatabaseArchivelog destinationtextStringlog_archive_local_first Establish Expedite attribute /c0>defaultValueparallel_serverifTRUE StartupinchParallel Server Modeparallel_server_instances Number ofInstances to Use forsizing OPS SGA structuresfast_start_io_targetUpperBound onrecovery Readsserial_reuse Reuse the frame segmen Tsmax_enabled_rolesMax Number ofRoles AUsercan has enabledremote_os_authent allow non-Secure remote Clients to UseAuto-logon accountsglobal_context_pool_size Global application Cont Ext Pool SizeinchBytescursor_space_for_time UseMore memoryinch Order toget faster executionplsql_v2_compatibility PL/SQL version2. x Compatibility Flagplsql_debug PL/SQL debugbackground_dump_dest Detached ProcessDumpdirectoryname DESCRIPTION-------------------------------------------------------------------------------- ----------------------------- ---------------------------------------------------User_dump_destUserProcessDumpDirectorycommit_writeTransaction Commit Logwrite Behavioursql_trace enable SQL traceparal Lel_automatic_tuning Enable intelligent Defaults forParallel Execution parametersparallel_io_cap_enabled enable Capping DOP byIO Bandwidth -rows Selectedsql>
Ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instance