Re: Missing parameter file in 9.2.0.1

From: Randy Harris <randy_at_SpamFree.com>
Date: Wed, 26 May 2004 22:23:49 GMT
Message-ID: <VN8tc.22448$4j4.15738@newssvr31.news.prodigy.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:155ab0pl6f08qjsvm3sll0s8mejt35fr08_at_4ax.com...
> On Wed, 26 May 2004 22:00:58 GMT, "Randy Harris" <randy_at_SpamFree.com>
> wrote:
>
> >I created an instance (test) in 9.2.0.1 using the dbca. It created
> >spfiletest.ora but no inittest.ora, the binary but not the text pfile.
> >Isn't it supposed to? Did I do something wrong, or is this some sort of
> >bug?
> It is not a bug, it is working as designed, and it is likely
> documented

One thing that is peculiar, the dbstart script that comes with 9i looks for the pfile, not the spfile.

> Is there a way to generate the text, inittest.ora, from the binary?
> >
>
> create pfile from spfile

> That's all there is to it.
>
> But actually you shouldn't need the pfile
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed May 26 2004 - 17:23:49 CDT