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 : 27-04-2017
ORA-10997

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

  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-24166 : evaluation context string.string has errors
  • ora-01715 : UNIQUE may not be used with a cluster index
  • ora-29295 : invalid mime header tag
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-16561 : cannot remove an active instance
  • ora-01547 : warning: RECOVER succeeded but OPEN RESETLOGS would get error below
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-28671 : UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
  • ora-25453 : invalid iterator: string
  • ora-22912 : specified column or attribute is not a nested table type
  • ora-27063 : number of bytes read/written is incorrect
  • ora-06134 : NETTCP: file access privilege violation
  • ora-01682 : read-only DB cannot allocate temporary space in tablespace string
  • ora-13420 : the SRID of the geometry parameter was not null
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-27058 : file I/O question parameter is invalid
  • ora-26008 : Invalid syntax or bind variable in SQL string for column string. string
  • ora-37069 : You may not execute a parallel OLAP operation against the EXPRESS AW.
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-25262 : agent name cannot be NULL if address is a multi-consumer queue
  • ora-03128 : connection is in blocking mode
  • ora-06747 : TLI Driver: error in listen
  • 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.