Re: Pb Creating database using oracle scripts

"Saad Ben Barka" <Saad.Ben.Barka_at_apic.fr> wrote in message news:<ao3s1p$eto$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 specifie est introuvable.
>
> --
> ********************************************************
> Saad Ben Barka
> Chef de Projet
> Apic SA - 113 Avenue Aristide Briand - 94117 Arcueil Cedex (France)
> Tel: +33 (0) 1 49 08 83 00 - Fax: +33 (0) 1 49 69 92 93
> *******************************************************
> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> a ecrit dans le message de
> news: ao3pc4$ca8$1_at_babylon.agtel.net...
> > 1092 means the instance crashed and you probably can find out the reason
> > in alert log and trace files if there are any. This may be a bug or a
> > misconfiguration issue. Without seeing messages from alert log and/or
> trace
> > it's hard to tell more.
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com)
> http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
> applications.
> > All opinions are mine and do not necessarily go in line with those of my
> employer.
> >

Correction on previous post.

Use "sqlplus /nolog" instead of "svrmgrl" for 9i. Also use "connect sys as sysdba" instead of "connect internal". I assumed you were on 8i which I should not have.

/Rauf Sarwar Received on Thu Oct 10 2002 - 16:25:07 CDT