Re: Managing multiple timezone

From: Vincent Smith <vsmith_at_telstra.com.au>
Date: Mon, 31 May 1999 03:32:19 GMT
Message-ID: <375202b8.14129987@news.cdn.telstra.com.au>

Use a different Sql*net listener on a different port. When starting it , set the TZ (or equivalent) to the Time Zone desired. If the two instances are on same machine & need to inter-communicate, set automatic-ipc to NO in the sqlnet.ora files.

rgds Vin.
PS. If all users are going to use same instance, use seperate sql*net listeners , and a modified tnsnames.ora entry in each TZ.

On Thu, 27 May 1999 13:44:18 GMT, "Michel Gauthier" <qgmi1_at_clic.net> wrote:

>Hi all,
>
>I will have to implement a new instance on a already used server (a HP3000
>running MPE 5.5). My Oracle version is 7.3.2.3.1.
>
>We already have a client/server application (using Oracle) running on that
>server (clients are WinNT). The new instance I will to set will be accessed
>thru that same application... implemented for users living in another
>TimeZone.
>
>Is there a way to set a kind of timezone offset that would affect SYSDATE
>behavior? Does SQL*Net have such a parameter?
>
>TIA
>
>Michel Gauthier
>qgmi1_at_clic.net
>Donohue Inc.
>
>
Received on Sun May 30 1999 - 22:32:19 CDT