Oracle systimestamp different for different Linux users
OK I have a couple of customer boxes doing this:
As linux user 'oracle',
log on to Oracle as system;
select timestamp from dual;
retruns correct time.
As linux user 'root' (or user 'isaecs' which is my app user)
log on to Oracle as system;
select timestamp from dual;
returns timestamp one hour earlier than correct time!
The only difference is the OS user. I've compared the environments and nothing big is different. All users have 'TZ=America/New York' set. Termcap is different, PATH is a little different, but Ive changed these without affecting the oracle timestamp.
What could be different about these user ids????
John f
|