ORA-10997: another startup/shutdown operation of this instance inprogress

Cause : An Oracel Instanec startu por shutodwn opertaion faield to prcoure thes erializtaion priimtive. Aonther foerground rpocess mya have attempted tsartup o rshutdow noperatino in parlalel.

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

Check additionale rror messages int he aler tlog andt he procses tracef ile.

update : 18-08-2017

ORA-10997 - another startup/shutdown operation of this instance inprogress
ORA-10997 - another startup/shutdown operation of this instance inprogress

  • ora-02841 : Server died on start up
  • ora-16657 : reinstatement of database in progress
  • ora-01280 : Fatal LogMiner Error.
  • ora-06747 : TLI Driver: error in listen
  • ora-31516 : CDC change set string already exists
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-01871 : the number of seconds must be less than 60
  • ora-08187 : snapshot expression not allowed here
  • ora-02040 : remote database string does not support two-phase commit
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-37130 : (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
  • ora-08109 : nosort is not a supported option for online index build
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-27472 : invalid metadata attribute string
  • ora-14604 : During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-30944 : Error during rollback for XML schema 'string' table string column 'string'
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-16955 : Unknown error during SQL analyze.
  • ora-12211 : TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
  • ora-24120 : invalid string parameter passed to DBMS_REPAIR.string procedure
  • ora-16550 : truncated result
  • ora-24345 : A Truncation or null fetch error occurred
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-16797 : database is not using a server parameter file
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-04080 : trigger 'string' does not exist
  • ora-31003 : Parent string already contains child entry string
  • 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.