Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed02.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.server
References: <ao3jv7$84r$1@s1.read.news.oleane.net> <3da560bf$0$1292$ed9e5944@reading.news.pipex.net> <ao3rvb$ep7$1@s1.read.news.oleane.net> <3da5875b$0$1288$ed9e5944@reading.news.pipex.net> <ao436n$kv2$1@s1.read.news.oleane.net>
Subject: Re: Pb. Database creation using generated Oracle scripts
Date: Thu, 10 Oct 2002 16:00:17 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Lines: 277
Message-ID: <3da59602$0$1292$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: 1034262018 reading.news.pipex.net 1292 193.128.236.219
X-Complaints-To: abuse@uk.uu.net
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163733
X-Received-Date: Thu, 10 Oct 2002 08:00:20 MST (news.easynews.com)

use the orapwd utility. If you type orapwd at a command prompt you will get
a list of parameters. I'd use something like

orapwd file=<oraclehome directory>\pwdpcit.ora password=<your password>
entries=5


--
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@apic.fr> wrote in message
news:ao436n$kv2$1@s1.read.news.oleane.net...
> No, the problem is not resolved.
>
> How can I create the PWDpcit.ora file manually? I think, this must be done
> by the "Oracle scripts".
>
> When we run directly from the database assistant the creation of the DB,
we
> do not have to create any thing manually?
>
>
>
>
> --
> ********************************************************
>
> 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@audit-commission.gov.uk> a écrit dans le
> message de news: 3da5875b$0$1288$ed9e5944@reading.news.pipex.net...
> > 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@apic.fr> wrote in message
> > news:ao3rvb$ep7$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 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@audit-commission.gov.uk> a écrit dans
> le
> > > message de news: 3da560bf$0$1292$ed9e5944@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@apic.fr> wrote in message
> > > > news:ao3jv7$84r$1@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
> > > >
> > >
> >
>
> --------------------------------------------------------------------------
> > > > --
> > > > > -----------------------
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>