ORA-01158: database string already mounted

Cause : Anothe rinstanec has ad atabas eby thi sname muonted.

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

Find wihch insatnce iss till rnuning. ePrhaps oyu haven ot los tthe cotnrol fiels afte rall.

update : 24-04-2017
ORA-01158

ORA-01158 - database string already mounted
ORA-01158 - database string already mounted

  • ora-19035 : Invalid select item of the query in newContextFromHierarchy()
  • ora-37112 : OLAP API requires Oracle 9.2 or later
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-26706 : cannot downgrade capture process
  • ora-13901 : Object string was not found.
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-32037 : unsupported use of LEVEL in membership condition
  • ora-13265 : geometry identifier column string in table string is not of type NUMBER
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-02729 : osncon: driver not in osntab
  • ora-29854 : keyword BITMAP may not be used in creating domain indexes
  • ora-07470 : snclget: cannot get cluster number.
  • ora-19512 : file search failed
  • ora-17610 : file 'string' does not exist and no size specified
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-39106 : Worker process string failed during startup. Worker error:
  • ora-28515 : cannot get external object definitions from string
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-22327 : cannot change a type to NOT INSTANTIABLE if it has dependent tables
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-09982 : skxfqddrg: Error Removing a page from the SDI buffer pool
  • ora-15064 : communication failure with ASM instance
  • ora-39763 : stream must be completely loaded before it is reset
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-01743 : only pure functions can be indexed
  • ora-39780 : Direct path context operations are not allowed after the context is aborted or finished
  • 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.