- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DB time zone different than UNIX box time
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
тАО12-30-2007 12:52 AM
тАО12-30-2007 12:52 AM
DB time zone different than UNIX box time
Iam facing a problem with the time zone using HP-UX 11.11 verson of rp7410 server.
The time which UNIX box shows is 2 hours differ than oracle database 10g.
For Example: UNIX:10:30 ->time
Oracle db shows : 08:30 ->time
/etc/TIMEZONE : GMT+3 (RIYADH)
Any help will be appreciated at the earliest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 01:22 AM
тАО12-30-2007 01:22 AM
Re: DB time zone different than UNIX box time
Please check your time environment in both user root and oracle user
echo $TZ
this will show your environment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 01:42 AM
тАО12-30-2007 01:42 AM
Re: DB time zone different than UNIX box time
The output of root user #GMT+3 and oracle user $GMT+3 is the same no difference as it is mentioned in /etc/TIMEZONE.
Once again thanks for your efforts
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 02:21 AM
тАО12-30-2007 02:21 AM
Re: DB time zone different than UNIX box time
After stop the DB server please reset the time from "sam"
then check the time from both user
as well as check your oracle user profile.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 02:45 AM
тАО12-30-2007 02:45 AM
Re: DB time zone different than UNIX box time
Database not restarted again, But the time change by SAM which is in example of UNIX format.
And about /home/oracle/.profile nothing mentioned anything there about TZ.
My Question.
1.Is the time change of SAM effect when i restart the database again or it give me hard time .
2.or do i need to mention the TZ parameter in oralce user profile.
Thanks a lot for your co-operation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 03:24 AM
тАО12-30-2007 03:24 AM
Re: DB time zone different than UNIX box time
If you change the system date DB will automatically change the date. no hard time.
>>2.or do i need to mention the TZ parameter in oralce user profile.
If the oracle user used the same profile, no need to modify it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 03:39 AM
тАО12-30-2007 03:39 AM
Re: DB time zone different than UNIX box time
I already changed the system clock (HP-UX) and the above output of my first posting shows the difference between the hp and oralce database timings.
If it will not effect even though i restart database or changed user profile, what will be the solution for this problem.
Thanks in Advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 03:48 AM
тАО12-30-2007 03:48 AM
Re: DB time zone different than UNIX box time
if you don't want to modify it, then keep this time zone
If you able to shutdown the database as well as restart the server. please do this and i hope your problem will solve.
this may cause, sometimes if you export the time zone different in user environment temoporarily, it hold the current settings.
If not then you need to set time zone from single user mode. But that is different procedure.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2007 04:02 AM
тАО12-30-2007 04:02 AM
Re: DB time zone different than UNIX box time
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1188851
One of the problems is that the TZ variable isn't something like: TZ=SAT-3
>ahsan: I think you have a valid time zone?
Right, it is off by 6 hours and should NOT have GMT in it.