RE: GMT date while server is EST

From: Fedock, John (KAM.RHQ) <John.Fedock_at_us.kline.com>
Date: 2006-01-12 15:59:34
Message-id: 5042FDC675779848A113F70D54F587490E3BB61D@KAMRICEXCLUS.us.kline.com

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