Trying to create a database, getting message database already mounted

Posted on 2008-11-03
Last Modified: 2013-11-11

Trying to create a new database; however, getting messages:
ORA-01100: database already mounted

what is the issue and how do I resolve it.
This is Oracle 11g
Thanks, MaryOS88
Question by:MaryOS88
    LVL 34

    Assisted Solution

    One possibility is that you are trying to run a script from SQL*Plus in a session that has already done an instance startup that included mounting (or opening) an existing Oracle database, but the script you are running includes an "alter database mount" or "alter database" open command.

    Another possibililty is not having the value for the environment variable: ORACLE_SID set correctly.

    Which O/S do you have?  Does the server already have one (or more) Oracle database instances running on it, or are you trying to create the first one?
    LVL 34

    Accepted Solution

    Did you try to create the database once already and it failed?  If so, do a shutdown abort first, then try creating the database again.
    LVL 15

    Assisted Solution

    by:Devinder Singh Virdi
    Apart from above comment, You can check how many database you have in window environment by opening control Pannel/Administrative Tools/Services then look for OracleService<database_name>. If you are working in unix, then locate /etc/oratab file, so that you can see how many databases are present in your system or use ps -elf | grep smon to see currently running instance. I know this is not what you want, but will help you before creating database.

    Author Closing Comment

    Johnsone, Thanks your answer pointed me in the right direction, virdi ds and markgeer you gave me excellant ideas to find the problem

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now