Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Manual Database Creation
Oraclelearner
post Jul 9 2008, 01:24 PM
Post #1


Advanced Member
***

Group: Members
Posts: 152
Joined: 6-May 08
From: 99324
Member No.: 22,933



I am having a problem creating a new databae on a windows 2003 server. When I execute the script to create the database. I am getting the following error message.

ORA-01501: CREATE DATABASE not successfull ORA-01100:
Database already MOUNT

can anyone provide any suggestions?

Regards,
Oraclelearner
Go to the top of the page
 
+Quote Post
SteveC
post Jul 9 2008, 01:33 PM
Post #2


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



You are creating a database on top of an existing one (the error message tells you that bit of information, should try reading and understanding them).
Go to the top of the page
 
+Quote Post
Oraclelearner
post Jul 9 2008, 02:06 PM
Post #3


Advanced Member
***

Group: Members
Posts: 152
Joined: 6-May 08
From: 99324
Member No.: 22,933



QUOTE (SteveC @ Jul 9 2008, 11:34 AM) *
You are creating a database on top of an existing one (the error message tells you that bit of information, should try reading and understanding them).


Steve,

There is no other database installed on this box. This is a brand new server on which I am doing a new install.
Go to the top of the page
 
+Quote Post
SteveC
post Jul 9 2008, 02:13 PM
Post #4


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



I beg to differ. What is the service name/SID you are trying to create? It is already in existence. You can't create a database named X on top of an existing database named X - regardless of the status: unmounted, mounted, or open.
Go to the top of the page
 
+Quote Post
Oraclelearner
post Jul 9 2008, 02:16 PM
Post #5


Advanced Member
***

Group: Members
Posts: 152
Joined: 6-May 08
From: 99324
Member No.: 22,933



QUOTE (SteveC @ Jul 9 2008, 12:14 PM) *
I beg to differ. What is the service name/SID you are trying to create? It is already in existence. You can't create a database named X on top of an existing database named X - regardless of the status: unmounted, mounted, or open.


Ok Steve, I will look into it.

Thanks for your help
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 29th July 2014 - 11:57 PM