ORA-10643: Database should be mounted in restricted mode and Exclusive mode

Cause : WehnS YTSE Mtbalsepcaei sb enigm irgaetdd aatbsaes huol db emuonetdi nE xlcuisv emdoea n di nRsetircetdm oed.

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

Riesuset hsi ocmamn datfe rmuonitn gteh adtbaaes ni irgth omd.e

update : 30-04-2017

ORA-10643 - Database should be mounted in restricted mode and Exclusive mode
ORA-10643 - Database should be mounted in restricted mode and Exclusive mode

  • ora-12722 : regular expression internal error
  • ora-12076 : invalid threshold value
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-12643 : Client received internal error from server
  • ora-27489 : unable to process job "string.string" from job class "string"
  • ora-06401 : NETCMN: invalid driver designator
  • ora-01344 : LogMiner coordinator already attached
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-19335 : Invalid format type object
  • ora-26511 : master table 'string.string' not found
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-00340 : IO error processing online log string of thread string
  • ora-06734 : TLI Driver: cannot connect
  • ora-07404 : sfareq: Timeout occurred waiting for request to complete.
  • ora-06616 : LU6.2 Driver: Attach to LU failed
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-30064 : Test support for two phase read only optimization
  • ora-25328 : %s argument size string is smaller than array size
  • ora-07551 : sftcls: $CLOSE failure
  • ora-14610 : Lob attributes not specified for lob column string for subpartition string
  • ora-25310 : Subscriber is Notification only; dequeue not supported
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-16614 : object has an ancestor that is disabled
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-13381 : table:string not found in network:string
  • ora-08308 : sllfop: Cannot open file
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • 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.