Oracle SYSDATE show old date

[Yogeeraj_1]

hi steve,

The FIXED_DATE parameter should unset in INIT.ORA.

Just to test if this is the real cause, you can dynamically unset it using the command ALTER SYSTEM SET FIXED_DATE = NONE;

Once this command has been issued, SYSDATE will return to normal functionality.


good luck

kind regards
yogeeraj

[Yogeeraj_1]

hi steve,

The FIXED_DATE parameter should be unset in INIT.ORA.

Just to test if this is the real cause, you can dynamically unset it using the command ALTER SYSTEM SET FIXED_DATE = NONE;

Once this command has been issued, SYSDATE will return to normal functionality.


good luck

kind regards
yogeeraj

[Stephen Badgett]

Hi all ...

Eric Antunes ...

[oracle@prolinux oracle]$ date; cat /etc/TIMEZONE
Fri Jan 27 08:55:42 PST 2006
cat: /etc/TIMEZONE: No such file or directory


Yogeeraj ...

SQL> select to_char(sysdate,'DD-MON-YY HH24:MI:SS') from user_objects
where rownum <2; 2

TO_CHAR(SYSDATE,'D
------------------
01-JAN-03 10:00:00


Hein. ...

So as I asked earlier, that clock does not tick... iti is stuck at 10:00 1/1/3 right?

YES - as seen above

I also looked in my init.ora file and found no FIXED_DATE --


Yogeeraj ... (this did it )

SQL> ALTER SYSTEM SET FIXED_DATE = NONE;

SQL> select to_char(sysdate,'DD-MON-YY HH24:MI:SS') from user_objects where rownum <2;

TO_CHAR(SYSDATE,'D
------------------
27-JAN-06 09:08:31


Now will it stay that way after a reboot of oracle?

[Yogeeraj_1]

hi steve,

Only if your init.ora does not contain the line (e.g.):

FIXED_DATE='01-JAN-03'

if you have it, you will have to remove it from there. This will ensure that sysdate will resume "normal" behaviour.

kind regards
yogeeraj

[Yogeeraj_1]

hi again,

if you are using SPFILE, you should be cautious NOT to set FIXED_DATE=NONE

Metalink reports a bug -- see note 3368245.8
Subject: Bug 3368245 - Setting FIXED_DATE to NONE with SPFILE causes ORA-65 on STARTUP

Again, i recommend that you remove it so that your SYSDATE returns to normal functionality.

hope this helps too!

kind regards
yogeeraj

[Eric Antunes]

Hi Steve,

You really need to set a timezone since it is not set in your system.

First check /usr/lib/tztab and find your timezone for your geagraphic area. If you can't find a timezone for you, you can use GMT. Then, execute:

#/sbin/set_parms

Best Regards,

Eric Antunes

[Stephen Badgett]

Yogeeraj ...

I will read up on the Metallink report on this bug 3368245 -- to see if it applys

thank you
Steve

[Stephen Badgett]

Eric Antunes

I did fail to state this is a LINUX machine

Steve

[Stephen Badgett]

help

SQL> startup
ORA-00065: initialization of FIXED_DATE failed

[Stephen Badgett]

You warned me

We rebooted the machine and thios morning I noticed that it did not start so I tryied to start it up and got that error message. to be more clear.

Steve