Introduction. Basis Administration in the Age of SAP HANA requires new skills from SAP Basis Administrators. One of them HANA DB Maintenance & Upgrade. For example, DB-revisions should be installed at regular intervals to avoid errors and to keep your Database up to date
Prerequisites for HANA DB Upgrade.
Corrections are shipped in the form of Revisions and Support Packages Stack (SPS) of the product’s components. This blog post about Revisions.
Find correction on SAP Launchpad. For example, if you want upgrade Revision Rev037_1 to Rev037_3
NB: For HANA DB Rev037_3 ->LCAPPS plugin must be 037.03 version too
NB: Very important moment. Structure after extracting procedure must be separated
NB: stopsap j2ee *for Java systemsstopsap R3 *for ABAP systems
NB: su <sidadm>/usr/sap/<sid>/<sid><instance>/HDB stopNB: Average time for HANA DB stopping: 5-20 minutes (this measure depends on the DB-size).
NB:For example OS-path may be:/<path>/SAP_HANA_DATABASE/hdblcm –ignore=check_signature_file
NB: Installation process must be from SYSTEM (SAP HANA initial DB super user)If you lock this user for security reasons ->Unblock SYSTEM user for this task
NB: /usr/sap/<sid>/<sid><instance>/HDB version
NB:Result must be – no errors reported.
SAP BASIS Routine task with examples from real life was provided
Related Notes / Guides: