The error you are getting is saying that oracle has stopped. You should find
more details in the alert log for the database.
The other thing that may be a problem for you is if you are using terminal
server.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Saad Ben Barka" <Saad.Ben.Barka_at_apic.fr> wrote in message
news:ao3jv7$84r$1_at_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 - 06:13:03 CDT
