Re: ORA-01031: insufficient privileges

From: EdStevens <quetico_man_at_yahoo.com>
Date: Wed, 15 Aug 2007 06:03:35 -0700
Message-ID: <1187183015.911498.258510@b79g2000hse.googlegroups.com>

On Aug 14, 2:35 pm, sybra..._at_hccnet.nl wrote:
> On Tue, 14 Aug 2007 05:43:59 -0700, EdStevens <quetico_..._at_yahoo.com>
> wrote:
>
> >There *has* to be either a pfile or spfile. That's where the init
> >parms come from. Instance can't start without it.
>
> Correct. But you can safely delete the pfile after the instance
> started. Some unknown developers of an ISV did that to one of our
> databases once.
> I had to reconstruct the pfile, before the database could be shutdown.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Ah, yes. Never underestimate the treachery of clueless developers and SA's.

Like the SA's who can't get it through their heads that redo01a.log isn't *just a log file* and delete it to free up disk space, or open it with notepad to see what's in it. Or the SA who thinks he can edit an spfile with notepad ... (and thinks that's in his lane to begin with!) Received on Wed Aug 15 2007 - 08:03:35 CDT