- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle SYSDATE show old date
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2006 12:58 AM
тАО01-27-2006 12:58 AM
Re: Oracle SYSDATE show old date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2006 01:03 AM
тАО01-27-2006 01:03 AM
Re: Oracle SYSDATE show old date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2006 04:12 AM
тАО01-27-2006 04:12 AM
Re: Oracle SYSDATE show old date
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2006 03:45 PM
тАО01-27-2006 03:45 PM
Re: Oracle SYSDATE show old date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2006 03:50 PM
тАО01-27-2006 03:50 PM
Re: Oracle SYSDATE show old date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2006 08:09 PM
тАО01-29-2006 08:09 PM
Re: Oracle SYSDATE show old date
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2006 05:29 AM
тАО01-30-2006 05:29 AM
Re: Oracle SYSDATE show old date
I will read up on the Metallink report on this bug 3368245 -- to see if it applys
thank you
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2006 05:30 AM
тАО01-30-2006 05:30 AM
Re: Oracle SYSDATE show old date
I did fail to state this is a LINUX machine
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2006 04:19 AM
тАО02-06-2006 04:19 AM
Re: Oracle SYSDATE show old date
SQL> startup
ORA-00065: initialization of FIXED_DATE failed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2006 04:21 AM
тАО02-06-2006 04:21 AM
Re: Oracle SYSDATE show old date
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