Home » RDBMS Server » Server Administration » New database creation failed (Oracle Enterprise 11g r1 64 bits, Ubuntu server 8.04 64 bits)
New database creation failed [message #423959] Tue, 29 September 2009 07:43 Go to next message
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 #423969 is a reply to message #423959] Tue, 29 September 2009 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
find / -name install\* -ls | grep log
Re: New database creation failed [message #424108 is a reply to message #423959] Wed, 30 September 2009 04:45 Go to previous message
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 326 times)
Previous Topic: upgrade 9.2.0.1 to 9.2.0.6
Next Topic: DBA (merged 3)
Goto Forum:
  


Current Time: Wed Dec 07 03:20:32 CST 2016

Total time taken to generate the page: 0.08709 seconds