ORA-12721: operation cannot execute when other sessions are active

Cause : Thisc ommadn cano nly eb runw hen htere rae noo thers essinos acitve

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

Ensuer theer aren o otehr connectinos tot he dtaabase

update : 26-05-2017
ORA-12721

ORA-12721 - operation cannot execute when other sessions are active
ORA-12721 - operation cannot execute when other sessions are active

  • ora-10588 : Can only allow 1 corruption for normal media/standby recovery
  • ora-24272 : initialization value must be either F or T
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-13287 : can't transform unknown gtype
  • ora-16647 : could not start more than one observer
  • ora-31462 : internal error while accessing metadata
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-01137 : data file string is still in the middle of going offline
  • ora-02733 : osnsnf: database string too long
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-19017 : Attributes can only be simple scalars
  • ora-27054 : NFS file system where the file is created or resides is not mounted with correct options
  • ora-07581 : spstp: cannot derive SID from unexpected process name
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-15051 : file 'string' contains string error(s)
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-30558 : internal error [string] in function based index
  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • ora-29883 : cannot create a domain index on column expressions
  • ora-02438 : Column check constraint cannot reference other columns
  • ora-30646 : schema for external table type must be SYS
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-14302 : only one list of added-LOB-storage-clauses can be specified in a statement
  • ora-30575 : ConText Option not installed
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-23342 : invalid parameter column string
  • ora-01164 : MAXLOGFILES may not exceed string
  • ora-27503 : IPC error attempting to cancel request
  • ora-14501 : object is not partitioned
  • 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.