| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Pb. Database creation using generated Oracle scripts
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...Received on Thu Oct 10 2002 - 09:32:56 CDT
> 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
> > >
> >
>
> --------------------------------------------------------------------------
> > > --
> > > > -----------------------
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
 |
 |