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 : 27-06-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-09842 : soacon: Archmon unable to create named pipe.
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-01244 : unnamed datafile(s) added to control file by media recovery
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-09301 : osncon: local kernel only supported in standard mode
  • ora-26096 : transfer size too small for row data (number bytes required)
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-31398 : DBMS_LDAP: Shared servers are not supported.
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-24770 : cannot forget a prepared transaction
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-27461 : The value for attribute string is too large.
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-31410 : change set string is not an existing change set
  • ora-23338 : priority or value already in priority group string
  • ora-07826 : sspscm: SYS$GETDVIW failure
  • ora-24317 : define handle used in a different position
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-07639 : smscre: SGA pad area not large enough (string bytes required)
  • ora-24850 : failed to startup shared subsystem
  • ora-12488 : maximum label does not dominate minimum label
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-28601 : invalid [no]MINIMIZE option
  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-27473 : argument string does not exist
  • ora-28024 : must revoke grants of external roles to this role/user
  • ora-31672 : Worker process string died unexpectedly.
  • ora-13009 : the specified date string is invalid
  • ora-30507 : normal triggers cannot be based on a schema or a database
  • 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.