 |
|
ORA-32006: %s initialization parameter has been deprecated tips
Oracle Error Tips by Burleson Consulting
|
The Oracle docs note this on the
ora-32006 error:
-
ORA-32006: %s initialization
parameter has been deprecated
-
-
Cause:
A deprecated parameter was specified at startup
-
Action:
Consult Oracle documentation to find new parameters to use
instead.
Many users find that they are
confronted with
ORA-32006 in association with Archivelog mode.
Here is an example from Oracle
FAQ's:
Question:
while startup(Archivelog mode) the following
message dispalyed
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated.
how to solve this problem ?
Answer:
Just remove this parameter from your
Initialization Parameter File (INIT.ORA/ SPFILE).
Here is another problem from a user who has been confronted by ORA-32006 from
Oracle DBA Forums:
Question:
log_archive_start
parameter is deprecated in 10g.LOG_ARCHIVE_START parameter is no longer
required to be set in order to run the database in ARCHIVELOG mode. This
parameter is deprecated in Oracle 10g. If you put this parameter in your
init of spfile, database will start , but will get following error.
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.
However, if we change the LOG_ARCHIVE_FORMAT to something other than the
default %s,%t,%r, it will fail.
and you get following error.
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORA-19905: log_archive_format must contain %s, %t and %r
Answer:
I set
log_archive_start as TRUE in init.ora, and didn't get ora-32006
