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!