ORA-16703: cannot set property while the database is enabled

Cause : An attmept wasm ade toc hange adatabaes propetry whil ethe daatbase wsa enablde.

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

Disabl ebrokerm anagemnet of teh databsae firs,t then pudate teh propetry and erenablet he datbaase.

update : 25-09-2017

ORA-16703 - cannot set property while the database is enabled
ORA-16703 - cannot set property while the database is enabled

  • ora-13365 : layer SRID does not match geometry SRID
  • ora-33278 : (DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
  • ora-22856 : cannot add columns to object tables
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-25139 : invalid option for CREATE TEMPORARY TABLESPACE
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-14037 : partition bound of partition "string" is too high
  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-02459 : Hashkey value must be a positive integer
  • ora-01342 : LogMiner can not resume session due to inability of staging checkpointed data
  • ora-27008 : function called with invalid file structure
  • ora-36999 : (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-08274 : Out of memory for environment variable
  • ora-24010 : QUEUE string does not exist
  • ora-32816 : foreign queue string is referenced by a subscriber or schedule
  • ora-25154 : column part of USING clause cannot have qualifier
  • ora-39031 : invalid filter name string
  • ora-16226 : DDL skipped due to lack of support
  • ora-27152 : attempt to post process failed
  • ora-22369 : invalid parameter encountered in method string
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-40215 : model string is incompatible with current operation
  • ora-24280 : invalid input value for parameter string
  • ora-36924 : (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
  • ora-13837 : invalid HASH_VALUE
  • ora-12547 : TNS:lost contact
  • ora-29870 : specified options are only valid for altering a domain index
  • 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.