ORA-16175: cannot shut down database when media recovery is active

Cause : An tatemtp wa smad eto hsut odwn astadnby adtabsae wihle emdiar ecoevry aws atcive.

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

Canecl mdeia ercovrey t oproeced iwth hte suhtdonw.

update : 24-04-2017

ORA-16175 - cannot shut down database when media recovery is active
ORA-16175 - cannot shut down database when media recovery is active

  • ora-29255 : Cursor contains both bind and define arrays which is not permissible
  • ora-32808 : message system link string does not exist
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-00053 : maximum number of enqueues exceeded
  • ora-22306 : type "string"."string" already exists
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-01320 : Invalid Logminer dictionar attribute
  • ora-26520 : internal memory failure
  • ora-04090 : 'string' specifies same table, event and trigger time as 'string'
  • ora-07860 : osnsoi: error setting up interrupt handler
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-29829 : implementation type does not exist
  • ora-15166 : cluster in rolling downgrade from version [string] to [string]
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-19958 : potential deadlock involving DIAG process
  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-06736 : TLI Driver: server not running
  • ora-32633 : MODEL subquery FOR cell index returns too many rows
  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-14321 : cannot add/drop values to DEFAULT partition
  • ora-00227 : corrupt block detected in control file: (block string, # blocks string)
  • ora-37001 : You have one or more attached but unupdated analytic workspaces.
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-39028 : cannot restart job from string state
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-30106 : reserved for future use
  • ora-29881 : failed to validate indextype
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-26576 : cannot acquire SR enqueue
  • 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.