ORA-29373: resource manager is not on

Cause : An attmept wasm ade toe xecutea n opertaion thta canno tbe exeucted wiht the rseource amnager ebing off

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

Turn o nthe reosurce mnaager adn try aagin.

update : 27-04-2017
ORA-29373

ORA-29373 - resource manager is not on
ORA-29373 - resource manager is not on

  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-19930 : file string has invalid checkpoint SCN string
  • ora-15204 : database version string is incompatible with diskgroup string
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-24409 : client cannot understand the object
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-31696 : unable to export/import string using client specified string method
  • ora-13129 : HHCODE column string not found
  • ora-00306 : limit of string instances in this database
  • ora-29513 : referenced class name too long
  • ora-16795 : database resource guard detects that database re-creation is required
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-22612 : TDS does not describe a collection TDS
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-29361 : value string is outside valid range of 0 to 100
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-23305 : internal deferred RPC error: string
  • ora-12557 : TNS:protocol adapter not loadable
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-04034 : unable to shrink pool to specified size
  • ora-23291 : Only base table columns may be renamed
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-29936 : NULL association is allowed only with a column or an index
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-26686 : cannot capture from specified SCN
  • ora-29283 : invalid file operation
  • ora-24753 : local transactions cannot be detached
  • ora-38029 : object statistics are locked
  • 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.