During the last two months I had the opportunity of performing several upgrades to SAP HANA 2.0. The process itself is quite easy but there are some important topics to review before and after the upgrade. I write this post for those of you who plan to upgrade your HANA databases to the latest available. I hope it will server you well!
The work plan is the following one:
The first thing you should do before starting with the technical part is to check both upgrade guide and the SAP Notes related to the version. You can find the upgrade guide in the SAP Help Portal: SAP HANA Server Installation and Update Guide. Here it is a list with the notes I found that can be really useful during the whole process:
This part describes steps to be done for points 2 and 10. For checking the consistency in the database you can follow the steps described in the SAP Note 1977584 – Technical Consistency Checks for SAP HANA Databases. Basically you want to perform the following consistency checks:
Check and adjust the OS parameters described in the SAP Note 2205917 – SAP HANA DB: Recommended OS settings for SLES 12 / SLES for SAP Applications 12. In that note you can find the parameters and requirements for each SLES 12 suppot package. In case your SAP HANA is running on Red Hat you can check the SAP Note SAP HANA DB: Recommended OS settings for RHEL 7. If you are running on a lower SO version consider upgrading it to one of the versions described in those SAP Notes.
About the SAP Notes related to HANA virtualization, check the SAP Support portal for the virtualization solution you are currently use on your SAP HANA systems. Please keep in mind that depending of the version you are using you will need to use different SAP Notes. Just saying this because for VMware there are SAP Notes related to version 5.5, 6, 6.5, etc…
The SAP Notes 1948334 – SAP HANA Database Update Paths for SAP HANA Maintenance Revisions describes the base version you need in order to upgrade to SAP HANA 2.0:
Basically you want to upgrade to the latest SP and Rev available for SAP HANA 1.0 and from there upgrade to SAP HANA 2.0 SP3. Please remember to update previously all the components running on your SAP HANA 1.0 database.
Since a couple of years ago SAP HANA support multi-tenant container as a database mode. This means that you can have several tenant databases running in the same SAP HANA database. Instead of having an schema for each SAP system using the database you will have a standalone tenant database. The problem is that SAP HANA 2.0 only works with MDC mode so if you are still running on SDC you need to convert the database to MDC.
Check and follow the steps described in the SAP Note 2372809 – Mandatory Preparation Steps for Upgrading a SAP HANA 1 to SAP HANA 2 System. For converting your HANA database from SDC to MDC use the script convertMDC.py as described in the SAP Note 2101244 – FAQ: SAP HANA Multitenant Database Containers (MDC).
Not much to explain here. Just perform a database backup using your backup tool for SYSTEMDB and all the tenants running on the database server. I will recommend also performing a snapshot or clone in case you are running HANA on a virtual machine. The more the backups the better.
Also backup the configuration files of the SAP HANA database just in case. The SAP Note 1642148 – FAQ: SAP HANA Database Backup & Recovery describes how to backup the configuration files.
The upgrade process is super easy and it is like patching HANA to a higher Support Package. Remember to upgrade all the HANA components like AFL at the same time during this phase. You should use hdblcm/hdblcmgui/hdblcmweb for starting the upgrade process and follow the steps described there. Again, this is the easy part so don’t worry.
Remember to upgrade the HANA clients use in all SAP systems, servers, applications, etc. that connect to the HANA database. Otherwise when you upgrade the database the applications won’t connect since the client need the SAP HANA 2.0 client version.
It is interesting that a lot of people doesn’t know yet about SAP HANA Mini Checks… This scripts are described and available in the SAP Note 1969700 – SQL Statement Collection for SAP HANA and they provided an incredible amount of information of our SAP HANA database. The SAP Note 1999993 – How-To: Interpreting SAP HANA Mini Check Results describes how to interpret the results of each mini check.
I would recommend to execute the following SAP HANA Mini Checks to check if you need to change any parameters, fix security issues, etc:
For executing the script download the file SQLStatements.zip available in the first note:
After that open the administration for the HANA database in the HANA Studio. Select the option System Information:
Right click and select the option Import SQL Statements. Select the zip file downloaded and you will have all the scripts available. After that you can type on the filter box the name of the script and execute it directly from there:
Remember to fix any issue or problem that appears in the SAP HANA Minichecks.
I’m not going to give a lot of details on this topic. What you want is to check that everything is working perfectly after the SAP HANA upgrade. Upgrading the database shouldn’t cause any major problems or issues but it is better to play safe and check that everything works as expected. Some of the elements I would check:
As you can see there are a lot of steps to perform before starting the SAP HANA 2.0 Upgrade but if you know what to do is easier and less time consuming. I always try to explain to my team members that it is really important to check all the guides, SAP Notes and documents related to the new version that are available in the SAP Support Portal, SAP Help Portal and SAP SCN. The SAP Basis work is not only about doing technical stuff. It is really important to read before starting to perform any technical tasks, write the documentation during the technical upgrade and to document the technical and functional test.
Let me know if you have any question about the whole process, I always appreciate your comments!
I hope you all survived the log4j Apocalypse and Christmas, hopefully you had a great…
I know it is being a while since I posted the last time. So far…
UPDATE 11/25/2020 Adobe released a new patch that solves the issue a few days ago:…
Good news for you fanatics of SAP GUI! SAP will release SAP GUI 7.70 in…
Quick update since I don't have a lot of time lately. During my 2019 job…
It's been a while since the last time I wrote an entry in my blog.…
View Comments
Currently we are using Hana ODBC driver 2.00.020.00 version as a client tool to Connect Hana DB with Power BI reporting tool.
My org has planned to upgrade Hana 1.x to Hana 2.0.
Does this Hana upgarde also require to upgrade Hana ODBC driver version 2.00.020.00 to ..?
It would be great if let us know the latest version of Hana ODBC driver after 2.00.020.00 ?
not sure whether Hana ODBC driver version 2.00.020.00 is the latest version or any other updated versions are there ?
Hi Srinivas,
You would need to upgrade your HANA ODBC Driver to the same version as the HANA Database version you are upgrading. Right now it is working as HANA Client 2.00 is compatible with HANA DB 1.0 version, upgrading the HANA DB will require to upgrade the HANA Client/ODBC Driver too to the same version. It will probably work if you keep the same version as you have right now but I recommend upgrading the ODBC Driver at the same time or in advance.
Regarding your question about the last version available, it should be SAP HANA CLIENT Version 2.5 that was released on July 10th. You can find the last version in the SAP Support Portal under Software Downloads: SAP IN-MERMORY (SAP HANA) / HANA PLATFORM EDITION / SAP HANA PLATFORM EDITION / SAP HANA PLATFORM EDITION 2.0.