| New database creation failed [message #423959] |
Tue, 29 September 2009 07:43  |
dragos
Messages: 16
Registered: July 2009
|
Junior Member |
|
|
I have Oracle 11g r1 on Ubuntu server 8.04 both 64 bits.
Today I wanted to create another database with 2 users separate
from the production one but the creation failed.
I used dbca. I am not very familiar with oracle so
please help me find the logs to check why did it failed for
start.
Thank you
|
|
|
|
|
|
| Re: New database creation failed [message #424108 is a reply to message #423959] |
Wed, 30 September 2009 04:45  |
dragos
Messages: 16
Registered: July 2009
|
Junior Member |
|
|
I found the logs and I attached the
clonedbcreation.log and
trace.log
Yesterday it failed at 48%, today I tryed to create another
database bit this time I provided it with more memory but
it failed with these 2 errors
ORA-01503 CREATE CONTROLFILE failed
ORA-01158: database already mounted
I have 2 question:
1) Why did it failed creating these 2 databases ?
2) Is there a problem is there are some processes from
dbca hanged in a sleep state because it blocked and
I could not stop dbca yesterday - maybe the cause for
today's error were those hanged processes from yesterday?
Today's try with second attempt
-----cloneDBcreation.log-----
Create controlfile reuse set database "apextest"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database already mounted
trace.log is attached
-
Attachment: trace.log
(Size: 63.91KB, Downloaded 1341 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
