asked on

oracle database creating error

Hi everyone,

Im trying to create a database in oracle 10g. While im trying to create the databse this is the error message im getting...

SQL> startup nomount
ORACLE instance started.

Total System Global Area 104857600 bytes
Fixed Size 1217860 bytes
Variable Size 83888828 bytes
Database Buffers 16777216 bytes
Redo Buffers 2973696 bytes
SQL> @cr8db.sql
create database FABDEV1 datafile '/home/oracle/10.2.0/oradata/FABDEV1/system01.dbf' size 100M
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00336: log file size 1000 blocks is less than minimum 8192 blocks

###########################################################
This is the cr8db.sql script i have written
###########################################################

create database FABDEV1 datafile '/home/oracle/10.2.0/oradata/FABDEV1/system01.dbf' size 100M
undo tablespace "UNDOTBS" datafile '/home/oracle/10.2.0/oradata/FABDEV1/undotbs01.dbf' size 80M
sysaux datafile '/home/oracle/10.2.0/oradata/FABDEV1/sysaux01.dbf' size 400M
default temporary tablespace "TEMP" tempfile '/home/oracle/10.2.0/oradata/FABDEV1/temp01.dbf' size 50M
logfile group 1 ('/home/oracle/10.2.0/oradata/FABDEV1/redolog1.log') size 500k,
group 2 ('/home/oracle/10.2.0/oradata/FABDEV1/redolog2.log') size 500k
controlfile reuse;

Does anyone know what the problem is?

Thank You
Vamsi

ASKER CERTIFIED SOLUTION

MikeOM_DBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vamsi_uk

ASKER

Ahh i didnt realize that the minimum logfile size has changed to 4M from 10g version. Anyway thanks for your quicck response.

Cheers!!
Vamsi