We are just in the process of installing Enterprise Manager Cloud Control 12.
The EM agent installation instructions say that Linux client machines should have the TZ environment variable set. We do not currently have TZ set for the oracle userid on any of our Oracle database servers.
We use UTC as the database time zone, but we are in the North American Pacific time zone. Should the TZ environment variable be set to UTC or to Pacific time? The EM installation guide is not clear.
Red Hat Enterprise Linux time information for the target Oracle servers:
# date
Mon Jun 15 11:17:49 PDT 2015
# cat /etc/sysconfig/clock
ZONE="US/Pacific"
UTC=false
ARC=false
Oracle time information for the target Oracle servers:
SQL> SELECT DBTIMEZONE FROM DUAL;
DBTIME
------
-07:00
SQL> SELECT sessiontimezone FROM DUAL;
SESSIONTIMEZONE
---------------
-07:00
SQL> select SYSTIMESTAMP from dual;
SYSTIMESTAMP
-----------------------------------
5-JUN-15 11.18.16.940626 AM -07:00