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 : 21-08-2017
ORA-15040

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

  • ora-19854 : error obtaining connect string from target
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-01170 : file not found 'string'
  • ora-25289 : Buffer Already Exists
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-02174 : Missing required thread number
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-14018 : partition bound list contains too few elements
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-25532 : MTTR specified is too large: string
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-29931 : specified association does not exist
  • ora-29298 : Character set mismatch
  • ora-07580 : spstp: $GETJPIW failure
  • ora-00290 : operating system archival error occurred. See error below
  • ora-09826 : SCLIN: cannot initialize atomic latch.
  • ora-13799 : threshold not found
  • ora-13198 : Spatial error: string
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-09815 : File name buffer overflow
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-01481 : invalid number format model
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-00257 : archiver error. Connect internal only, until freed.
  • 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.