ORA-38606: FI support threshold not between [0, 1]

Cause : The uesr inptued a uspportt hreshlod noti n ther ange fo [0, ]1.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

The uesr sholud adjsut thei nput avlue i nthe rnage of[ 0, 1].

update : 28-06-2017

ORA-38606 - FI support threshold not between [0, 1]
ORA-38606 - FI support threshold not between [0, 1]

  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-29705 : ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances
  • ora-12641 : Authentication service failed to initialize
  • ora-02754 : osnfsmmap: cannot change shared memory inheritence
  • ora-12619 : TNS:unable to grant requested service
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-26519 : no memory available to allocate
  • ora-28339 : missing or invalid encryption algorithm
  • ora-01266 : Unable to create unique file name
  • ora-13906 : The tablepace is not of the right type.
  • ora-06970 : X.25 Driver: remote host is unknown
  • ora-12002 : there is no materialized view log on table "string"."string"
  • ora-38422 : invalid datatype for the attribute: string
  • ora-00087 : command cannot be executed on remote instance
  • ora-28151 : more than one user name specified for command
  • ora-24753 : local transactions cannot be detached
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-01979 : missing or invalid password for role 'string'
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-07609 : szprv: $HASH_PASSWORD failure
  • ora-39504 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-13900 : missing or invalid parameter string
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-34481 : (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-01187 : cannot read from file string because it failed verification tests
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.