Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create database fails with error ORA-01505: error in adding log files

AdrianKJun 14 2012 — edited Jun 20 2012
hi all,

hope someone can help me out, I'm trying to create a database using a SQL script, the content of the script is:
create database testora
user sys identified by oracle
user system identified by oracle
logfile group 1 ('/u01/app/oracle/oradata/testora/redo01a.log', '/u02/app/oracle/oradata/testora/redo01b.log') size 100m blocksize 512 reuse,
group 2 ('/u01/app/oracle/oradata/testora/redo02a.log', '/u02/app/oracle/oradata/testora/redo02b.log') size 100m blocksize 512 reuse,
group 3 ('/u01/app/oracle/oradata/testora/redo03a.log', '/u02/app/oracle/oradata/testora/redo03b.log') size 100m blocksize 512 reuse,
maxlogfiles 5
maxlogmembers 5
maxdatafiles 100
character set US7ASCII
national character set AL16UTF16
extent management local
datafile '/u01/app/oracle/oradata/testora/system01.dbf' size 400m reuse
sysaux datafile '/u01/app/oracle/oradata/testora/sysaux01.dbf' size 400m reuse
default tablespace users
datafile '/u02/app/oracle/oradata/testora/users01.dbf' size 500m reuse autoextend on maxsize unlimited
default temporary tablespace tempts1
tempfile '/u01/app/oracle/oradata/testora/temp01.dbf' size 20m reuse autoextend on maxsize 4g
undo tablespace undotbs1
datafile '/u01/app/oracle/oradata/testora/undotbs01.dbf' size 200m reuse autoextend on maxsize unlimited
;

It fails in creating the database with the following output:

SQL> @/home/oracle/Oracle_Scripts/testora_db_script.sql
create database testora
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01505: error in adding log files
ORA-01184: logfile group 1 already exists
Process ID: 3486
Session ID: 1 Serial number: 3
This post has been answered by viconstg on Jun 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2012
Added on Jun 14 2012
19 comments
2,917 views