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 : 20-08-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-12451 : label not designated as USER or DATA
  • ora-31192 : Resource string has not been checked out
  • ora-02362 : error closing file: string
  • ora-08114 : can not alter a fake index
  • ora-28168 : attempted to grant password-protected role
  • ora-00477 : SNP* process terminated with error
  • ora-40285 : label not in the model
  • ora-31628 : error getting worker process exception
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-01659 : unable to allocate MINEXTENTS beyond string in tablespace string
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-02786 : Size needed for shared region is greater than segment size
  • ora-14044 : only one partition may be moved
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-16140 : standby online logs have not been recovered
  • ora-16113 : applying change to table or sequence string
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-02714 : osnpwr: message send failure
  • ora-08275 : Environment variable unset
  • ora-19637 : backupPieceCreate requires file name when using DISK device
  • ora-00368 : checksum error in redo log block
  • ora-09312 : slspool: error spooling file to printer
  • ora-16771 : failover to a physical standby database failed
  • ora-01493 : invalid SAMPLE size specified
  • ora-12093 : invalid interim table "string"."string"
  • ora-12641 : Authentication service failed to initialize
  • ora-02825 : Request on free list was not free
  • ora-12158 : TNS:could not initialize parameter subsystem
  • ora-00268 : specified log file does not exist 'string'
  • 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.