My Oracle Support Banner

How To setup TNS listener to Show More Than one Timezone (Doc ID 399448.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Net Services - Version 9.2.0.8 to 12.2.0.1 [Release 9.2 to 12.2]
Information in this document applies to any platform.

Goal

How to setup the TNS listener to show more than one time zone.

This is only possible for Unix platforms.  Windows lacks the functionally of setting a different timezone for different processes. Due to the architecture of Oracle on Windows, where threads are used instead of processes, there is no possibility of passing environment variables when spawning a thread.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.