Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rs_arwar@hotmail.com (Rauf Sarwar)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Pb Creating database using oracle scripts
Date: 10 Oct 2002 14:25:07 -0700
Organization: http://groups.google.com/
Lines: 69
Message-ID: <92eeeff0.0210101325.6d12d360@posting.google.com>
References: <ao3k1k$869$1@s1.read.news.oleane.net> <ao3pc4$ca8$1@babylon.agtel.net> <ao3s1p$eto$1@s1.read.news.oleane.net>
NNTP-Posting-Host: 192.198.23.44
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034285107 24748 127.0.0.1 (10 Oct 2002 21:25:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 21:25:07 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:87693
X-Received-Date: Thu, 10 Oct 2002 14:25:03 MST (news.easynews.com)

"Saad Ben Barka" <Saad.Ben.Barka@apic.fr> wrote in message news:<ao3s1p$eto$1@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@dpsp-yes.com> a ecrit dans le message de
> news: ao3pc4$ca8$1@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@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