Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I have 2 listeners for the 2 different Time Zones in a non-GRID/non-RAC environment?

3140875Sep 6 2017 — edited Sep 11 2017

I have the following machine:

OS: Red Hat Enterprise Linux Server release 7.3 (Maipo)

DB: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Current OS TZ is EDT (-04:00)

Database has data type DATE.

Application uses SYSDATE function to insert data into DATE columns.

Can I have 2 listeners for the 2 different Time Zones in a non-GRID/non-RAC environment?

Will SYSDATE function return different time for the connection made via listeners with a different TZ settings?

Are there any known issues and/or something to watch out for?

This post has been answered by 3140875 on Sep 8 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2017

Added on Sep 6 2017

#general-database-discussions

3 comments

1,550 views