Re: Pb Creating database using oracle scripts

Thanks every body for your precious help.

Well first of all I am using Oracle 9i.

Oracle generates all the scripts I am using for database creation and also a bat file.

The content of the bat file is following:

REM Start of the file

set ORACLE_SID=PCIT

D:\oracle\ora90\bin\oradim -new -sid PCIT -startmode m -pfile D:\oracle\ora90\database\initPCIT.ora

D:\oracle\ora90\bin\oradim -edit -sid PCIT -startmode a

D:\oracle\ora90\bin\sqlplus /nolog
@D:\oracle\admin\PCIT\scripts\CreateDB.sql

D:\oracle\ora90\bin\sqlplus /nolog
@D:\oracle\admin\PCIT\scripts\CreateDBFiles.sql

D:\oracle\ora90\bin\sqlplus /nolog
@D:\oracle\admin\PCIT\scripts\CreateDBCatalog.sql

D:\oracle\ora90\bin\sqlplus /nolog @D:\oracle\admin\PCIT\scripts\JServer.sql

D:\oracle\ora90\bin\sqlplus /nolog @D:\oracle\admin\PCIT\scripts\ordinst.sql

D:\oracle\ora90\bin\sqlplus /nolog
@D:\oracle\admin\PCIT\scripts\interMedia.sql

D:\oracle\ora90\bin\sqlplus /nolog @D:\oracle\admin\PCIT\scripts\context.sql

D:\oracle\ora90\bin\sqlplus /nolog
@D:\oracle\admin\PCIT\scripts\postDBCreation.sql

REM End of the file

So In the beginning I just tried to run it. But the creation fails.

As you can see the syntaxe for ORADIM is not used in the bat file is not is this way :

oradim -new -sid <SID> -intpwd <PASSWORD> -startmode m -pfile <...\init.ora>

Perhaps for this reason it does not create The PWD file.

I will make the necessary changes, and I will try again.

The "CREATE DATABASE" command is in the first script "CreateDB.sql".

I confirm that it does not create the directory if needed.

I will try today or Monday morning.

Regards,

--
*******************************************************
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
*******************************************************

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> a écrit dans le message de
news: lacbqukqgj9b0ht6m7rrn740t200qjv8ga_at_4ax.com...


> On Thu, 10 Oct 2002 12:14:13 +0200, "Saad Ben Barka"

> <Saad.Ben.Barka_at_apic.fr> wrote:

>

> >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.

> >

> >

> >

> >

> If you are going to follow this route you need to create the instance

> first using the oradim utility as documented. The error message tells

> you don't have a password file, and most likely you don't have a

> service called OracleServicepcit running. Check out the documentation

> on oradim on how to create the instance.

>

> Hth

>

>

> Sybrand Bakker, Senior Oracle DBA

>

> To reply remove -verwijderdit from my e-mail address