Symptom
You are running a SAP HANA scale out landscape and see different time zone settings for the sidadm user.
Other Terms
SAP HANA, scale out, time zone, ntp, Linux, SLES
Reason and Prerequisites
Your SAP HANA scale out landscape shows different time zone settings
for at least one server, i.e. the master node shows time zone UTC and
all other nodes show time zone CET. This may be caused by an
inconsistency in the installation process and should be corrected.
Solution
To change the time zone settings of the sidadm user: go to the home
directory /usr/sap/<SID>/home of the user and delete the entry for
the time zone setting in the following two files:
.sapenv.csh: setenv TZ <time zone>
.sapenv.sh: export TZ=<time zone>
Make sure this is done for all HANA nodes.
Additionally, for a scale out installation a ntp server should be configured. You may either use your corporate ntp or ask your hardware partner to setup a ntp server for you, i.e. on the management node of the appliance.
If you see different time settings for the sidadm and the root user check /etc/adjtime. If you see quite big values check your ntp and do a resync.
If the time setting is done login as sidadm user again and restart the database.
.sapenv.csh: setenv TZ <time zone>
.sapenv.sh: export TZ=<time zone>
Make sure this is done for all HANA nodes.
Additionally, for a scale out installation a ntp server should be configured. You may either use your corporate ntp or ask your hardware partner to setup a ntp server for you, i.e. on the management node of the appliance.
If you see different time settings for the sidadm and the root user check /etc/adjtime. If you see quite big values check your ntp and do a resync.
If the time setting is done login as sidadm user again and restart the database.
Header Data
| Released On | 07.03.2013 08:31:16 |
| Release Status | Released for Customer |
| Component | HAN-DB SAP HANA Database |
| Priority | Recommendations / Additional Info |
| Category | Installation information |
No comments:
Post a Comment