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_at_apic.fr> wrote in message
news:ao436n$kv2$1_at_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_at_audit-commission.gov.uk> a écrit dans le
> message de news: 3da5875b$0$1288$ed9e5944_at_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_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 - 10:00:17 CDT
