ORA-25501: ALTER SYSTEM QUIESCE RESTRICTED command failed

Cause : Database resource manager failed to change plan.

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

Look at the alert logs to see detailed description of the error.

update : 26-06-2017
ORA-25501

ORA-25501 - ALTER SYSTEM QUIESCE RESTRICTED command failed
ORA-25501 - ALTER SYSTEM QUIESCE RESTRICTED command failed

  • ora-13777 : invalid list of attribute names
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-29839 : failed to validate implementation type
  • ora-01231 : cannot make read write - file string is offline
  • ora-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-17506 : I/O Error Simulation
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-27200 : skgfpgo: sbtpcstart returned error
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-01574 : maximum number of concurrent transactions exceeded
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-16645 : unexpected new instance interrupted current operation
  • ora-02778 : Name given for the log directory is invalid
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-16060 : Log file is current
  • ora-13453 : GeoRaster metadata layer error
  • ora-19719 : length for operation name longer than string
  • ora-13035 : Invalid data (arcs in geodetic data) in the SDO_GEOMETRY object
  • ora-13340 : a point geometry has more than one coordinate
  • ora-06752 : TLI: error in signal setup
  • ora-06516 : PL/SQL: the Probe packages do not exist or are invalid
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-28553 : pass-through SQL: invalid bind-variable position
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-01559 : MAXEXTENTS for rollback segment must be greater than 1
  • ora-39092 : unable to set SCN metadata for object "string.string" of type 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.