Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA platform Installation and Update
and in this video, I will show you how to install XS Advanced.
Hi, I am Denys van Kempen.
To install XSA, we are going to use the SAP HANA database lifecycle manager (HDBLCM).
XSA is included with the full download of the SAP HANA platform release, the DVD, say.
We have XSAC_HRTT, the HANA runtime tools
XSAC_SAP_WEB_IDE, that’s the SAP Web IDE for SAP HANA
The XSA client (includes the client for Windows, Linux and macOS.
XSA content, here we find SHINE - SAP HANA Interactive Education, SAPUI5
Services (the job scheduler)
we will look into this in a minute.
The actual XSA runtime for Linux
and we also find the installation files for Gerrit here
This is an optional component and we will address this is a separate video tutorial.
Same for the XS Migration tool.
If we briefly switch to Software Downloads on the SAP One Support Portal,
In case you want to download the latest revision, the latest vesrion, of XSA
Select support packages and patches
Alphabetical index: H for HANA
SAP HANA platform edition
Platform edition 2.0
and here we have all the components.
Demo model is SHINE
Web IDE, SAPUI 5 version 2 and 3
Gerrit.
monitoring, runtime, services, cockpit, and so on.
Just select the component and then you can add the latest version to the download basket.
O.K.
In this video we will cover adding XSA to an existing SAP HANA server.
The ADD COMPONENT scenario for the lifecycle managent tool.
You could also, of course, include XSA, when performing a brand new HANA install.
Let’s briefly take a look on how that would look like
I will be using the graphical installer here.
Typically, the installation will be done in command-line mode, maybe even with a response file,
so we can automate the installation; we will look at that in a minute, as well.
For now, let’s take a look at the different configuration screens.
Let’s make this a bit bigger.
The first screen only shows the detected software components and you can see that we have the
XS advanced runtime here, the actual engine plus a lot of components from the XSA content
directory: GUI for HALM, file processor, tools, monitoring, and so no.
Next
Here we could select to update an existing system.
Here we have T01, HANA 2.0 SPS 02
Next,
In that case, you would select the XSA component.
Next.
Enter the root user name and password.
Login for root may have been disabled on your system for security reasons.
Here you can also add hosts to create a distributed system.
Maybe add a host dedicated to run XSA.
Next
Here we only need to provide credentials and the location for the working path.
Next.
Then we get to the screen where the XSA runtime properties need to be defined.
Here you specify the name for the XSA administrator, defaults to XSA_ADMIN (with password)
and for the organization name and customer space name (orgname and PROD).
Very important also is the routing mode: ports or hostnames.
For production, SAP recommends hostname routing.
For development, test and trials, you probably will have to use port-based routing.
We will discuss this in more detail in our video tutorial about XSA architecture.
You also need to provide the XSA domain name which defaults to the local host.
Note 2245631 provides more information.
The checkbox for Run Applications in Customer Space with Separate OS User is selected by default.
Next.
Because it is select, you need to provide the user ID in the next screen.
For distributed systems, this ID would need to be the same on all hosts.
Next,
Finally, we can select here the components we want to install with the XSA runtime.
GUI for HALM is selected by default, XS Monitoring (this is the XSA Administration app),
portal services, XS services (the job scheduler), SAPUI 5 and cockpit.
You might want to add HANA tools for the Catalog Browser
and the SAP Web IDE for SAP HANA (for example)
Next,
We have our summary screen and Update would perform the activity.
If we return to our activity screen and now select Install New System
Add component XS advanced runtime.
Single host
T02
Accepting all defaults here, leaving the checkbox Runtime roles
'Automatically assign XS Advanced runtime roles to the hosts with database roles' selected.
Data and log area, certificates - this is all generic HANA installation
System administrator
SYSTEM database user - same thing
Then, we get to our XS Advanced runtime properties screen again.
So this will look exactly the same.
I will cancel the graphical installer for now.
We can also add XSA, with the SAP HANA platform lifecycle management tool using the web interface.
Enter the URL in your browser, or access it from the HANA cockpit or HANA studio
(see the tutorial video about lifecycle management)
Install or update additional components.
Add software location - where is your download?
Mine is in the /tmp/hana/media ID - tick the box to look also in subdirectories.
Here we get the detected components overview screen - same as in the Windows version.
Next
Select the component to install or update on system HDB .
Select XS Advanced Runtime
The screens are exactly the same: web, windows, command-line, makes no difference.
Add a host, in case you want to create a distributed multi-host system.
Confirm you want to automatically assign XS runtime roles to the hosts with database roles.
We only have a single host here, so this makes no difference.
Specify authorization properties, the passwords, that is,
for the SYSTEM database user for the system database and the tenant,
plus the password for the operating system administration account (adm).
Then, we get - we have seen this before - the Configure XS Advanced Runtime screen
Add the password for XSA Admin - you can rename if you want.
OS User ID for the SAP and customer space.
Finally, the screen where you can select the XS Advanced Components to be installed.
Here is your overview screen.
Click Update to perform the activity.
That’s the web UI.
Note that you cannot use it to install a completely new system.
But you can certainly use it to add the XSA runtime, or update XSA applications,
to an already running system, no problem.
Now, let’s assume you need to install the XSA runtime to all 20 HANA servers running
in your data center and because of the downtime, it needs to be done at 2 a.m.
Do you want to be up in the middle of the night and updating 20 servers?
Probably not and good for you, because you would probably make some errors at that time
performing repetitive tasks.
For this, we are going to run the hdblcm command with the dump_config_file template parameter.
We already discussed this, in some detail, in the installation automation tutorial video.
Let me just briefly recap that you can run the command with the —help to get information and
then with —help action=update with information about the update parameters.
Here we see the same parameters back again from the installer dialogs, plus some more.
Of course, you can find more information about all of these parameters in the
SAP HANA server installation and update guide.
So, let’s create a configuration file.
Now we need to edit the parameters, defaults will be used when none are specified, except
for the passwords, of course, but for this we will use the password file template
which we can then properly secure.
This time, all I will change is the component_medium parameter, to inform the installer where the
installation media is; the component to install (xs); and the different XS Advanced components
hrtt, monitoring, web ide, services, cockpit - make your selection
Then for the passwords, I have updated the password file
XSA Admin uses the last entry.
Now we can run our command.
Cat the password file and with a pipe pass it to the installer, hdblcm,
using the parameter read_password_from_stdin=xml so it knows what to do with it
Note that I did not specify the SID in the response file.
You can certainly do that but if you need to add XSA to multiple servers you might want
to pass this as a call option on the command line using a script that provides the available SIDs.
Also tell hdblcm where the response file or template file is located and off we go!
Takes a bit of time.
The SAP HANA XS runtime is installed first
Then the HANA server is restarted, so we have a bit of downtime.
Then the xs worker role is added and the XSA processes are started:
hdbxscontroller, hdbxsexec(ution)agent
and hdbxsuaaserver - user authenticaton and authorisation.
Then the spaces are created: SAP and orgname (or whatever you specified)
runtimes are uploaded: Node.js 6 and 4; Tomcat 7 and 8, SAP Java Virtual Machine, HANA JDBC.
Then the infrastructure is setup, all the different services are created.
Here you will need to be patient. This will take some time.
Eventually, we will get the URL for the XS Controller.
You can connect to it with the XS client, we looked at this before.
It will be installed on the server but you can also install one on your own PC or Mac.
Then the different XSA components are installed.
HRTT - HANA runtime tools Monitoring - that’s the XSA Admin app
A number of services for the Web IDE for SAP HANA
XSA services, the job scheduler SAPUI5 and XSA Cockpit
This will take about an hour, or so, all in all.
There is a log file, should any issue occur, in /var/tmp and there is a feedback form.
Let’s check the installation using the xs command line.
First, switch to the adm user: 'xs l' (short for login)
XSA_ADMIN (or whatever you specified for the administration account)
and with the 'xs apps command we should now get a list of running applications.
Now, we did not specify a public URL, so the internal host name is used here: sid-hdb.
So to display any of the applications in a browser, you need to edit the local hosts
file on your computer in this demo setup and assuming all the ports are open in the firewall,
the apps should display.
Here we have the XSA Administration tool for example (from the monitoring component) and
if we log on, and click monitoring, we see all the apps listed and running.
O.K.
That’s it.
Thanks for watching.
You can find more video tutorials on our YouTube channel.
If you would like to be informed about new video tutorials, please subscribe to our channel.
You can connect with us on LinkedIn or follow us on Twitter - as well for updates -
and we also have a page on Facebook and Google+.
If you are watching this video on YouTube, do not hesitate to leave your comments to
the video page and, if you like, give us your vote on his video.
Thank you for watching.