Ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instance

Source: Internet
Author: User
Tags deprecated

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.