Applies to:Oracle Server - Standard Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform. ***Checked for relevance on 29-Jun-2012*** SymptomsWhen setting the FAST_START_MTTR_TARGET with alter system to 300 (seconds) this returns ORA-02097 and ORA-00439.
ORA-02097 parameter cannot be modified because specified value is invalid.
ORA-439 feature not enabled: %s ChangesNo changes. Just trying to set the parameter that was not set manually before.CauseThe RDBMS Standard Edition does not support FAST_START_MTTR_TARGET (one would need a Enterprise Edition for that).Please refer to Oracle® Database Licensing Information 10g Release 2 (10.2) B14199-20 July 2009 http://download.oracle.com/docs/cd/B19306_01/license.102/b14199.pdf page 1-3 shows that Fast-start fault recovery is only available in Enterprise Edition Database version. SolutionTo implement the solution, please execute the following steps:
|
Everything Changes
-
I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note
that Lukas Eder wrote in 2016 with the title: “Avoid using COUNT() in SQL
when you...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu