| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: GMT date while server is EST - working almost ...
Mark - and others that replied ...
I was doubting what I saw, so I just stopped the database, verified the TZ setting and \ rebooted. Now the job times are GMT as well. This is telling me that the database \ startup on the weekends is being done incorrectly.
Thanks,
John
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]
Sent: Wednesday, January 11, 2006 5:21 PM
To: Fedock, John (KAM.RHQ); oracle-l_at_freelists.org
Subject: RE: GMT date while server is EST - working almost ...
Database version? Platform? etc....
I think the way it works is, you define in the listener's environment, and since the \ listener starts the Oracle server process when you connect via listener, it sees the \ modified environment, and that's how the correct time is set. However, server processes \ for jobs are not spawned by the listener. Also, if you do a connect w/o the listener, \ login to database server, set ORACLE_SID and then connect with: sqlplus user/password I'll \ bet that doesn't see the modified timezone either.
So, I guess I've explained why (I think) it doesn't work.....but I don't have a solution \ for you...sorry.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and those who \ don't."
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On \
Behalf Of Fedock, John (KAM.RHQ)
Sent: Wednesday, January 11, 2006 5:05 PM
To: oracle-l_at_freelists.org
Subject: GMT date while server is EST - working almost ...
My HP-UX server is set at EST time. There are several databases running there. I want \
one (9.2.x) to run at GMT time. I followed the notes on MetaLink, created a new listener, \ set the TZ variable, etc, and now SYSDATE does resolve out to GMT time. However, internal \ database time (like jobs running in DBA_JOBS), are still at EST. I was hoping these would \run at GMT time as well.
Is this the way it should be? I was hoping that the changes I list above would negate \ this. Any advice?
Thanks.
John Fedock
K Line America, Inc.
john.fedock 'at' us.kline.com
Received on Thu Jan 12 2006 - 15:59:34 CST
 |
 |