ORA-32004: obsolete and/or deprecated parameter
Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1.0 - Release: 11.1 to 11.2
Information in this document applies to any platform.
Checked for relevance on 06-Jul-2011
Symptoms
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Changes
The parameter REMOTE_OS_AUTHENT has been set.
Cause
SQL> alter system set remote_os_authent = true scope=spfile;
System altered.
SQL> startup force
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Solution
To remove the deprecated parameter from the spfile issue:
alter system reset remote_os_authent scope=spfile;
REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated over insecure connections,
this parameter is now deprecated. It is retained for backward compatibility only.
Stepping up 'out-of-the-box' security Oracle has decided to deprecate this potentially dangerous parameter in the 11g releases.
================================================================
================================================================
================================================================
ORA-32004 Starting 10g Database
Problem Description
-------------------
Starting a 10g database you recieve the following message:
ORA-32004: obsolete and/or deprecated parameter(s) specified
You have removed all parameters listed in v$obsolete_parameter yet still
continue to receive the message.
Solution Description
--------------------
Remove the log_archive_start parameter.
Explanation
-----------
As of 10g the log_archive_start parameter has been deprecated. When placing the
database into archive log mode the starting of the ARCH process is implictly set
to auto. It is no longer possible to have a database in archive log mode but not
have automatic archiving enabled.
No comments:
Post a Comment