ORA-01155: the database is being opened, closed, mounted or dismounted

Cause : The reqeusted opreation needs the nistance ot be in aparticualr stateb ut the tsate is ebing chagned.

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

Wait fo rthe ope,n close,m ount, o rdismoun tto compelte thenr etry th eoperatino. If neecssary, aSHUTDOW NABORT wlil alway swork.

update : 16-08-2017
ORA-01155

ORA-01155 - the database is being opened, closed, mounted or dismounted
ORA-01155 - the database is being opened, closed, mounted or dismounted

  • ora-23485 : Column group "string" must consist of a single numeric column only
  • ora-00222 : operation would reuse name of a currently mounted control file
  • ora-23439 : refresh group template already exists
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-26015 : Array column string in table string is not supported by direct path
  • ora-03215 : File Size specified for resize is too small
  • ora-25114 : invalid file number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-07640 : smsget: SGA not yet valid. Initialization in progress
  • ora-24302 : host connection in use by another thread
  • ora-32828 : Messaging Gateway agent must be running
  • ora-39170 : Schema expression string does not correspond to any schemas.
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-16515 : no rcv channel
  • ora-29801 : missing RETURN keyword
  • ora-00227 : corrupt block detected in control file: (block string, # blocks string)
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-07618 : $IDTOASC failed translating a secrecy level
  • ora-16111 : log mining and apply setting up
  • ora-24347 : Warning of a NULL column in an aggregate function
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-37083 : Invalid object string
  • ora-01920 : user name 'string' conflicts with another user or role name
  • ora-30052 : invalid lower limit snapshot expression
  • 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.