Re: CPU April 2005 patching madness

Hi Paul,
I've tried generating all possible forms available to me IIRC.

The only thing that works is startup pfile="full path to pfile".

I can't use the spfile, as it has 'remote_login_passwordfile=exclusive' set in it.

If I try to start the database with it, the password file cannot be found.

I cannot create a new spfile, with or without a full path.

Hope that answered it.

Jared

On 5/23/05, Paul Baumgartel <paul.baumgartel_at_gmail.com> wrote:
>
> Now I'm confused. You originally said that the problem was the Pfile,
> not the SPfile. I suggested specifying full path for Pfile but your
> reply said full path for SPfile generates same error. Which did you
> try?
>
> On 5/23/05, Jared Still <jkstill_at_gmail.com> wrote:
> > Hi Paul,
> >
> > Specifying a full path name for SPFILE generates the same error.
> >
> >
> >
> > On 5/23/05, Paul Baumgartel <paul.baumgartel_at_gmail.com> wrote:
> > > Jared,
> > >
> > >
> > > > Trying to create a new spfile is no good:
> > > >
> > > > SQL> create spfile='spfile_from_pfile.ora' from pfile;
> > > > create spfile='spfile_from_pfile.ora' from pfile
> > > > *
> > >
> > > Did you try specifying the full pfile path in this command? I usually
> > > take the default spfile location but spell out the pfile path:
> > >
> > > create spfile from
> > pfile='d:\oracle\admin\foobar\pfile\init.ora';
> > >
> > > Paul
> > >
> > >
> >
> >
> > --
> >
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
> >
>
>
> --
> Paul Baumgartel
> paul.baumgartel_at_gmail.com
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l