init.ora

[TerryD]

Are you creating it on a different machine?
i.e. a machine which only has Oracle installed and no database's set up?

If so, you're best bet on Win2000 is to just run the database creation wizard:

Go through the steps, but don't actually let it create the database - make it save it as scripts to run later (this will come up as an option).

Modify these scripts so that it creates the tablespaces and sizes you want.
Modify the init files:
Most likely: c:\Oracle\Ora8i\Database\initSID.ora
but on 8i this will include an ifile to:
c:\Oracle\Ora8i\admin\SID\pfile\init.ora

Once you've finished, run the scripts that were created, and it will create the database services, database, and run catalog etc. ready for you to import your database.


Terry


[Edited by TerryD on 11-09-2000 at 11:47 AM]

[rara]

Terry,

Hey. I just did the changes that you mentioned right before I saw your reply...which is a good thing.

By ifile, what do you mean?

I have the initSID.ora file fixed...I think.

[TerryD]

ifile mean 'include file' - it's just a pointed to another list of parameters. With the latest 8i stuff, generally the pfile that sits in the ora8i\database directory only contains one line which points to the ora8i\admin\SID\pfile directory.

It doesn't have to of course - it's just a way of helping to structure multiple database environments better.

[rara]

Terry,

Should "Ora8i\Database" be "Ora81\Database?" Just a syntax question...I think it is a "1."

And, I created file to point to the initSID.ora in the other directory...where all of the parameters are...thanks.

[TerryD]

Yes probably a typo - set it to what it is on your machine :)

[rara]

TerryD,

You are so nice!