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

Hi

I am trying to get 2 listeners working on the same machine, each using a different timezone. I know this can be done on Linux/Unix boxes but I can't seem to get it to stick on a Win2003 machine. I want my original listener (port 1521) to use EST time and my other listener
(port 1525) to use PST.

If I set my windows timezone to PST and start my second listener, it gives me the right time (in PST) when connecting from my client machine. When I go to switch the timezone back to EST on my server, the listener seems to pick up the new timezone and when I query again
(in the same sql session), I get the time on EST again.

Is this a limitation of Oracle Server on Windows or is there some trick?

Thanks,
Dave Received on Wed Mar 29 2006 - 12:41:23 CST