After the successful completion of an upgrade via Software Update Manager (SUM) tool, UPGANA.XML file plays important role for doing run time analysis. and it is very important in case of we need to analyze our previous mock upgrade run-time behavior and based on analysis we want to improve downtime for upcoming upgrade . UPGANA.XML…
There are multiple way to stop and start SAP HANA Tenant Database . But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio . Step 1- Launch SAP HANA Studio and open SQL console . Once SQL Console is open then you can execute below mentioned sql…
In this tutorial I’ll explain How to list all the HANA databases for Multi tenant Databases. Step 1– Launch SAP HANA Studio and open SQL console .( using SYSTEMDB) Step 2 – Execute query ” select * from m_databases “. Note: If above query is executed from different user apart from “SYSTEM”…
If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate full system dump for further analysis. This blog with help you to generate Generate full system dump in hana. Goto /usr/sap/<SID>/HDBXX/exe/python_support directory Run python script fullSystemInfoDump.py as following: <HOSTNAME>:/usr/sap/<SID>/HDB10/exe/python_support> python fullSystemInfoDump.py -t <TENANT SID> System Info Dump…
If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate a runtime dump for further analysis. This blog with help you to generate a runtime dump in HANA database. Easiest way to generate runtime dump is from OS Level: 1) Log into the HANA host as…
How to Generate Kernel Profiler trace in HANA If You are experiencing high memory consumption / out of memory situations . SAP is asking you to provide a Kernel Profiler Trace. This blog with help you to generate kernel profiler trace in HANA database. start a kernel profiler trace on OS level by running the following…
Problem : During Oracle 18c installation while running prerequisites check it fails with below error . “PRVG-0282 : failed to retrieve the operating system distribution ID” The command used was: ./RUNINSTALLER -ohcheck Next step and resolution : Check if your Oracle18C is supported with your operating system version and check oracle documentation for supported version…
In this article , I am going to explain introduction of Process Management in SAP Solution Manager 7.2 Introduction of process management in sap solution manager 7.2 Solution Documentation is most interesting & powerful change in Solution manager 7.2 in compare to Solution Manager 7.1. In Solution Manager 7.2 ,SAP has come up with Graphic Business…
What is SAP HANA Configuration Files: SAP HANA COnfiguration Files contains SAP HANA Database configuration setting. Type & Location of HANA Configuration Files: There are 2 types of configuration files- Global Configuration files valid on all hosts or Local valid on specific host.(host Specific) /usr/sap/<sid>/SYS/global/hdb/custom/config/global.ini –> Contains configuration setting applicable for all services…
Here i am going to explain – Where to check Hana Errors & Logs & location of SAP Hana Trace file location : Go to Path -> /usr/sap/<SID>/HDB00/<hostname>/trace Here you’ll get trace files for all SAP Hana Process/Services: