OraFAQ Forum: Server Administration » Sysdate gives different timezone connecting through listener

Home » RDBMS Server » Server Administration » Sysdate gives different timezone connecting through listener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sysdate gives different timezone connecting through listener [message #135389]

Wed, 31 August 2005 07:23

arnargestsson
Messages: 1
Registered: August 2005

Junior Member

We have newly installed Oracle 10g R1 on a HPUX 11i Itanium machine. If connected internally the sysdate gives time with correct timezone(GMT0), same as in TZ environment, but if connected through the listener sysdate comes with GMT-4. And ENVS='TZ=GMT0' has been put in listener.ora but without a luck.

Any thoughts.

Cheers Arnar

Report message to a moderator

Re: Sysdate gives different timezone connecting through listener [message #135925 is a reply to message #135389]

Sun, 04 September 2005 22:38

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

Maybe you need to change the TZ environments and then restart the listener, because it's listener spawn the SERVER process.

And you should query something from metalink.

Report message to a moderator

Re: Sysdate gives different timezone connecting through listener [message #171264 is a reply to message #135925]

Tue, 09 May 2006 04:11

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Just for later reference - look at the ENVS='TZ=...' part below:

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
     )
   )
 )
 SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
      (ENVS='TZ=EST')
      (SID_NAME = mydbname)
    )
  )

For RAC, you may also need to do the following:

srvctl setenv database -d mydbname -t TZ=EST
srvctl stop database -d mydbname
srvctl start database -d mydbname

Report message to a moderator

Previous Topic:	Length of a field
Next Topic:	Install 10g alongside 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:29:40 CDT 2024