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 : 28-07-2017

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

  • ora-12439 : invalid combination of policy options
  • ora-22166 : collection is empty
  • ora-01672 : control file may be missing files or have extra ones
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-01095 : DML statement processed zero rows
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-29523 : authorization error for unknown referenced name
  • ora-16608 : one or more databases have warnings
  • ora-22866 : default character set is of varying width
  • ora-32841 : invalid value for property string
  • ora-40105 : input data incompatible with model signature
  • ora-00827 : could not shrink sga_target to specified value
  • ora-28026 : user with same external name already exists
  • ora-12821 : invalid value for INSTANCES
  • ora-15154 : cluster rolling upgrade incomplete
  • ora-12481 : effective label not within program unit clearance range
  • ora-15195 : Internal ASM testing event number 15195
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-30370 : set operators are not supported in this context
  • ora-31399 : Cannot contact LDAP server string at port number
  • ora-26046 : REF column string expects scoped table name string; user passed in string.
  • ora-39070 : Unable to open the log file.
  • ora-00320 : cannot read file header from log string of thread string
  • ora-09786 : sllfop: open error, unable to open file.
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-27547 : Unable to query IPC OSD attribute string
  • ora-12643 : Client received internal error from server
  • ora-06927 : CMX: T_DATAIN received before all data written
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • 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.