Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01100: database already mounted
- 3 Answers
- 37690 Views
- Oracle, Wipro, I also Faced
- E-Mail Answers
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-07257: spdcr: translation error expanding program name.
ORA-30437: all job queue processes have stopped running
ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index
DRG-11502: read of file failed at line string for file string
QSM-02150: select lists must be identical across the UNION operator
PCB-00903: Pro*COBOL is unable to initialize its parser function
ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
DRG-11717: attempt to add Related Term string to non-Preferred Term string
ORA-02753: osnfsmmap: cannot close shared memory file
KUP-04081: field string used in concatenation for column string is not a character type
SQL*Loader-00524: partial record found at end of datafile (string)
TNS-00024: INTCTL: Unable to contact Navigator to obtain Connection Manager address
Oracle Errors 
