ORA-01100: database already mounted
Answers were Sorted based on User's Feedback
Answer / harbai computer education
ORA-01100: database already mounted
First off, what Oracle calls a "database" is generally different than what most other database products call a "database". A "database" in MySQL or SQL Server is much closer to what Oracle calls a "schema" which is the set of objects owned by a particular user. In Oracle, you would generally only have one database per server (a large server might have a handful of databases on it) where each database has many different schemas. If you are using the express edition of Oracle, you are only allowed to have 1 database per server. If you are connected to Oracle via SQL Developer, that indicates that you already have the Oracle database created.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Cause: A database is already mounted in this instance.
Action: none
Please add more information about this Error
Is This Answer Correct ? | 13 Yes | 16 No |
i think "database already mounted" means that
oracle instance is associated with your current database (
which ever you have database name (name may be "xe") )
so your new database in not creating because that instance
is engaged with your older database ,
ACTION - edit the pfile ( it is the file to create new
instance parameter) so that new instance will be created
now you can write the create database statement
Is This Answer Correct ? | 19 Yes | 29 No |
ORA-02185: a token other than WORK follows COMMIT
ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
QSM-00755: a set of workload statements already exists for workload string
RMAN-06718: could not find file "string" in catalog
ORA-13155: invalid number of dimensions specified
ORA-01478: array bind may not include any LONG columns
ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
ORA-19703: device command string exceeds maximum length of string
RMAN-06448: uncataloged proxy copy
PLS-00379: CASE statements are not included in this release of PL/SQL
ORA-09273: szrfc: error verifying role name
ORA-16575: request terminated at broker discretion