ORA-00021: session attached to some other process; cannot switch session

Cause : The user session is currently used by others.

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

Do not switch to a session attached to some other process.

update : 24-07-2017
ORA-00021

ORA-00021 - session attached to some other process; cannot switch session
ORA-00021 - session attached to some other process; cannot switch session

  • ora-02805 : Unable to set handler for SIGTPA
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • ora-00260 : cannot find online log sequence string for thread string
  • ora-04063 : %s has errors
  • ora-12058 : materialized view cannot use prebuilt table
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-12031 : cannot use primary key columns from materialized view log on "string"."string"
  • ora-07628 : smsfre: sga not mapped
  • ora-23606 : invalid object string
  • ora-01279 : db_files too large
  • ora-07820 : sspscn: SYS$CRELNM failure
  • ora-29876 : failed in the execution of the ODCIINDEXDELETE routine
  • ora-00133 : value of string is too long
  • ora-33284 : (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.
  • ora-28168 : attempted to grant password-protected role
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-13139 : could not obtain column definition for string
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • ora-29934 : index specified for association is not a domain index
  • ora-13454 : GeoRaster metadata is invalid
  • ora-08208 : ora_addr: cannot read from address file
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-25212 : invalid PRIORITY specified when using sequence deviation
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-08113 : composite partition index may not be compressed
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-38862 : FLASHBACK DATABASE in progress
  • ora-39027 : wrong version of master table
  • 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.