Home » RDBMS Server » Server Administration » Create database error -01501
Create database error -01501 [message #55391] Wed, 22 January 2003 09:29 Go to next message
Carlos Olmeda
Messages: 22
Registered: January 2003
Junior Member
Good morning,
I am trying to create a database in Oracle 7.3 with NT server as a operating system. I am having difficulty executing the script, the script runs however after completion I get ORA-01109 database not open. I aslo recieve the error message:
ORA-01501: CREATE DATABASE FAILED
ORA-00200 cannot create control file 'D:orantdatabasectl1.ora'
ORA-09200 sfccf: error creating file
OSD-04010: <create> option specified, file already exists.
Should I delete the control files from d:orantdatabase then run the script?.

Thank You.

Report message to a moderator

Re: Create database error -01501 [message #55393 is a reply to message #55391] Wed, 22 January 2003 10:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use reuse option in the script, so that the the existing control files will be read.
or
delete the control file ( if the script creates a new one).

Report message to a moderator

Re: Create database error -01501 [message #55400 is a reply to message #55391] Wed, 22 January 2003 11:18 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
do you have another database using that control file?
i would check that before you delete or reuse.

Report message to a moderator

Previous Topic: Oracle Report run slow and take 100% CPU
Next Topic: one schema per use vs one schema per application.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:43:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.