Solution : https://service.sap.com/sap/support/notes/1571062 (SAP Service marketplace login required)
Summary :
This SAP Note explains the process for setting the timezone configuration for Oracle Real Application Clusters (RAC) databases, specifically for Oracle Release 11.2 on UNIX/Linux. It highlights the necessity to manage the TZ environment variable via srvctl to run multiple databases in various timezones on a single server. Key steps include using the srvctl command to set the TZ for each database and employing SQL queries to verify the timezone settings. The note provides instructions, example commands, and links to Oracle documentation for further reference on timezone region names and srvctl details.
Key words :
oracle® database globalization support guide 11g release 2, tz=europe/berlinos> srvctl setenv database -, tz=europe/moscowos> srvctl setenv database -, run multiple databases / sap systems, oracle® real application clusters administration, timezoneos> srvctl setenv database -, cccos> srvctl setenv database -, oracle real application clusters, databaseos> srvctl start database -, 'yyyy-mm-dd hh24
Related Notes :
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 369370 | SAP Oracle database on UNIX: changing time zone |