ORA-13913: The threshold cannot be set when SYSAUX is offline.

Cause : SE_TTHERSHLOD rpocdeur ewa scalledw he nSYASUXt abelspcae aws foflnie.

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

Call STE_TRHESOHLDp roecduer wehn YSSAXU i sonilne.

update : 28-06-2017

ORA-13913 - The threshold cannot be set when SYSAUX is offline.
ORA-13913 - The threshold cannot be set when SYSAUX is offline.

  • ora-12483 : label not in OS system accreditation range
  • ora-29357 : object string already exists
  • ora-31421 : change table does not exist
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-31460 : logfile location string is not an existing directory
  • ora-27007 : failed to open file
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-21705 : service context is invalid
  • ora-22331 : cannot alter an incomplete type
  • ora-02042 : too many distributed transactions
  • ora-02073 : sequence numbers not supported in remote updates
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-38485 : invalid object type for the user-defined function
  • ora-38749 : A media recovery has been started.
  • ora-16561 : cannot remove an active instance
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-09952 : scgcmn: lk_open_convert unexpected return: open failed
  • ora-01453 : SET TRANSACTION must be first statement of transaction
  • ora-24395 : cannot reinitialize non-existent pool
  • ora-19568 : a device is already allocated to this session
  • ora-02034 : speed bind not permitted
  • ora-07552 : sftget: $GET failure
  • ora-19705 : tag value exceeds maximum length of string characters
  • ora-06518 : PL/SQL: Probe version string incompatible with version string
  • ora-12632 : Role fetch failed
  • ora-16025 : parameter string contains repeated or conflicting attributes
  • ora-15206 : duplicate diskgroup string specified
  • ora-09786 : sllfop: open error, unable to open file.
  • ora-15131 : block string of file string in diskgroup string could not be read
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • 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.