ORA-01643: system tablespace can not be made read only

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

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

Laev essytme atbelsapc eraedw rtie.

update : 17-08-2017
ORA-01643

ORA-01643 - system tablespace can not be made read only
ORA-01643 - system tablespace can not be made read only

  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-39709 : incomplete component downgrade; string downgrade aborted
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-06538 : statement violates string RESTRICT_REFERENCES pragma
  • ora-27152 : attempt to post process failed
  • ora-02840 : Open of log file by client failed
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-14195 : ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object
  • ora-00981 : cannot mix table and system auditing options
  • ora-01493 : invalid SAMPLE size specified
  • ora-08458 : invalid format parameter
  • ora-23332 : group string is in use; cannot drop
  • ora-00972 : identifier is too long
  • ora-04067 : not executed, string does not exist
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-22064 : invalid NLS parameter string [string]
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-06119 : NETTCP: spurious client request
  • ora-32308 : object materialized views must use SELECT *
  • ora-39076 : cannot delete job string for user 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.