So we've got ourselves a brand spanking new Exadata (Cloud AT Customer) .
However, everything is setup as UTC (which is mainly more of a problem for
our customers/clients than it is for the DBAs though it does make things
confusing.
I've been reading through documents all day about changing the timezone for
the VM nodes and the databases.
However, I notice that the "GRID" and "ORACLE" OS users do an:
"export TZ=UTC"
Which means I need to modify several files on all the nodes to change it
from the OS.
I'm wondering if it make more sense to create LOGON trigger to set every
interactive session to the proper timezone INSTEAD of modifying these files:
oracle:
.bash_profile
root:
.bash_profile
grid: .
bash_profile
s_crsconfig_xcp(nodename)_env.txt (on all nodes) (owned by root)
Has anyone changed their Exadata timezone from UTC to something else, and
which method did you prefer?
I'm not changing timezone on the cell nodes (or whatever they're called -
just on the DB machine nodes - compute nodes or whatever they're called in
Exadata)
