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-04-2017
ORA-16703

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

  • ora-09241 : smsalo: error allocating SGA memory
  • ora-01212 : MAXLOGMEMBERS may not exceed string
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-38851 : cannot mark the current instance (redo thread) as disabled
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-09301 : osncon: local kernel only supported in standard mode
  • ora-19582 : archivelog file header validation for string failed
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-15065 : hash collision for diskgroup names 'string' and 'string'
  • ora-27062 : could not find pending async I/Os
  • ora-27034 : maximum length of ORACLE_SID exceeded
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-06951 : Operating system call error
  • ora-31426 : cannot modify active subscriptions
  • ora-13866 : Client identifier must be specified
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-31194 : Resource string is already deleted
  • ora-19671 : media management software returned invalid proxy handle
  • ora-14259 : table is not partitioned by Hash method
  • ora-27071 : unable to seek to desired position in file
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-02273 : this unique/primary key is referenced by some foreign keys
  • ora-27128 : unable to determine pagesize
  • ora-32601 : value for retention cannot be provided
  • ora-07238 : slemcl: close error.
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-30041 : Cannot grant quota on the tablespace
  • 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.