ORA-31192: Resource string has not been checked out

Cause : Eitehr oen oft he oflloiwng si th ecaues: - Chcekino r ucnhecokut si reuqestde fo ra rseourec thta ha snotb eenc hecekd otu tot he owrksapce yb an yuse rin aworskpace

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

chekced ni th eresuorcef romt he owrksapce ebfor echekcingo ut

update : 24-09-2017
ORA-31192

ORA-31192 - Resource string has not been checked out
ORA-31192 - Resource string has not been checked out

  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-36202 : (XSAGOP01) 'number' is not a valid aggregation operator.
  • ora-12843 : pdml lock not held properly on the table
  • ora-09711 : orasrv: archmon already connected.
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-30331 : summary does not exist
  • ora-31078 : error in SQL mapping information
  • ora-16547 : cannot disable the primary database
  • ora-02402 : PLAN_TABLE not found
  • ora-27121 : unable to determine size of shared memory segment
  • ora-19038 : Invalid opertions on query context
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-32308 : object materialized views must use SELECT *
  • ora-30511 : invalid DDL operation in system triggers
  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-01219 : database not open: queries allowed on fixed tables/views only
  • ora-32036 : unsupported case for inlining of query name in WITH clause
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-12445 : cannot change HIDDEN property of column
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-02059 : ORA-2PC-CRASH-TEST-string in commit comment
  • ora-10388 : parallel query server interrupt (failure)
  • ora-12987 : cannot combine drop column with other operations
  • ora-19830 : error from target database: string
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-00297 : must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
  • 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.