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 : 26-09-2017

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

  • ora-37172 : illegal dimension type
  • ora-31439 : subscription is already active
  • ora-31417 : column list contains control column string
  • ora-12545 : Connect failed because target host or object does not exist
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-03134 : Connections to this server version are no longer supported.
  • ora-13023 : interior element interacts with exterior element
  • ora-16214 : apply stalled for apply delay
  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-28176 : incorrect certificate version
  • ora-29845 : indextype does not support local domain index on string partitioned table
  • ora-38449 : table "string" does not exist or is not accessible
  • ora-19932 : control file is not clone or standby
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-19693 : backup piece string already included
  • ora-03201 : the group number specification is invalid
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-23309 : object string.string of type string exists
  • ora-28172 : distinguished name not provided by proxy
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-32166 : Cannot get XA connection
  • ora-37000 : (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.
  • ora-30384 : specified column name does not exist in the attribute
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-15195 : Internal ASM testing event number 15195
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-29655 : USING clause is incompatible with its supertype
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-37153 : unknown exception caught: (case 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.