Re: spfile vs pfile in 9i

Niall Litchfield wrote:
>
> In the case of the spfile, the fact that you can merrily stuff it up
> and then be unable to start the instance (because you can no longer
> edit the spfile) or correct the problem without restoring from backup
> is a rather large defect.
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
>

Morning Niall - long time no hear, you been working hard then ?

If you do manage to stuff up the spfile, in a manner demonstrated by Howards, do this :

Create an initSID.ora file with these contents :

SPFILE = whatever
SHARED_POOL_SIZE = 90M Then startup and specify PFILE=initSID.ora.

Works like a charm, and then you can create spfile from pfile to 'fix' the spfile properly.

Cheers,
Norm.

-- 

Remove DELETETHIS (and the following dot) from my email address to reply 
directly.