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-05-2017
ORA-01158

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

  • ora-24750 : incorrect size of attribute
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-19931 : file string has invalid creation SCN string
  • ora-12826 : hung parallel query server was killed
  • ora-02091 : transaction rolled back
  • ora-31493 : could not prepare session for LogMiner session
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-13910 : Parameter string cannot be NULL.
  • ora-16006 : audit_trail destination incompatible with database open mode
  • ora-01340 : NLS error
  • ora-31607 : function string is inconsistent with transform.
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-16231 : DDL barrier
  • ora-06314 : IPA: Event set up failure
  • ora-28041 : Authentication protocol internal error
  • ora-16129 : unsupported dml encountered
  • ora-09765 : osnmop: fork failed
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-19653 : cannot switch to older file incarnation
  • ora-39955 : invalid PL/SQL warning message number
  • ora-39167 : Tablespace string was not found.
  • ora-02030 : can only select from fixed tables/views
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-26689 : column datatype mismatch in LCR
  • ora-09212 : sfwfbmt: error writing to file
  • ora-15117 : command only operates on one diskgroup
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-24756 : transaction does not exist
  • ora-03248 : Too much of segment creation activity during migration
  • 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.