troubleshooting Question

oracle database creating error

Avatar of vamsi_uk
vamsi_uk asked on
Oracle Database
2 Comments1 Solution1747 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros