ORA-31191: Resource string is already checked out

Cause : Eithre oneo f th efollwoing si thec ause : - hCeckotu is erquesetd fo ra reosurcet hat si alraedy cehckedo ut t othe owrkspcae byt he smae ofd iffeernt uesr.

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

checekd int he rseourc efromt he wrokspaec befroe chcekingo ut

update : 26-06-2017
ORA-31191

ORA-31191 - Resource string is already checked out
ORA-31191 - Resource string is already checked out

  • ora-12989 : invalid value for checkpoint interval
  • ora-00486 : ASMB process terminated with error
  • ora-08309 : sllfop: Cannot fstat file
  • ora-30129 : invalid function argument received
  • ora-25232 : duplicate recipients specified for message
  • ora-01876 : year must be at least -4713
  • ora-24413 : Invalid number of sessions specified
  • ora-00470 : LGWR process terminated with error
  • ora-02793 : Close of asynchronous I/O failed.
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-24414 : Only number sessions could be started.
  • ora-25353 : branch marked for deletion
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-24379 : invalid user callback type
  • ora-16038 : log string sequence# string cannot be archived
  • ora-37007 : (AWLISTALL05) number writer
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-09212 : sfwfbmt: error writing to file
  • ora-22611 : TDS version is not recognized
  • ora-01337 : log file has a different compatibility version
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-13617 : The specified task string already executing
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-39015 : job is not running
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-24415 : Missing or null username.
  • 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.