- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Different TimeZone through listener.ora on HPUX
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
тАО11-06-2004 07:39 PM
тАО11-06-2004 07:39 PM
Different TimeZone through listener.ora on HPUX
If the query is run through SQL*Net, Oracle will return the time zone based on the setting of the UNIX environment variable "TZ" for the user who started the listener.
-- Queries run through SQL*Plus (who uses the listener.ora)
If the query is run through SQL*Plus, Oracle will return the time zone based on the setting of the UNIX environment variable "TZ" minus 6 hours !!!
The problem is solvable to restart the listerner. Only the strang thing is that the first one who connect to the database has the right server time. But alle the users which connect later have the wrong time????
I have HPUX11i oracle 9.2.0
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2004 10:43 AM
тАО11-07-2004 10:43 AM
Re: Different TimeZone through listener.ora on HPUX
The first thing I would check here is the TZ and other relavent environment variables for allusers involved. A startup script could be trying to set an environment variable incorrectly as well.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2004 07:12 PM
тАО11-07-2004 07:12 PM
Re: Different TimeZone through listener.ora on HPUX
All users are in the same time zone .
But probbly the TZ dont past to the Listener for some resone .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2004 08:09 PM
тАО11-07-2004 08:09 PM
Re: Different TimeZone through listener.ora on HPUX
Please note that:
The TZ environment variable is picked up by the dedicated or shared server. These inherit their environment from whomever starts them.
So, as long as
a) the listener has tz set
b) the person who starts the database has tz set
c) everyone connects via the listener
you'll be OK. direct connections (no listener) will fork and exec their own dedicated servers -- so they will get the TZ of the client.
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2004 01:05 AM
тАО11-08-2004 01:05 AM
Re: Different TimeZone through listener.ora on HPUX
because the listener dosn't get the TZ from the user I added the file /etc/defult/tz whit my timezone and it's work properly .
this is bypass solved the problem .
but still I have to change it when the clock is changing .
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-08-2004 01:07 AM
тАО11-08-2004 01:07 AM
Re: Different TimeZone through listener.ora on HPUX
because the listener dosn't get the TZ from the user I added the file /etc/defult/tz whit my timezone and it's work properly .
this is bypass solved the problem .
but still I have to change it when the clock is changing .
Thanks