My Oracle Support Banner

Create Database Encounters ORA-01501 ORA-01505 ORA-01184 (Doc ID 1481961.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

 create database statement fails with ORA-1501, ORA-1505 and ORA-1184 errors 

$ cat createdatabase.sql

create database test
user sys identified by oracle
user system identified by oracle
logfile group 1('+DATADG01/test/oradata/redo01.log') size 100m,
group 2('+DATADG01/test/oradata/redo02.log') size 100m,
group 3('+DATADG01/test/oradata/redo03.log') size 100m, --Here unnecessary "," need to be removed
maxlogfiles 30
maxlogmembers 5
maxdatafiles 500
maxloghistory 1
maxinstances 10
character set zhs16gbk
national CHARACTER SET AL16UTF16
datafile '+DATADG01/test/oradata/system01.dbf' size 1024m
extent management local
sysaux datafile '+DATADG01/test/oradata/sysaux01.dbf' size 1024m
default temporary tablespace temp01
tempfile '+DATADG01/test/oradata/temp01.dbf' size 100m
undo tablespace undotbs01 datafile '+DATADG01/test/oradata/undotbs01_01.dbf' size 1024m; 

When try to run this script after the STARTUP NOMOUNT state gives errors ORA-1501 ORA-1505 and ORA-1184

SQL> @createdatabase.sql
create database test
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01505: error in adding log files
ORA-01184: logfile group 1 already exists 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.