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

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

  • ora-16618 : response document of size "string" bytes is too large
  • ora-13528 : name (string) is already used by an existing baseline
  • ora-09916 : Required password was not specified.
  • ora-14122 : only one REVERSE or NOREVERSE clause may be specified
  • ora-15048 : ASM internal files cannot be deleted
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-07255 : spini: cannot set up signal handler.
  • ora-28348 : index defined on the specified column cannot be encrypted
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-02090 : network error: attempted callback+passthru
  • ora-38705 : Expected block size string does not match string in log header.
  • ora-06405 : NETCMN: reset protocol error
  • ora-38622 : Decision Tree not enough memory, requires at least stringKB
  • ora-29815 : object being associated is not present
  • ora-12546 : TNS:permission denied
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-03210 : DBMS_ADMIN_PACKAGE invalid option specification
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-40226 : model upgrade/downgrade must be performed by SYS
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-38720 : Missing log file number.
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-30691 : failed to allocate system resources while registering a TCP/IP connection for data traffic detection
  • ora-21612 : key is already being used
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-26526 : materialized view sql ddl parse/expansion failed for string.string
  • ora-02792 : Unable to fstat() a file being used for asynchronous I/O.
  • ora-07252 : spcre: semget error, could not allocate semaphores.
  • 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.