ORA-16710: the resource guard is out of memory

Cause : Ther esoruce ugardw as nuabl eto laloctae mmeoryw hil etrynig t oserivce areqeust.

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

Disbale rboke rmangaemetn oft he ocnfiugratoin, hsut odwn rOacl,e inrceas eSGAs ize ,andr estrat.

update : 29-06-2017
ORA-16710

ORA-16710 - the resource guard is out of memory
ORA-16710 - the resource guard is out of memory

  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-19604 : conversation file naming phase is over
  • ora-07210 : slcpu: getrusage error, unable to get cpu time.
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-24143 : invalid evaluation context name
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-16225 : Missing LogMiner session name for Streams
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-02207 : invalid INITRANS option value
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-22933 : cannot change object with type or table dependents
  • ora-16608 : one or more databases have warnings
  • ora-27072 : File I/O error
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-38853 : cannot mark instance string (redo thread string) as disabled
  • ora-15168 : rolling downgrade prevented by string
  • ora-02712 : osnpop: malloc failed
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-01271 : Unable to create new file name for file string
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-02233 : invalid CLOSE mode
  • ora-34363 : (MXDSS13) number other user writing
  • ora-02768 : Maximum number of files is invalid
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • ora-31091 : empty string specified as a SQL name
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-15169 : destination 'string' is a subdirectory of '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.