On 14 Oct 2004, stephen.howard_at_us.pwcglobal.com wrote:
> Galen Boyer <galenboyer_at_hotpop.com> wrote in message
> news:<ulleamqou.fsf_at_standardandpoors.com>...
>> >> alter system set fixed_date=none
>> >>
>> >> and then shutdown, on restart I get the error,
>> >>
>> >> ORA-00065: initialization of FIXED_DATE failed
>> >>
>> >> Does anybody know how to fix this?
>> >
>> > Did you try adding scope=both?
>>
>> Yes.
>
> Galen,
>
> Try strings on the spfile to convert it to an init.ora file.
> Take out the fixed_date parm and restart.
I actually already did that. Because I had a previous backup I
just restored and fixed it that way. I was just trying to see if
there was a way so that I didn't experience the error on startup.
Or, more importantly, if after experiencing the error on startup,
how do I fix the issue.
--
Galen Boyer
Received on Thu Oct 14 2004 - 09:22:29 CDT
