How to Generate full system dump in hana

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 created 2019-07-22 11:09:20 (UTC) with script version 2.00 Called with command line options: -t <TENANT SID> Writing to file /usr/sap/<SID>/SYS/global/sapcontrol/snapshots/fullsysteminfodump_SMH_SM1_solman_2019_07_22_11_09_20.zip —– 2019-07-22 16:39:20 Generate esserver stack file —– SNo running esserver found for database <TENANT SID> —– 2019-07-22 16:39:23 Exporting xsenginetraces —– No files found matching ……

How to Generate a Runtime Dump on SAP HANA

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 sidadm user 2) Run command ‘hdbcons’ 3) On the hdbcons console run command below > runtimedump dump This will create a runtimedump for the host . runtime dump file will be under traces directory with naming like ‘indexserver….rtedump.trc’.   Generate runtime dump from Python script ……

kernel profiler trace HANA

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 command as HANA sidadm >hdbcons -p <pid_of_the_problematic_tenant_indexserver> >profiler clear >profiler start {wait for 4-5min} >profiler stop >profiler print -o profiler_cpu.dot,profiler_wait.dot   This will basically create a kernel profiler trace and a HANA runtime dump. The tracefiles will be stored in the HANA tracedirectory.   SAMPLE ……

Oracle 18c installation-Prerequisite checks fails-PRVG-0282 : failed to retrieve the operating system distribution ID

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 mapping.In my case i was getting error on SLES 12 SP 03 which is supported to oracle 18c. If you are on supported version of operating system then set below parameter to ignore this error: CV_ASSUME_DISTID=SUSE12   parameter in the /oracle/<SID>/18.0.0/cv/admin/cvu_config file.  in case of  oracle ……

Process Management in SAP Solution Manager 7.2

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 Process Modeling where we gain a business process modeling tool & we can edit & change our existing Business Process in Solution Manager 7.2 itself .There is no need of any third part Modeling Tool.   In SAP Solution Manager 7.2  process management has been ……

SAP HANA CONFIGURATION FILES

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 on all hosts. /usr/sap/<sid>/HDB<inst>/<host>/<service>.ini–> Applicable for a specific service (e.g. nameserver) on a specific host. /usr/sap/<sid>/HDB<inst>/<host>/global.ini–> Valid for all services on a specific host. /usr/sap/<sid>/SYS/global/hdb/custom/config/<service>.ini –>Applicable for a specific service (e.g. nameserver) for on all hosts. How to Change HANA Configuration File: You can access ……

How to Check SAP Hana Process List

How to Check SAP Hana Process List from Command Line-OS Level: <hostname>:/usr/sap/<SID>/HDB00> /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList 28.10.2017 18:45:27 GetProcessList OK name, description, dispstatus, textstatus, starttime, elapsedtime, pid hdbdaemon, HDB Daemon, GREEN, Running, 2017 10 12 14:14:10, 388:31:17, 9240 hdbcompileserver, HDB Compileserver, GREEN, Running, 2017 10 12 14:14:14, 388:31:13, 9384 hdbindexserver, HDB Indexserver, GREEN, Running, 2017 10 12 14:14:16, 388:31:11, 9418 hdbnameserver, HDB Nameserver, GREEN, Running, 2017 10 12 14:14:11, 388:31:16, 9257 hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2017 10 12 14:14:14, 388:31:13, 9386 hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2017 10 12 14:14:45, 388:30:42, 9752 hdbxsengine, HDB XSEngine, GREEN, Running, 2017 ……

How to Check SAP Hana Services | HANA is up and running

Here i am going to explain -How to Check SAP Hana Services | HANA is up and running from SAP HANA Studio  ? Open SAP HANA Studio –> Select “System” –> Double click on system–> Select Landscape   Here you’ll find status of all Hana Services :If SAP HANA is up and running fine then for all services ,status should be green.   How to Check SAP Hana Services from Command Line: <hostname>:/usr/sap/<SID>/HDB00> /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList 28.10.2017 18:45:27 GetProcessList OK name, description, dispstatus, textstatus, starttime, elapsedtime, pid hdbdaemon, HDB Daemon, GREEN, Running, 2017 10 12 14:14:10, 388:31:17, 9240 hdbcompileserver, ……