Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pb Creating database using oracle scripts

Pb Creating database using oracle scripts

From: Saad Ben Barka <Saad.Ben.Barka_at_apic.fr>
Date: Thu, 10 Oct 2002 12:14:13 +0200
Message-ID: <ao3k1k$869$1@s1.read.news.oleane.net>


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

Received on Thu Oct 10 2002 - 05:14:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US