Hello and welcome to the SAP HANA Academy.
The topic of this video tutorial series is SAP HANA Cockpit and in this video we will
show you how install SAP HANA cockpit in an existing SAP HANA database.
This video has been recorded on release SAP HANA 2.0 SPS 03 (April 2018)
and SAP HANA cockpit 2.0 SP 07 from August 2018.
For earlier or later releases, please check the playlist on the SAP HANA Academy.
Hi, I am Denys van Kempen.
One of the new features of SAP HANA cockpit 2.0 Support Package 07 is the option to install
cockpit on an existing SAP HANA system.
Here we see this illustrated in the SAP HANA cockpit installation and update guide.
Previously, we had to install cockpit on a dedicated server (here Server 2) or install
cockpit on the same hardware as the main HANA system but as a separate HANA environment:
cockpit comes with its own embedded SAP HANA express edition database.
Now, we can install cockpit inside main HANA system.
It resides then in a separate tenant database.
If you only have a single SAP HANA system, installing cockpit inside that system may
take away some of the complexity in system management, you will need less resources as
well, however --no such thing as a free lunch-- it will come at a cost.
If the main HANA system is down, you cannot access cockpit either.
So, you cannot really use cockpit to restore the system, for example, in this case.
So for production environments, typically, we will always use a dedicated cockpit system,
particularly when we need to manage a lot of HANA systems.
However, for a single box, for training, some testing, maybe a bit of development, we could
certainly consider installing cockpit as shared database.
Another use case could be to create a distributed system, a multi-host environment, and have
the tenant with cockpit on a separate dedicated host.
That would work as well.
OK — I have downloaded the cockpit installation media, the SAR file, from SAP Downloads, the
SAP ONE Support Portal.
Transferred the file to my HANA system
and extracted the file using SAPCAR.
We have done this many, many times before.
If you are new to this, take a look at the SAP HANA installation playlist, should you need any guidance.
Then to run, I will use the hdblcmgui.sh script.
As before with cockpit installations, we need to call the SAP HANA Lifecycle Management
tool with this script, not directly to set the right environment.
I am using the graphical version only because this will look a bit nicer on screen.
Requires X-Windows installed on the SAP HANA system, typically not the case, and also emulation
software on the Windows client or maybe VNC.
If you do not have this set up, best just to use command line installer.
Works exactly the same way.
OK — Step 1 - Select Activity.
Default is Install New SAP HANA Cockpit System.
I will select Install on SAP HANA Database and then select the system: HA0.
There is only a single system running here on this server, if you have more, make sure
to select the right one.
You can see the instance number, version, etc. here on the right.
Next.
Step 2 - Select Components.
Cockpit requires XS Advanced.
My system did not have the runtime installed, so cockpit will do this for us.
If your HANA system already includes XSA, this box will be ticked already.
Unselecting any of these components does not make much sense.
You need both for a running SAP HANA cockpit environment.
Next.
Step 3a - Enter Additional Hosts Properties.
Here we can add additional hosts to our HANA system to create a distributed or multi-host
system.
I will just enter the password here for the root user, so we can Automatically assign
XS Advanced Runtime roles to the hosts with database roles.
For a single-host system, this may not even be required as we started Lifecycle Management
as root.
OK.
Step 3b - Define Upgrade Properties.
Here we need to enter the password for the System Database user, typically SYSTEM and
also for the default tenant.
Next.
Step 3c - Define XS Advanced Runtime properties.
If you have installed the XS Advanced runtime before this screen will look familiar to you.
You need to specify the name of the XS Advanced Admin user: XSA_ADMIN, by default.
The password, the org, the space, routing mode and domain name.
This is generic XSA runtime installation material, nothing to do with cockpit per se.
So I will proceed with the next screen but again, if you are new to this, there is a
dedicated tutorial video about installing XSA runtime where we discuss this in a bit more detail.
Step 3d - Specify Cockpit Properties.
This is completely new.
You need to specify the XSA space for cockpit and the name of the tenant database.
I will leave this with the default values.
If you are feeling inspired you can change them to some custom value.
Next, Step 3e - Define Cockpit Tenant Authorization Properties.
When you create a tenant database, you always need to specify the SYSTEM user password.
Same thing here.
Step 4 - Review and Confirm.
Here we have all our parameters.
The software that will be installed and the different XSA components: cockpit, the runtime tools, SAPUI5, etc.
We have already discussed this in some detail in the cockpit installation video tutorial.
Note the location of the log files as well; should anything go wrong,
this is where to start the investigation.
Click install.
On my system, this took about 48 minutes.
So we will fast forward through this a bit.
First, the system is stopped, the software installed, and the system is started again.
Takes a minute or two.
Then another two minutes in the Configuring software… phase to finalize the installation
of the XSA runtime and two more minutes to start the XSA environment up.
Then we get to the initial content loading phase, 42 steps, about 10 minutes.
Then we need a couple more minutes to create the tenant database for cockpit, enable it
for XSA, creating the space and finally (and this will take the longest)
installing all the applications in this space, all the microservices and web applications used by cockpit.
This takes about 30 minutes.
Then, if all went well, we get to see this screen, with green check marks for all the
different execution steps and a View Log button for more information.
There is also a link to launch the SAP HANA cockpit and the cockpit manager straight away
from the installer to perform the initial setup — and this we will do in the next video.
OK - That’s it, so much for installing SAP HANA cockpit on a shared database.
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 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 this video.
Thank you for watching.