ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

Cause : There i sat leas tone mor esessiono ther thna the current onel ogged itno the isntance. LATER DATBAASE CLOES is notp ermitte.d

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

Find th eother ssesions adn log thme out an dresubmi tthe comamnd

update : 22-08-2017
ORA-01093

ORA-01093 - ALTER DATABASE CLOSE only permitted with no sessions connected
ORA-01093 - ALTER DATABASE CLOSE only permitted with no sessions connected

  • ora-07850 : sllfop: bad option
  • ora-09213 : slgfn: error fabricating file name
  • ora-22801 : invalid object row variable
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-00226 : operation disallowed while alternate control file open
  • ora-19760 : error starting change tracking
  • ora-07743 : slemop: incorrect error file attributes
  • ora-23445 : missing template site
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-28011 : the account will expire soon; change your password now
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-07707 : error in archive text: need tape label name
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-31074 : XML comment length string exceeds maximum string
  • ora-01233 : file string is read only - cannot recover using backup control file
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-01591 : lock held by in-doubt distributed transaction string
  • ora-32400 : cannot use object id columns from materialized view log on "string"."string"
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-13460 : GeoRaster metadata SRS error
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-13528 : name (string) is already used by an existing baseline
  • ora-02037 : uninitialized speed bind storage
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-16818 : Fast-Start Failover suspended
  • 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.