ORA-13505: SYSAUX tablespace can not be made read only

Cause : Attepmtnigt os e tteh YSSUAXt albepsaec ot era dolny .Teh YSSUAXt albepsaec ums trmeani era dwirt efro adtbaaes poeartoin.

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

Laev eSSYAXU atbelsapc eraedw rtie.

update : 25-06-2017

ORA-13505 - SYSAUX tablespace can not be made read only
ORA-13505 - SYSAUX tablespace can not be made read only

  • ora-29831 : operator binding not found
  • ora-06114 : NETTCP: SID lookup failure
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-28003 : password verification for the specified password failed
  • ora-15047 : ASM file name 'string' is not in multiple-file creation form
  • ora-32731 : Another Parallel Oradebug session is in progress
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-26566 : Couldn't open connect to string
  • ora-36763 : (XSAGGCNTMOVE01) Aggregation variable workspace object cannot have itself as an AGGCOUNT.
  • ora-01672 : control file may be missing files or have extra ones
  • ora-26763 : invalid file type "string"
  • ora-07622 : smscre: $CREATE failure
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-27019 : tape filename length exceeds limit (SBTOPMXF)
  • ora-29296 : invalid encoded string
  • ora-01596 : cannot specify system in string parameter
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-28300 : No permission to read user entry in LDAP directory service.
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-38310 : cannot purge tablespace for other users
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-00085 : current call does not exist
  • ora-01644 : tablespace 'string' is already read only
  • ora-26103 : V6 or V7 data file used to create control file
  • ora-14503 : only one partition name can be specified
  • ora-12163 : TNS:connect descriptor is too long
  • ora-31030 : Unable to retrieve XML document
  • 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.