Home » RDBMS Server » Server Administration » create database error
create database error [message #132548] Sun, 14 August 2005 10:27 Go to next message
manogya
Messages: 2
Registered: August 2005
Location: Hyderabad
Junior Member
hi,

I am creting a new database on Linux 9, I am getting error when iam trying to create the database. Please provide the solution.

Error type:

ORA-01501
ORA-00301
ORA-27038
and again if i modify the size of the logfile agin i am getting the error type

ORA-01092: Oracle instance terminated, Disconnection forced.

Please provide the solution.



Thanks in advance,

Report message to a moderator

Re: create database error [message #132791 is a reply to message #132548] Tue, 16 August 2005 04:25 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Description of these errors:

ORA-01501: CREATE DATABASE failed
Cause: An error occurred during CREATE DATABASE.
Action: See accompanying errors.

ORA-00301: error in adding log file 'string' - file cannot be created
Cause: The creation of the redo log file failed
Action: Check whether:

1. There is enough storage space on the device
2. The name of the file is valid
3. The device is online
4. An I/O error occurred

Also, it is possible REUSE was specified on the command line and a file of the incorrect size exists. Either do not specify REUSE or use a file of the correct size.

ORA-27038: skgfrcre: file exists
Cause: Trying to create a database file, but file by that name already exists.
Action: Verify that name is correct, specify reuse if necessary.

Now, to start, look at the alert log file for the error text. Delete all files created by last unsuccessful db creation command. & then try again.

Regds
Girish

Report message to a moderator

Previous Topic: Find used/free space of a tablespace
Next Topic: Script for performing clean shutdown before windows shutdown
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:23:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.