Re: changing server time which affects oracle time

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 14 Oct 2004 06:23:10 -0700
Message-ID: <6d8b7216.0410140523.4a9c2446@posting.google.com>

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.

SQL> alter system set fixed_date=none;

System altered.

SQL> startup force;
ORA-00065: initialization of FIXED_DATE failed SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

C:\oracle92\database>textpad spfiletest.ora

C:\oracle92\database>rm spfiletest.ora

C:\oracle92\database>sp

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Oct 14 09:18:55 2004

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> Regards,

Steve Received on Thu Oct 14 2004 - 08:23:10 CDT