- 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-25-2006 12:49 AM
тАО01-25-2006 12:49 AM
Re: Oracle SYSDATE show old date
I would try the following.
Get current system timestamp with time zone information
SQL> select SYSTIMESTAMP from dual;
Check the database time zone
SQL> select DBTIMEZONE from dual;
ALTER database SET TIME_ZONE = '
Switch back DBTIMEZONE to hh:mm format
SQL> ALTER database SET TIME_ZONE = '
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-25-2006 01:51 AM
тАО01-25-2006 01:51 AM
Re: Oracle SYSDATE show old date
The Oracle sysdate (and time) is
derived from the OS.
So if you are on unix , runing
the date command and set a new
date would effect that.
Also as was mentioned earlier, the TZ variable is important as it dictates
the timezone. To set it permanently
you need to update a unix file, I believe
it is /etc/timezone(s) , need to check.
Then you can synchronize your time
with the ntpd protocol to some
central server.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-25-2006 03:58 AM
тАО01-25-2006 03:58 AM
Re: Oracle SYSDATE show old date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-25-2006 06:55 AM
тАО01-25-2006 06:55 AM
Re: Oracle SYSDATE show old date
In case it is the OS which I think is, make sure of the consequences and the impact of resetting clock. Resetting the clock might make your backup obsolete. So becarefull.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 07:15 AM
тАО01-26-2006 07:15 AM
Re: Oracle SYSDATE show old date
yogeeraj and Simon ...
SQL> select sysdate from dual;
SYSDATE
--------------------
01-jan-2003 10:00:00
SQL> select SYSTIMESTAMP from dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
26-JAN-06 08.54.56.474850 AM -08:00
SQL> select DBTIMEZONE from dual;
DBTIME
------
-08:00
This look right
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 08:14 AM
тАО01-26-2006 08:14 AM
Re: Oracle SYSDATE show old date
select to_char(sysdate,'DD-MON-YY HH24:MI:SS') from dual;
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 26 12:17:15 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
SQL>
SQL> select to_char(sysdate,'DD-MON-YY HH24:MI:SS') from dual;
TO_CHAR(SYSDATE,'D
------------------
01-JAN-03 10:00:00
This seems like what you said so, how do I start listener with the correct TZ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 11:23 AM
тАО01-26-2006 11:23 AM
Re: Oracle SYSDATE show old date
On Unix you can use the OS "TZ" environment variable to alter the time that the OS will pass on to Oracle.
You set the TZ appropriate for the database and then start the listener. It is also a good idea to set the correct TZ in the Unix environment of the user who re-starts the database
TIMEZONE (TZ) is sourced during login from the user├в s profile (Eg:- for a Posix shell, when /etc/profile is sourced during login, /etc/TIMEZONE is sourced if avaailable).
/etc/TIMEZONE is intended to contain the default TZ variable.
The /etc/default/tz file is used to help define the default TZ value when it is not defined.
When you logon as oracle echo $TZ to see what it has beens set to. Then set the TZ to the correct timezone and export the variable and resrat the listener.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 09:18 PM
тАО01-26-2006 09:18 PM
Re: Oracle SYSDATE show old date
Login as the unix database owner user (usually oracle) and give us the following outputs:
$date; cat /etc/TIMEZONE
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 10:46 PM
тАО01-26-2006 10:46 PM
Re: Oracle SYSDATE show old date
this is really very strange!
can you also post the output of:
select to_char(sysdate,'DD-MON-YY HH24:MI:SS') from user_objects
where rownum <2;
thanks
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2006 11:43 PM
тАО01-26-2006 11:43 PM
Re: Oracle SYSDATE show old date
So as I asked earlier, that clock does not tick... iti is stuck at 10:00 1/1/3 right?
Well then John Wimmers suggestion may point to the problem. Someone has set "fixed_date" to that string.
Maybe they thought it was to give it a fixed format, not a fixed values.
Anyway, set to blank (alter system) and/or restat having made sure it is not in the INIT files.
fwiw,
Hein.