Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!nntp2.aus1.giganews.com!nntp.giganews.com!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!esplande3000.net!oleane.net!oleane!nnrp.oleane.net!not-for-mail From: "Saad Ben Barka" Newsgroups: comp.databases.oracle.server Subject: Pb. Database creation using generated Oracle scripts Date: Thu, 10 Oct 2002 12:12:56 +0200 Organization: Guest of France Telecom Oleane's newsreading service Lines: 109 Message-ID: NNTP-Posting-Host: 194.2.183.252 X-Trace: s1.read.news.oleane.net 1034244903 8347 194.2.183.252 (10 Oct 2002 10:15:03 GMT) X-Complaints-To: abuse@oleane.net NNTP-Posting-Date: Thu, 10 Oct 2002 10:15:03 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: newsfeed1.easynews.com comp.databases.oracle.server:163703 X-Received-Date: Thu, 10 Oct 2002 03:20:00 MST (news.easynews.com) 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 -- ---------------------------------------------------------------------------- ----------------------- Saâd Ben Barka Chef de Projet Apic SA - 113 Avenue Aristide Briand - 94117 Arcueil Cedex (France) Tél: +33 (0) 1 49 08 83 00 - Fax: +33 (0) 1 49 69 92 93 ---------------------------------------------------------------------------- -----------------------