I'm not clear if you have resolved the problem or not. If pwdpcit.ora
doesn't exist you need to create it.
--
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:ao3rvb$ep7$1_at_s1.read.news.oleane.net...
> 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
> >
>
> --------------------------------------------------------------------------
> > --
> > > -----------------------
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Oct 10 2002 - 08:57:47 CDT
