ORA-16631: operation requires shutdown of database/instance "string"

Cause : The Data Guard broker operation requires a shutdown of the database or instance.

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

If the client has not yet done so, please shutdown all Oracle instances for the database.

update : 30-04-2017
ORA-16631

ORA-16631 - operation requires shutdown of database/instance "string"
ORA-16631 - operation requires shutdown of database/instance "string"

  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-28554 : pass-through SQL: out of cursors
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-39137 : cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-27250 : OS system call failure
  • ora-29364 : plan directive string, string already exists
  • ora-16091 : dependent archive log destination already archived
  • ora-37004 : (AWLISTALL02) number reader
  • ora-12923 : tablespace string is in force logging mode
  • ora-13236 : internal error in R-tree processing: [string]
  • ora-24815 : Invalid character set form
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-32594 : invalid object category for COMMENT command
  • ora-29328 : too many datafiles in this tablespace 'string'
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-27041 : unable to open file
  • ora-19016 : attributes cannot occur after element specifications
  • ora-29376 : number of consumer groups string in top-plan string exceeds string
  • ora-25442 : too many column values for table alias: string
  • ora-07245 : sfccf: unable to lseek and write the last block.
  • ora-07721 : scgcm: not enough OS resource to obtain system enqueue
  • ora-23443 : missing template parameter
  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-09290 : sksaalo: error allocating memory for archival
  • ora-39166 : Object string was not found.
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • 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.