Re: Multiple Oracle 9i Listeners on Win2k3 and Timezones...

From: Dave <dpatey_at_gmail.com>
Date: 29 Mar 2006 12:06:32 -0800
Message-ID: <1143662791.992180.57590@t31g2000cwb.googlegroups.com>

Thanks... Well the situation is this.... "Hypothically" I outsouce data for 2 customers on 1 instance. One is in CA and one MA. Each wants to see data in their timezone.

IN *nix system, you can set the timezone variable and start the listener. The listener then keeps that timezone while it runs. You can then open another "session", set the timezone to something different and then start the other listener. Each listener keeps the timezone reference in which it was started.

In a production outsource environment, you would, of course, have a Linus/Unix db server. But for the lowly developer, you take what you can get....:) Received on Wed Mar 29 2006 - 14:06:32 CST