ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE

Cause : An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

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

Wait if the specified index partition is marked LOADING Rebuild the specified index partition if it is marked FAILED or UNUSABLE.

update : 28-07-2017

ORA-29954 - domain index partition is marked LOADING/FAILED/UNUSABLE
ORA-29954 - domain index partition is marked LOADING/FAILED/UNUSABLE

  • ora-31011 : XML parsing failed
  • ora-08267 : destroy_ora_addr: cannot close nameserver
  • ora-00399 : corrupt change description in redo log
  • ora-09280 : sllfcf: error closing file
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-02801 : Operations timed out
  • ora-30400 : identical JOIN KEY clauses
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-25250 : Cannot specify a remote recipient for the message
  • ora-01250 : Error string occurred during termination of file header access
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-16556 : error message is in XML already
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-07241 : slemrd: read error.
  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-39311 : call to DBMS_SCHEMA_COPY.CLONE_RECOVERY is not legal
  • ora-01742 : comment not terminated properly
  • ora-31109 : Action failed as parent resource string is locked
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-13704 : Invalid value "string" specified for parameter "string".
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-30739 : cannot drop a table that has subtables
  • ora-12542 : TNS:address already in use
  • ora-32821 : subscriber queue and exception queue must have same payload type
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-09957 : Unable to send termination request to IMON
  • ora-23307 : replicated schema string already exists
  • 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.