TIP
💡 Learn more : Use Azure to host and run SAP workload scenarios (opens new window).
# SAP on Azure in Plain English Part 2 of 2
In this series, I take a look at SAP coming from someone who hasn't used it before.
In previous poast we took a look at SAP on Azure and learned a little about the history and what offerings were available. We set up a VM using the SAP HANA express edition (Server + Applications) image and left off with a deployed SAP VM. Now, we'll take a look at connecting to the instance and configuring it.
# Connecting to our VM
Once Azure has created the VM and configured the storage and virtual network you can connect to the server via RDP or SSH.
In my case, I'm using SSH.
Below shows how I configured SAP Hana, you can follow along with what I did if you want.
Pro Tip The default password is HXEHana1 if you have any trouble logging in via the su - hxeadm login.
SSH into the Linux VM with sh hxehost@<the ip provided from azure portal>
mbcrump@sapexpressed:~> ssh hxehost@<the ip provided from azure portal>
The authenticity of host 'x (x)' can't be established.
ECDSA key fingerprint is SHA256:XxQpKdpxiwzEo27E+dkFc7HPE4a4iP00sYNqprWzDmA.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'x' (ECDSA) to the list of known hosts.
Password:
SUSE Linux Enterprise Server 12 SP3 x86_64 (64-bit)
As "root" (sudo or sudo -i) use the:
- zypper command for package management
- yast command for configuration management
If you are using extensions consider to enable the auto-update feature
of the extension agent and restarting the service. As root execute:
- sed -i s/AutoUpdate.Enabled=n/AutoUpdate.Enabled=y/ /etc/waagent.conf
- rcwaagent restart
Management and Config: https://www.suse.com/suse-in-the-cloud-basics
Documentation: https://www.suse.com/documentation/sles-12/
Forum: https://forums.suse.com/forumdisplay.php?93-SUSE-Public-Cloud
Have a lot of fun...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Now run the sudo -i command to gain Sys Admin access with the password you entered earlier.
xehost@SAPTestMC:~> sudo -i
We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:
#1) Respect the privacy of others.
#2) Think before you type.
#3) With great power comes great responsibility.
[sudo] password for hxehost:
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
Run su - hxeadm to log into the express edition and use HXEHana1 for the password and configure as shown below.
SAPTestMC:~ # su - hxeadm
Password:
############################################################################################################################################################
# Welcome to SAP HANA, express edition 2.0. #
# #
# The system must be configured before use. #
############################################################################################################################################################
Password must be at least 8 characters in length. It must contain at least
1 uppercase letter, 1 lowercase letter, and 1 number. Special characters
are allowed, except \ (backslash), ' (single quote), " (double quotes),
` (backtick), and $ (dollar sign).
New HANA database master password:
Confirm "HANA database master" password:
Do you need to use proxy server to access the internet? (Y/N): n
XSA configuration may take a while. Do you wish to wait for XSA configuration to finish?
If you enter no, XSA will be configured in background after server completes.
Wait for XSA configuration to finish (Y/N) [Y] : y
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
You'll now see the Summary.
############################################################################################################################################################
# Summary before execution #
############################################################################################################################################################
HANA, express edition
Host name : SAPTestMC
Domain name : x.dx.internal.cloudapp.net
Master password : ********
Log file : /var/tmp/hdb_init_config_2018-10-19_04.00.52.log
Wait for XSA configuration to finish : Yes
Proxy host : N/A
Proxy port : N/A
Hosts with no proxy : N/A
Proceed with configuration? (Y/N) : y
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Press y to proceed and you'll see a log similar to the following.
Please wait while HANA server starts. This may take a while...
tartService
OK
OK
Starting instance using: /usr/sap/HXE/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 90 -function StartWait 2700 2
21.10.2018 00:56:08
Start
OK
21.10.2018 00:56:18
StartWait
OK
Change SYSTEM user password on SystemDB database...
Change SYSTEM user password on HXE database...
############################################################################################################################################################
# Security keys change summary #
############################################################################################################################################################
HANA system ID : HXE
HANA instance number : 90
system password : ********
root key backup password : ********
root key backup directory : /usr/sap/HXE/home/root_key.bck
#########################################################
# Changing SSFS Master keys #
#########################################################
Re-encrypt master key of the instance SSFS...
Record Statistics
=============================================
Encrypted and readable : 8
Encrypted and not readable : 0
Plaintext : 7
Removed by compacting : 0
Add new entry to global.ini file...
Re-encrypt the system PKI SSFS with new key...
Record Statistics
=============================================
Encrypted and readable : 3
Encrypted and not readable : 0
Plaintext : 0
Removed by compacting : 0
#################################################################################
# Change root key for SystemDB database #
#################################################################################
Root key backup password set for SYSTEMDB!
Root key generated for data volume of SYSTEMDB!
Root key generated for redo log of SYSTEMDB!
Root key generated for internal application of SYSTEMDB!
Root key for SYSTEMDB is backed up to /usr/sap/HXE/home/root_key.bck/SYSTEMDB.rkb!
Root key activated for data volume of SYSTEMDB!
Root key activated for redo log of SYSTEMDB!
Root key activated for internal application of SYSTEMDB!
#####################################################################################
# Change root key for tenant database HXE #
#####################################################################################
Root key backup password set for HXE!
Root key generated for data volume of HXE!
Root key generated for redo log of HXE!
Root key generated for internal application of HXE!
Root key for HXE is backed up to /usr/sap/HXE/home/root_key.bck/HXE.rkb!
Root key activated for data volume of HXE!
Root key activated for redo log of HXE!
Root key activated for internal application of HXE!
Collecting garbage...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...
Collect garbage on "hdbdiserver"...
Shrink resource container memory on "hdbdiserver"...
Collect garbage on "hdbwebdispatcher"...
Shrink resource container memory on "hdbwebdispatcher"...
Total in use HANA processes heap memory (MB)
============================================
Before collection : 2726
After collection : 2457
Free and used memory in the system
==================================
Before collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 18G 8.7G 68M 331M 7.7G
-/+ buffers/cache: 10G 16G
Swap: 4.0G 0B 4.0G
After collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 16G 11G 68M 332M 7.7G
-/+ buffers/cache: 8.2G 19G
Swap: 4.0G 0B 4.0G
Please wait while XSA starts. This may take a while...OK
Change XSA_ADMIN user password on SystemDB database...
Change XSA_DEV user password on SystemDB database...
Collecting garbage...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...
Collect garbage on "hdbdiserver"...
Shrink resource container memory on "hdbdiserver"...
Collect garbage on "hdbwebdispatcher"...
Shrink resource container memory on "hdbwebdispatcher"...
Total in use HANA processes heap memory (MB)
============================================
Before collection : 2482
After collection : 2494
Free and used memory in the system
==================================
Before collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 16G 11G 68M 334M 7.8G
-/+ buffers/cache: 8.2G 19G
Swap: 4.0G 0B 4.0G
After collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 16G 11G 68M 336M 7.9G
-/+ buffers/cache: 8.1G 19G
Swap: 4.0G 0B 4.0G
Change telemetry technical user (TEL_ADMIN) password on SystemDB database...
===============================================================================
Change telemetry technical user password on "SystemDB" database
===============================================================================
Password must be at least 8 characters in length. It must contain at least
1 uppercase letter, 1 lowercase letter, and 1 number. Special characters
are allowed, except \ (backslash), ' (single quote), " (double quotes),
` (backtick), and $ (dollar sign).
Login to XSA services...
Check/Wait for Cockpit app to start...
Waiting for apps: cockpit-persistence-svc, cockpit-hdb-svc, cockpit-xsa-svc, cockpit-collection-svc, cockpit-telemetry-svc, cockpit-adminui-svc, cockpit-admin-web-app
cockpit-collection-svc: ready
Waiting for apps: cockpit-persistence-svc, cockpit-hdb-svc, cockpit-xsa-svc, cockpit-telemetry-svc, cockpit-adminui-svc, cockpit-admin-web-app.......................
cockpit-xsa-svc: ready
Waiting for apps: cockpit-persistence-svc, cockpit-hdb-svc, cockpit-telemetry-svc, cockpit-adminui-svc, cockpit-admin-web-app.....................
cockpit-adminui-svc: ready
Waiting for apps: cockpit-persistence-svc, cockpit-hdb-svc, cockpit-telemetry-svc, cockpit-admin-web-app.................
cockpit-admin-web-app: ready
OK
Create role collections...
Role collections created.
Get authentication token from UAA...
"HXE" database is registered to Cockpit.
Collecting garbage...
Collect garbage on "hdbnameserver"...
Shrink resource container memory on "hdbnameserver"...
Collect garbage on "hdbindexserver"...
Shrink resource container memory on "hdbindexserver"...
Collect garbage on "hdbcompileserver"...
Shrink resource container memory on "hdbcompileserver"...
Collect garbage on "hdbdiserver"...
Shrink resource container memory on "hdbdiserver"...
Collect garbage on "hdbwebdispatcher"...
Shrink resource container memory on "hdbwebdispatcher"...
Total in use HANA processes heap memory (MB)
============================================
Before collection : 3151
After collection : 2468
Free and used memory in the system
==================================
Before collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 26G 1.1G 68M 507M 13G
-/+ buffers/cache: 12G 14G
Swap: 4.0G 0B 4.0G
After collection
-------------------------------------------------------------------------
total used free shared buffers cached
Mem: 27G 25G 1.6G 68M 507M 13G
-/+ buffers/cache: 12G 15G
Swap: 4.0G 0B 4.0G
*** Congratulations! SAP HANA, express edition 2.0 is configured. ***
See https://www.sap.com/developer/tutorials/hxe-ua-getting-started-vm.html to get started.
hxeadm@saprg:/usr/sap/HXE/HDB90> HDB info
USER PID PPID %CPU VSZ RSS COMMAND
hxeadm 11316 11315 0.0 16616 6300 -bash
hxeadm 25032 11316 0.0 13656 3468 \_ /bin/sh /usr/sap/HXE/HDB90/HDB info
hxeadm 25063 25032 0.0 37296 2992 \_ ps fx -U hxeadm -o user:8,pid:8,ppid:8,pcp
hxeadm 6937 1 0.0 21732 2920 sapstart pf=/usr/sap/HXE/SYS/profile/HXE_HDB90_hxe
hxeadm 6975 6937 0.0 211916 57196 \_ /usr/sap/HXE/HDB90/hxehost/trace/hdb.sapHXE_HD
hxeadm 6994 6975 18.2 3760444 3179184 \_ hdbnameserver
hxeadm 7150 6975 0.9 1385044 363288 \_ hdbcompileserver
hxeadm 7171 6975 6.4 3429060 2352128 \_ hdbindexserver -port 39003
hxeadm 7380 6975 0.6 1356504 333676 \_ hdbdiserver
hxeadm 7382 6975 0.6 1593184 549284 \_ hdbwebdispatcher
hxeadm 7384 6975 4.1 788348 362572 \_ /hana/shared/HXE/xs/bin/../sapjvm_8/bin/ja
hxeadm 9619 7384 0.4 1174860 272520 | \_ /hana/shared/HXE/xs/router/webdispatch
hxeadm 7386 6975 15.7 781300 302356 \_ /hana/shared/HXE/xs/bin/../sapjvm_8/bin/ja
hxeadm 9900 7386 0.6 930264 197944 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 10164 7386 1.5 703292 284292 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 10165 7386 0.5 799672 143036 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 10184 7386 2.0 732348 322612 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 10339 7386 0.0 1299964 53368 | \_ node index.js
hxeadm 10707 7386 0.0 1306104 63532 | \_ node application.js
hxeadm 10978 7386 0.9 1422236 440296 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 11250 7386 0.0 1312192 56980 | \_ node node_modules/@sap/approuter/appro
hxeadm 11407 7386 0.0 1311956 55900 | \_ node node_modules/approuter/approuter.
hxeadm 11756 7386 0.0 13400 3080 | \_ /bin/sh ./startup.sh
hxeadm 12803 11756 0.0 1326508 63864 | | \_ sinopia
hxeadm 12108 7386 0.0 1280508 39376 | \_ node start.js
hxeadm 12221 7386 1.8 1238612 381144 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 12935 7386 0.0 1280532 46124 | \_ node start.js
hxeadm 13102 7386 0.0 1308644 60024 | \_ node node_modules/@sap/approuter/appro
hxeadm 14494 7386 0.1 1334952 72836 | \_ node node_modules/@sap/approuter/appro
hxeadm 14672 7386 1.3 1485488 442512 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 14991 7386 0.1 1325884 71616 | \_ node application.js
hxeadm 15292 7386 0.0 1319708 55052 | \_ node node_modules/@sap/approuter/appro
hxeadm 15815 7386 0.5 787236 127164 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 16079 7386 0.0 1280020 44124 | \_ node server.js
hxeadm 16836 7386 3.9 736540 304172 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 16974 7386 3.0 1742528 637948 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 17607 7386 0.1 1303440 56208 | \_ node application.js
hxeadm 17773 7386 0.1 1303368 55112 | \_ node application.js
hxeadm 17868 7386 0.2 1337404 73636 | \_ node --harmony server.js
hxeadm 18023 7386 0.1 1309320 62820 | \_ node --harmony application.js
hxeadm 18131 7386 0.0 1287276 52956 | \_ node start.js
hxeadm 18353 7386 5.4 1285856 498360 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 18487 7386 1.8 1403840 410568 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 18969 7386 0.1 1318772 53876 | \_ node node_modules/@sap/approuter/appro
hxeadm 19194 7386 2.9 975916 283896 | \_ META-INF/.sap_java_buildpack/sapjvmjdk
hxeadm 22984 7386 6.3 1469408 523404 | \_ META-INF/.sap_java_buildpack/sapjvm/bi
hxeadm 23663 7386 0.9 3849144 119500 | \_ node main.js
hxeadm 7424 6975 3.3 1843108 723612 \_ /hana/shared/HXE/xs/bin/../sapjvm_8/bin/ja
hxeadm 2049 1 0.0 495028 33628 /usr/sap/HXE/HDB90/exe/sapstartsrv pf=/usr/sap/HXE
hxeadm 1840 1 0.0 36760 4568 /usr/lib/systemd/systemd --user
hxeadm 1843 1840 0.0 85944 1552 \_ (sd-pam)
hxeadm@saprg:/usr/sap/HXE/HDB90>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
Once complete open up your browser and go to the Public IP Address with port 8090. You should now see XSEngine is up and running!
# Before I go - A Managed Solution is available
For a completely managed solution, SAP Cloud Platform (CP) on Azure (opens new window) is a platform-as-a-service implementation that is completely managed by SAP but hosted in the Azure cloud. This arrangement still offers Azure integration so that you can connect with Event Hubs, Azure SQL, Cosmos DB, etc. With this approach, applications are deployed via SAP CP Cockpit, which is a marketplace of apps and components.
# Wrap-up
Whether you are looking at how to manage a SAP NetWeaver system in Azure, or you want to migrate to a more flexible, cloud-first, SAP HANA system, you'll find a lot more detailed information, along with case studies, on the SAP for Azure website (opens new window).