If your – HANA - SYSTEM user’s password is lost, then we can reset the password for this user as operating system administrator with starting the “index server” in emergency mode.
Everything About SAP Basis
-
SAP HANA Status Check via SAPCONTROL
You can easily check you SAP HANA system’s status on Linux system via “sapcontrol” command…To do this...
-
List all Connected Applications to SAP HANA
You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor. ...
-
LIST & KILL Sessions on HANA
If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions...
-
Check Memory Usage and DB Size on HANA via SQL
You can use the following SQL queries to check your HANA system’s memory usage details… ...
-
Activate / Deactivate user in SAP HANA DB
The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the...
-
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In...
-
HANA Backup and Recovery SQL Queries
You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation. ...
-
Useful Python Scripts for HANA
All python scripts can be found in exe/python_support directory. These scripts can affect the system therefore it’s better to check with...
-
HANA Cleaner Python Script – hanacleaner.py
SAP HANA cleanup tasks like purging the backup catalog or deleting old trace files need to be implemented individually.SAP created a Python script...
-
Changing HTTP to HTTPS for Repository and Directory Tools for NWA
If you want to use HTTPS protocol for your NWA internal addresses instead of HTTP address redirection, then you can use the following steps to...
Object Missing in the Database
If you are getting an error like “Object Missing in the Database” in transaction DB02 then you should follow the steps below to eliminate the problem from you SAP system.
Unknown Objects in ABAP Dictionary
If you are getting an error message under the DB02 –> Missing Tables and Indexes –> Unknown Objects in ABAP Dictionary area, then you can follow the steps below to get rid of this error message for your SAP system.
Creating SERVICE in SUSE Linux Ent 12 SP1
If you want to make a process as a “service” and want to start that service at the time of booting of Suse Enterprise linux then you can check the following example to create your own service easily…
STRUST – Issuer Certificate Missing in Database
If you are getting an error message like “Issuer certificate missing in database” while importing the certificate response via STRUST transaction then try the following steps…
Enabling AUTOSTART of SAP HANA Database on Server Boot Situation
If you want to enable AUTOSTART option for your HANA database after a server reboot situation then you can do it with editing the following file…
Deactivating HTTPs for Webdynpro pages
If you want to deactivate HTTPs redirection method for “Webdynpro” pages, then you can use the below steps to do it easily…
CMC/BI LaunchPad Session Timeout
If you are getting an error “CMC/BI Lanunchpad Session Timeout” due to default value of 20 min. then you can change this value up to 60 min. with following easy steps.
Business Objects Upgrade from 4.0 to 4.1 sp4
This document describes the upgrade process of the “Business Objects Software” from the version 4.0 to version 4.1 sp4.You can download the related files from following service.sap.com location
Windows Pagefile Calculator
You can easily calculate your pagefile requirements with the excel file which included in the SAP Note 1518419
The standalone Software Update Manager GUI is no longer supported
If you are getting an error like “The standalone Software Update Manager GUI is no longer supported. You have to use the browser-based SL Common GUI. For more information, see section SL Common Graphic User Interface of the SUM user guide” while attempting to start SUM tool then you should check the following note.
SAP HANA Studio Installation
You can easily install “SAP HANA Studio” in this article , just follow the steps…
Download SAP HANA Studio
If you have a valid user ID from SAP then you can download “SAP HANA Studio” from SAP Service Market Place with the following address
HANA Cloud Platform for Trial
SAP provides a trial instance of HANA Cloud and you can be used for learnind porposes.If you want to discover new SAP HANA Cloud Platform for free then you can create a trial account with the following steps easily…
HANA TCP/IP Ports
You can find the TCP/IP (Transmission Control Protocol/Internet Protocol) ports for HANA system in this post.
Suite on HANA Sizing Report
If you are wondendering of your SAP Suite system’s “Memory and DB” size transformation after a HANA migration operation then you should implement the following OSS notes and execute the SAP report “/SDF/HDB_SIZING” to get these detail informations.
HANA Installation on SUSE Linux
You can install the HANA on SUSE linux OS system accordingly this post easily , just follow the screens and check the remarks…
SAP HANA Certified Hardware Check
If you want to implement or migrate your SAP system to a new HANA system then first thing you should do is checking the hardware certified situation , to do this , you can use the below updated SAP official web site.
VMware vSphere Host Monitoring Interface for Linux SAP Systems
If you want to operate an SAP system on a VMware structure then you shoud do the following installation and settings to accomplish enhanced SAP system monitoring.
Install VMWare Tools on Linux System
If you are going to use Linux OS for your SAP installation on VMware platform , you should first start with installing “VMware Tools” on the system.
SAP HANA Sizing for SAP BW
After the BW version 7.3 SP5 we can run SAP BW on SAP HANA platform , before migrate our SAP BW to new HANA platform , SAP recommendation is using the following new ABAP sizing report to calculate new machine specifications.
Kernel Releases for the SAP NetWeaver AS ABAP
You can find the information about which Kernel version is required with which NW release and which NW SP Stack in this post , also the maintenance of each NW Kernel version ends and which higher Kernel version is available as DCK – “Downward Compatible Kernel” in order to apply Kernel patches.
SUSE Linux “Software” Selection for HANA Installation
If you want to install “HANA System” on your SUSE Linux installation , then you should select the following “Software’s” according to related SAP OSS notes while your Linux system installation is running.
Add Swap File to SUSE Linux System
If you want to add new “Swap Space” to your SUSE linux system then you can follow the below steps to do it easily..
Featured Posts
-
SAP HANA Status Check via SAPCONTROL
-
List all Connected Applications to SAP HANA
-
LIST & KILL Sessions on HANA
-
Check Memory Usage and DB Size on HANA via SQL
-
Activate / Deactivate user in SAP HANA DB
-
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
-
HANA Backup and Recovery SQL Queries
-
Useful Python Scripts for HANA
-
HANA Cleaner Python Script – hanacleaner.py
-
Changing HTTP to HTTPS for Repository and Directory Tools for NWA
Recent Comments