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 : 24-05-2017

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

  • ora-19615 : some files not found in backup set
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-31402 : unrecognized parameter string
  • ora-14271 : table is not partitioned by Composite Range method
  • ora-02337 : not an object type column
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-15113 : alias name 'string' refers to a directory
  • ora-02448 : constraint does not exist
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-22904 : invalid reference to a nested table column
  • ora-24404 : connection pool does not exist
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-31443 : deadlock detected while acquiring lock on string
  • ora-10865 : Control tracing of notification operations
  • ora-22812 : cannot reference nested table column's storage table
  • ora-26513 : push error: master proc. string$RP.string failed for trans:string seq:string
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-12418 : user string not found
  • ora-25403 : could not reconnect
  • ora-09354 : Windows 32-bit Two-Task driver: ORACLE task unexpectedly died
  • ora-09925 : Unable to create audit trail file
  • ora-00261 : log string of thread string is being archived or modified
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-19652 : cannot apply offline-range record to datafile string: file is fuzzy
  • ora-10916 : TABLESPACE GROUP already specified
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-31617 : unable to open dump file "string" for write
  • ora-30195 : reserved for future use
  • ora-27376 : event condition cannot be NULL
  • ora-39200 : Link name "string" is invalid.
  • 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.