Re: init.ora file?

From: Patrice Castet <patrice.castet_at_in-fusio.com>
Date: Wed, 26 Feb 2003 13:37:05 GMT
Message-ID: <3e5cc212.91693078@read.news.fr.uu.net>

on 9i you should use a binary file, not editable any longer and dynamically modifiable without (usually ...) restarting the db. It is the "spfile".
the init.ora should be used only if you need specific startups not included in the normal spfile, or if you migrate from a 8i db. init.oras can be generated easily with the admin console in "all parameters" section of your instance.

On Wed, 26 Feb 2003 13:18:28 +0200, "James" <james_at_nothing.com> wrote:

>Hi there
>I'm using Oracle 9 on a windows 2k machine.
>I can't find the init.ora file!
>I can find the init.ora.21200311 file in the f:\oracle\admin\seconddb\pfile
>directory. Is this the file that is termed init.ora? If so how does the last
>part of the name get made? (the 21200311?)
>
>Secondly I also have a SPFILESECONDDB.ora file in the
>f:\oracle\ora92\database directory
>
>Hope someone can help
>Thanks in Advance
>Cheers
>James
>
>
Received on Wed Feb 26 2003 - 07:37:05 CST