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

None

update : 24-09-2017
ORA-01597

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

  • ora-40208 : duplicate or multiple algorithm settings for function string
  • ora-01244 : unnamed datafile(s) added to control file by media recovery
  • ora-07709 : sksaprs: archiving to a remote host is not allowed
  • ora-16069 : Archive Log standby database activation identifier mismatch
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-13346 : the coordinates defining an arc are collinear
  • ora-22060 : argument [string] is an invalid or uninitialized number
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-03219 : Tablespace 'string' is dictionary-managed, offline or temporary
  • ora-26698 : %s did not have a string rule set
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-36978 : (XSRELGID01) workspace object must be a self-relation.
  • ora-13184 : failed to initialize tessellation package
  • ora-02380 : profile string does not exist
  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-38728 : Cannot FLASHBACK DATABASE to the future.
  • ora-09835 : addCallback: callback port is already in a set.
  • ora-24317 : define handle used in a different position
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-02443 : Cannot drop constraint - nonexistent constraint
  • ora-10921 : Cannot drop tablespace belonging to default temporary tablespace group
  • ora-19756 : corrupt block number string found in change tracking file
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-07710 : sksaprs: file name buffer too small
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-06520 : PL/SQL: Error loading external library
  • ora-23611 : tablespace "string" has more than one data file
  • ora-09788 : sllfrb: unable to read file.
  • 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.