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 : 26-06-2017
ORA-01643

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

  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-13264 : geometry identifier column string does not exist in table string
  • ora-07740 : slemop: incorrect handle size (programming error)
  • ora-16514 : the request was not found
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-37108 : (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.
  • ora-02157 : no options specified for ALTER USER
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-38712 : Corrupt flashback log record header: block string, offset string.
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-10916 : TABLESPACE GROUP already specified
  • ora-26680 : object type not supported
  • ora-01229 : data file string is inconsistent with logs
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-02236 : invalid file name
  • ora-06529 : Version mismatch - PL/SQL profiler
  • ora-33450 : (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-16550 : truncated result
  • ora-14265 : data type or length of a table subpartitioning column may not be changed
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-14292 : Partitioning type of table must match subpartitioning type of composite partition
  • 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.