init.ora

Does the init.ora file sit in the following directory in Win2000?

c:\Oracle\Ora8i\Database\init.ora

Should it be the following syntax: initfilename.ora

?

I think init.ora is the sample file.
You don't have any DB created already, do you?

I am creating a new one...a full dump from a different machine. I just want to direct it to the initfilename.ora file so that it uses the specified parameters.

There is an init.ora file that was created when I installed oracle8i.

Rara

The init file can sit anywhere as far as I know but at least it shoul dbe somewhere that makes sense
you will need to refer to the file when you create a service using Oradim

However I have done this in the past and when Ihave tried to start the database up, it says that it can't find the init file.
The way around this, is to see where Oracle thinks the init file is and create one file in that area as initSID.ora
this file should contain only 1 line

IFILE = 'insert path to whole initfile.ora'

Hope this helps

Cheers

Do you know how I can find where Oracle "thinks" it might be? I found one in the explorer...I will find. And, it was a one-liner. Thanks.

Try and start the database up via server manager at the DOS prompt and see what happens the check out that all the tables etc are present
If it starts up then there is a good chance you are using the correct initSID.ora
Cheers

this is the default place that Oracle will look for the file:
/oracle/product/8.1.5/dbs/

You can put it anywhere you want, but there must be a link (in unix) to that directory.

Hope this helps.

Thanks for your help...again, I am new and am simply trying to import a full db. Just trying to set up parameter files to allow for smooth import. It is slowly coming together.

I am really trying to learn, here.
:)

To do a full import you have to have a DB created.
To do a restore (cold restore) you have to have the instance created.

I am doing a full import.

I am gathering facts...I started by trying to import from command prompt, but all kinds of conflicts due to the files created during install of oracle.

I have an init.ora file that I just tweaked to work for my new db (which I am about to create). I want to point it to this new initSID.ora file so that everything will work smoothly.

Obviously, I am not a dba, just trying to import a database so that we can mess with the programming. Does this make any sense to you?

I thought that it might be a simple enought task...by definition, but it is a can of worms! I like it, though. I think I am getting hooked on this stuff! And, I really appreciate anyone who take the time to help me. Maybe I can help someday!

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]

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.

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.

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.

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

TerryD,

You are so nice!