Re: init.ora file?

On Wed, 26 Feb 2003 13:37:05 +0000, Patrice Castet wrote:

> on 9i you should use a binary file,

No you shouldn't. On 9i, you should strive as hard as possible to *avoid* using the spfile. It is a royal pain in the butt to work with, and gives you precisely no advantages over the good old init.ora -but also gives you plenty of disadvantages (such as not being editable, meaning that any illegal values that get in there (which it doesn't trap for) can only be gotten out of there by the tedious business of exporting it to an init.ora, editing the init.ora, and re-exporting back to an spfile).

It was principally designed for use in a RAC environment, where having one file to maintain instead of 2, 4, 8, 32 or whatever is indeed a very big advantage. Except that you can also use a single boring old init.ora in a RAC environment, with the "Dot Notation", do do precisely the same job, so even in a RAC there's no need for the spfile.

To our original poster, I'd simply suggest issuing the command 'create pfile from spfile', and Lo! You will have an init.ora back again in the default location. Delete the spfile afterwards (because that gets used in preference to an init.ora), and save yourself a lot of grief.

Regards
HJR
>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 - 13:32:13 CST