Avatar of vamsi_uk
vamsi_uk
 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
Oracle Database

Avatar of undefined
Last Comment
vamsi_uk

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
MikeOM_DBA

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy