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 : 17-08-2017
ORA-01158

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

  • ora-16803 : unable to query a database table or fixed view
  • ora-12674 : Shared server: proxy context not saved
  • ora-27491 : repeat_interval and start_date cannot both be NULL
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-19760 : error starting change tracking
  • ora-16789 : missing standby redo logs
  • ora-12486 : effective max labels and min labels cannot be changed
  • ora-32508 : no such watchpoint id
  • ora-08111 : a partitioned index may not be coalesced as a whole
  • ora-23300 : %s
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-39157 : error appending extension to file "string"
  • ora-12696 : Double Encryption Turned On, login disallowed
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-31204 : DBMS_LDAP: PL/SQL - Invalid LDAP Session.
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-12625 : TNS:missing argument
  • ora-06402 : NETCMN: error receiving break message
  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-01550 : cannot drop system tablespace
  • ora-13340 : a point geometry has more than one coordinate
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-01913 : EXCLUSIVE keyword expected
  • ora-06112 : NETTCP: invalid buffer size
  • ora-39005 : inconsistent arguments
  • ora-12100 : materialized view log on "string"."string" already has sequence
  • ora-01315 : Log file has been added or removed during select
  • 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.