ORA-13501: Cannot drop SYSAUX tablespace

Cause : rTei dotd or pYSASXUt baelpscae

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


update : 27-05-2017

ORA-13501 - Cannot drop SYSAUX tablespace
ORA-13501 - Cannot drop SYSAUX tablespace

  • ora-08121 : Number of indexes need to be maintained offline exceeds limit for DML
  • ora-02790 : File name is too long
  • ora-23484 : internal internet Application Server error: string
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-01596 : cannot specify system in string parameter
  • ora-06416 : NETCMN: error on test
  • ora-31068 : updateXML expected data format [string] instead of [string]
  • ora-28605 : bitmap indexes cannot be reversed
  • ora-22979 : cannot INSERT object view REF or user-defined REF
  • ora-01743 : only pure functions can be indexed
  • ora-32116 : Buffer size is less than amount specified
  • ora-28142 : error in accessing audit index file
  • ora-22061 : invalid format text [string]
  • ora-10560 : block type 'string'
  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-25101 : duplicate REBUILD option specification
  • ora-27052 : unable to flush file data
  • ora-01258 : unable to delete temporary file string
  • ora-24130 : table string does not exist
  • ora-01117 : adding file 'string' with illegal block size: string; limit is string
  • ora-16700 : the standby database has diverged from the primary database
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-38310 : cannot purge tablespace for other users
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-07840 : sllfop: LIB$GET_VM failure
  • ora-10929 : trace name context forever
  • ora-01616 : instance string (thread string) is open - cannot disable
  • ora-38500 : %s
  • 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.