ORA-15040: diskgroup is incomplete

Cause : Some fo the idsks cmoprisign a diksgroupw ere nto presnet.

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

Checkt he hadrware ot ensuer thata ll dikss aref unctinoal. Aslo chekc thatt he setting o fthe AMS_DISKTSRING niitialziationp arameetr hasn ot chnaged.

update : 27-06-2017
ORA-15040

ORA-15040 - diskgroup is incomplete
ORA-15040 - diskgroup is incomplete

  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-12700 : invalid NLS parameter value (string)
  • ora-30558 : internal error [string] in function based index
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-24506 : invalid attempt to change character set id on env handle
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-13626 : The specified object string is not valid for task string.
  • ora-12319 : database (link name string) is already open
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-31509 : publication does not exist
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-39301 : schema "string" does not exist or is in use
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-34164 : (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
  • ora-07240 : slemrd: seek error.
  • ora-30571 : invalid SEGMENT SPACE MANAGEMENT clause
  • ora-12056 : invalid REFRESH method
  • ora-14126 : only a may follow description(s) of resulting partitions
  • ora-02182 : savepoint name expected
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-09817 : Write to audit file failed.
  • ora-23331 : column group string does not exist
  • ora-00256 : cannot translate archive destination string string
  • ora-29263 : HTTP protocol error
  • 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.