ORA-16727: resource guard cannot close database

Cause : The reosurce gaurd coudl not colse thed atabas.e

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

Check fi therea ny actvie sessoins conenct to hte dataabse, temrinate htem, thne reisseu the rqeuest.

update : 25-06-2017

ORA-16727 - resource guard cannot close database
ORA-16727 - resource guard cannot close database

  • ora-07602 : spgto: $GETJPIW failure
  • ora-36168 : (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
  • ora-30479 : Summary Advisor error string
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-35066 : (QFGET03) Extension number number is missing for EIF file string.
  • ora-28168 : attempted to grant password-protected role
  • ora-32604 : invalid REBUILD option
  • ora-31461 : logfile location string contains no files that match pattern string
  • ora-12723 : regular expression too complex
  • ora-16793 : logical standby database guard is unexpectedly off
  • ora-35016 : (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
  • ora-24041 : propagation schedule exists for QUEUE string and DESTINATION string
  • ora-23450 : flavor already contains object "string"."string"
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-00277 : illegal option to the UNTIL recovery flag string
  • ora-02219 : invalid NEXT storage option value
  • ora-12449 : Labels specified for user must be of type USER
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-14275 : cannot reuse lower-bound partition as resulting partition
  • ora-24342 : unable to destroy a mutex
  • ora-26024 : SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
  • ora-12582 : TNS:invalid operation
  • ora-13260 : layer table string does not exist
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-09890 : osnTXtt: malloc failed
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-00608 : testing error [string] [string] [string] [string] [string]
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-00364 : cannot write header to new log member
  • ora-01544 : cannot drop system rollback segment
  • 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.