Create database fails with error ORA-01505: error in adding log files
AdrianKJun 14 2012 — edited Jun 20 2012hi 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