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 : 26-06-2017
ORA-01158

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

  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-39060 : table(s) dropped because of conflict with master table
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-06730 : TLI Driver: unable to open clone device
  • ora-00166 : remote/local nesting level is too deep
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-09266 : spawn: error starting an Oracle process
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-13361 : not enough sub-elements within a compound ETYPE
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-22306 : type "string"."string" already exists
  • ora-04083 : invalid trigger variable 'string'
  • ora-24324 : service handle not initialized
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • ora-31630 : a job name is required to attach a job for user string
  • ora-00911 : invalid character
  • ora-21703 : cannot flush an object that is not modified
  • ora-19234 : XQ0014 - invalid or unsupported must-understand extension
  • ora-07622 : smscre: $CREATE failure
  • ora-24274 : no row exists in the string table for these parameters
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-16653 : failed to reinstate database
  • ora-23333 : column string is already part of a column group
  • ora-36638 : (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
  • 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.