ORA-01597: cannot alter system rollback segment online or offline

Cause : Tried to online or offline the system rollback segment

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


update : 28-05-2017

ORA-01597 - cannot alter system rollback segment online or offline
ORA-01597 - cannot alter system rollback segment online or offline

  • ora-14098 : index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-26504 : operation not implemented
  • ora-32318 : cannot rename a materialized view
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-01259 : unable to delete datafile string
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-14521 : Default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-16744 : the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
  • ora-16132 : An error occurred during activation of the standby.
  • ora-14513 : partitioning column may not be of object datatype
  • ora-31600 : invalid input value string for parameter string in function string
  • ora-14323 : cannot add partition when DEFAULT partition exists
  • ora-26088 : scalar column "string" must be specified prior to LOB columns
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-14459 : missing GLOBAL keyword
  • ora-23450 : flavor already contains object "string"."string"
  • ora-01506 : missing or illegal database name
  • ora-32802 : value for string must be string
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-12011 : execution of string jobs failed
  • ora-28233 : double encryption not supported
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-01931 : cannot grant string to a role
  • ora-28533 : Heterogeneous Services coercion handling error
  • 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.