Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!nntp2.aus1.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.stueberl.de!teaser.fr!oleane.net!oleane!nnrp.oleane.net!not-for-mail From: "Saad Ben Barka" Newsgroups: comp.databases.oracle.server Subject: Re: Pb. Database creation using generated Oracle scripts Date: Thu, 10 Oct 2002 14:29:32 +0200 Organization: Guest of France Telecom Oleane's newsreading service Lines: 189 Message-ID: References: <3da560bf$0$1292$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: 194.2.183.252 X-Trace: s1.read.news.oleane.net 1034253099 15143 194.2.183.252 (10 Oct 2002 12:31:39 GMT) X-Complaints-To: abuse@oleane.net NNTP-Posting-Date: Thu, 10 Oct 2002 12:31:39 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: newsfeed1.easynews.com comp.databases.oracle.server:163717 X-Received-Date: Thu, 10 Oct 2002 05:34:58 MST (news.easynews.com) 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" 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" 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 > > -------------------------------------------------------------------------- > -- > > ----------------------- > > > > > > > >