Issue: If your Java system server nodes are not coming up and in the server log files you see similar entries as below . Aug 2, 2019 12:22:39 PM com.sap.security.core.persistence [SAPEngine_System_Thread[impl:5]_125] Fatal: Initialization of ABAP data source (com.sap.security.core.persistence.datasource.imp.R3Persistence) failed: “Name or password is incorrect (repeat logon)”. This message is critical if it appears during the startup of the AS Java. Aug 2, 2019 12:22:39 PM …re.server.ume.service.UMEServiceFrame [SAPEngine_System_Thread[impl:5]_125] Fatal: service com.sap.security.core.ume.service ================= ERROR ================= Core service com.sap.security.core.ume.service failed. J2EE Engine cannot be started. com.sap.engine.frame.ServiceException: Start of UME service failed. Check help topic “Start of UME Service Failed”. Technical details: Name or ……
What is UPGANA.XML and File Location-How to access it.
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 file provides information about phases which took longest time in the upgrade process and we can investigate and see improvement scope for long running phase. UPGANA.XML File Location: The UPGANA.XML file can exist in either: ../SUM/abap/htdoc/UPGANA.XML for SUM 1.0 ../SUM/abap/doc/analysis/UPGANA.XML for SUM 2.0 Note: ProcessOverview.html is ……
How to Stop and Start SAP HANA Tenant Database
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 commands for Stop and Start SAP HANA Tenant Database. How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID): alter system stop database SMH How to verify if Tenant database has been stopped: Execute SQL command: select * from m_databases; ACTIVE ……
How to list all the HANA databases for Multi tenant Databases
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” then you’ll not get the list of all the tenant databases . M_DATABASES only shows the current SYSTEMDB. Solution : Provide DATABASE ADMIN or DATABASE STOP or DATABASE START privilege to the said user (in SYSTEMDB) then execute : select * from M_DATABASES again from ……
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 ……