How To setup TNS listener to Show More Than one Timezone
(Doc ID 399448.1)
Last updated on JANUARY 17, 2025
Applies to:
Oracle Net Services - Version 9.2.0.8 to 12.2.0.1 [Release 9.2 to 12.2]Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
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 |