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

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

  • ora-32126 : Cannot perform operations on a null REF
  • ora-16196 : database has been previously opened and closed
  • ora-32034 : unsupported use of WITH clause
  • ora-28330 : encryption is not allowed for this data type
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-07400 : slemtr: translated name for the message file is too long.
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-02035 : illegal bundled operation combination
  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-22812 : cannot reference nested table column's storage table
  • ora-33269 : while operating on 'string'
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-30201 : Unable to load NLS data object
  • ora-27087 : unable to get share lock - file not readable
  • ora-10632 : Invalid rowid
  • ora-27513 : parameter string contains invalid value string
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-13379 : invalid index for sub-element to be extracted
  • ora-22320 : missing user version string
  • ora-30465 : supplied run_id is not valid: string
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-23611 : tablespace "string" has more than one data file
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-16551 : short string copied
  • ora-29351 : can not transport system, sysaux, or temporary tablespace 'string'
  • ora-28053 : the account is inactive
  • 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.