Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Pb Creating database using oracle scripts
Hello,
I want to generate a new database automatically.
I am working on Windows 2000 / and using Oracle 9i.
I use the database assistant to set up my parameters, and at the end I don't select
the option "create the Database", I just select the option generate scripts.
The database creation fails when running the first script ( CreateBD.sql )
I noticed following :
I have to create the directory. Create Database does not create the directory if it does not exist.
So I created the directory before running the script. But the script still fails.
Can any body help me?
The error I got is:
SQL> startup nomount pfile="D:\oracle\admin\PCIT\scripts\init.ora";
Instance ORACLE lancée.
Total System Global Area 353136872 bytes
Fixed Size 282856 bytes Variable Size 184549376 bytes Database Buffers 167772160 bytes Redo Buffers 532480 bytes
SQL> CREATE DATABASE PCIT
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 100
7 DATAFILE 'D:\oracle\oradata\PCIT\system01.dbf' SIZE 250M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 UNDO TABLESPACE "UNDOTBS" DATAFILE
'D:\oracle\oradata\PCIT\undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
9 CHARACTER SET WE8MSWIN1252
10 NATIONAL CHARACTER SET AL16UTF16
11 LOGFILE GROUP 1 ('D:\oracle\oradata\PCIT\redo01.log') SIZE 30M,
12 GROUP 2 ('D:\oracle\oradata\PCIT\redo02.log') SIZE 30M,
13 GROUP 3 ('D:\oracle\oradata\PCIT\redo03.log') SIZE 30M;
CREATE DATABASE PCIT *
ERREUR à la ligne 1 :
ORA-01092: instance ORACLE terminée. Déconnexion forcée
SQL> spool off
--