Re: Pb. Database creation using generated Oracle scripts

Thanks for your reply,

The error is because the "PWDpcit.ORA" file does not exist in the {ORACLE_HOME}\DATABASE directory.
This is what I found in the "pcitALERT.LOG" file and the "TRC" file. What I forgot to tell, is : If a create immediately the database with database assistant there is no problem.

Regards,

Dump file D:\oracle\ora90\RDBMS\trace\ORA01980.TRC Thu Oct 10 11:17:33 2002
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Instance name: pcit

Redo thread mounted by this instance: 1

Oracle process number: 12

Windows thread id: 1980, image: ORACLE.EXE

• SESSION ID:(7.15) 2002-10-10 11:17:33.000 ORA-01501: Echec CREATE DATABASE ORA-01990: erreur d'obtention du fichier mot de passe 'D:\oracle\ora90\DATABASE\PWDpcit.ORA' ORA-27041: ouverture du fichier impossible OSD-04002: ouverture impossible du fichier O/S-Error: (OS 2) Le fichier spécifié est introuvable.

--
********************************************************
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
*******************************************************
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit dans le
message de news: 3da560bf$0$1292$ed9e5944_at_reading.news.pipex.net...


> 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

>


> --------------------------------------------------------------------------

> --

> > -----------------------

> >

> >

> >

>
>