- Queries run through SQL*Net
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????
HELP, we can help us with this issue ?!
Received on Thu Jul 11 2002 - 08:48:15 CDT