getting ORA 1092 when trying to manually create a database...

[AJCG]

getting ORA 1092 when trying to manually create a database...

NT, Oracle 9i....

God knows why but here's a copy of my create script..

create database REPACG controlfile reuse
datafile 'D:\oradata\REPACG\control01.ctl' size 250 M reuse,
'D:\oradata\REPACG\control02.ctl' size 250 M reuse,
'D:\oradata\REPACG\control03.ctl' size 250 M reuse
autoextend on next 10M
LOGFILE 'D:\oradata\REPACG\log_1.dbf' size 500K REUSE,
'D:\oradata\REPACG\log_2.dbf' size 500K REUSE
maxdatafiles 254
maxlogfiles 32
maxinstances 16
maxlogmembers 2
maxloghistory 1600
character set UTF8
/

 

[cliousa]

Your syntax is totally wrong.

First, you don't have to create the control files in the CREATE DATABASE ... command. They are specified in the init.ora file and locations are taken from there.

Second, you are missing the SYSTEM tablespace.

Here is a file which works for 9i (Release 1). You can edit it to fit your needs.


connect SYS/change_on_install as SYSDBA
set echo on
spool D:\Oracle\901ee\assistants\dbca\logs\CreateDB_db04.log
startup nomount pfile="D:\Oracle\admin\db04\scripts\init.ora";
CREATE DATABASE db04
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE 'D:\Oracle\oradata\db04\system01.dbf' SIZE 325M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE 'D:\Oracle\oradata\db04\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P15
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('d:\Oracle\oradata\db04\redo01.log','d:\Oracle\oradata\db04\redo02.log') SIZE 100M,
GROUP 2 ('d:\Oracle\oradata\db04\redo03.log','D:\Oracle\oradata\db04\redo04.log') SIZE 100M,
GROUP 3 ('d:\Oracle\oradata\db04\redo05.log','D:\Oracle\oradata\db04\redo06.log') SIZE 100M;
spool off
exit;



Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com