Wednesday 2 February 2022

you want to install SAP HANA on a laptop on a VM ??

 SAP HANA, express edition (32GB) .....

SAP HANA, express edition is a streamlined version of SAP HANA designed to run on laptops and other hosts.

It is free to use (even for production use cases) for in-memory databases up to 32GB. 

You can expand your deployment to 64GB, 128GB or 256GB with the purchase of an additional license.

check out below youtube link 

Tuesday 1 February 2022

display file system for SAP HANADB running on Suse Linux

 Step1;login to operating system

hanadev:~ #

Step2:to display the file system 

hanadev:~ # df -h

Filesystem                    Size  Used Avail Use% Mounted on

devtmpfs                      173G     0  173G   0% /dev

tmpfs                         319G     0  319G   0% /dev/shm

tmpfs                         173G   34M  173G   1% /run

tmpfs                         173G     0  173G   0% /sys/fs/cgroup

/dev/sda6                     163G   72G   92G  44% /

/dev/sda5                     400G   43G  358G  11% /hana/log

/dev/sda3                     800G  474G  326G  60% /hana/shared

/dev/sda4                     1.2T  634G  595G  52% /hana/data

/dev/sda2                      32G  2.6G   30G   8% /usr/sap

123.10.0.76:/var/hanabackups  4.0T  2.8T  1.3T  70% /hanabackup

tmpfs                          35G     0   35G   0% /run/user/164

tmpfs                          35G     0   35G   0% /run/user/1001

tmpfs                          35G     0   35G   0% /run/user/1004

tmpfs                          35G  4.0K   35G   1% /run/user/0

hanadev:~ # 



Check SAProuter Certificate Validity from Suse Linux

 Step1:login to where the saprouter is installed

hostname:~ # 

Step2:execute command below

hostname:/usr/sap/saprouter # ./sapgenpse get_my_name -n validity

SSO for USER "root"

  with PSE file "/usr/sap/saprouter/local.pse"


Validity  -  NotBefore:   Mon Mar 22 15:00:27 2021 (210322120027Z)

             NotAfter :   Tue Mar 22 15:00:27 2022 (220322120027Z)


hostname:/usr/sap/saprouter # 












Wednesday 26 January 2022

View all the Tcodes in SAP

 step1:Run Transaction Code SE16N











step2:enter table name as TSTCT below and press enter























step3:enter the language EN and execute























step4:view existing Tcodes with EN language

step5:to view all existing tcodes (with language EN & DE)






































view list



Tuesday 25 January 2022

How to Safely Shutdown NetBackup Appliance version 8.1.2 on ssh( putty or xshell)

 step1:login to the veritas appliance using xshell or putty


step2: Select 'Support' from menu


   step3:Select 'Shutdown' from the submenu                                                                                                                                                                                      


































step4:Select 'Shutdown' from the submenu







Wednesday 12 January 2022

SAP TCODE ST22:Check For SAP ABAP Runtime Errors

 Step1:Enter Tcode ST22


Step2:Display of Runtime Errors Development System













Friday 29 August 2014

Most Used SUSE LINUX Commands when running SAP

suse linux commands

  •  ls
  •  cp * -rv /usr/sap/SID/SYS/exe/uc/linuxx86_64/
  •  exit
  • df -h
  • cd /dump
  • cat SAPCAR
  • clear
  • du -sh *
  •  du -h
  • mkdir uc_BACKUP
  •  cp /usr/sap/SID/SYS/exe/uc/ .
  • ll /usr/sap/SID/SYS/exe/uc/
  •  mv linuxx86_64/ linuxx86_64_1
  • rm -r linuxx86_64
  • cp -r linuxx86_64/ linuxx86_64_1
  •  su - sidadm
  •  pwd
  • history
  • la
  • mv 50121831.ZIP  50121831/
  • du -h LIBRARY_SEP
  • ps -eaf | grep sapinst
  • kill -9 PID
  •  rm *.*
  •  rm -rv SUPPORT_CONTAINER/ dev_sap_kernel
  •  ls
  •   ./installer &
  •  vi CDLABEL.ASC
  •  cat CDLABEL.ASC
  •   service apache2 status
  •   /etc/init.d/httpd start
  •   which apache
  •   service network status
  •   df -k
  •   df -h
  •   ls -lrr
  •   mkdir /dump1/Kernel_741-42
  •   pwd
  •   find . -print| cpio -pduvm /dump1/Kernel_741-42/
  •   ls -lrt
  •   more sapstartsrv.log
  •   ll /sapmnt/SID/exe
  •   cd ../ERP-SOFTWARE/SWPM/
  •   whoami
  •   chown -R 777 /SUM/SUM1
  •   chown sidadm /SUM/SUM1

start and stop SAP ERP & HANADB running on Suse Linux

Start & Stop SAP ERP Running on SAP HANA DB in SUSE Linux

Steps

----------------------------------------------------------------------------------------------------------
log in to operating system using root where the application is running

Start SAP Application 
 switch user to  sidadm
1.HOSTNAME:~ # su - sidadm
2.HOSTNAME:sidadm 51> startsap
----------------------------------------------------------------------------------------------------------
hostname:~ # 
hostname:~ # su - sidadm
hostname:sidadm 56> startsap
Checking db Database
Database is running
-------------------------------------------
Starting Startup Agent sapstartsrv
OK
Instance Service on host hostname started
-------------------------------------------
starting SAP Instance ASCS01
Startup-Log is written to /home/sidadm/startsap_ASCS01.log
-------------------------------------------
/usr/sap/TFS/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start
Instance on host hostname started
Starting Startup Agent sapstartsrv
OK
Instance Service on host hostname started
-------------------------------------------
starting SAP Instance DVEBMGS00
Startup-Log is written to /home/sidadm/startsap_DVEBMGS00.log
-------------------------------------------
/usr/sap/SID/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start
Instance on host hostname started
hostname:sidadm 57> 

----------------------------------------------------------------------------------------------------------
log in to operating system using root where the application is running

Stop SAP Application 
 switch user to  sidadm
1.HOSTNAME:~ # su - sidadm
2.HOSTNAME:adm 51> stopsap
----------------------------------------------------------------------------------------------------------
hostname:~ # 
hostname:~ # su - sidadm
hostname:sidadm 55> stopsap 
Checking db Database
Database is running
-------------------------------------------
stopping the SAP instance DVEBMGS00
Shutdown-Log is written to /home/sidadm/stopsap_DVEBMGS00.log
-------------------------------------------
/usr/sap/SID/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Stop
Instance on host hostname stopped
Waiting for cleanup of resources
............
stopping the SAP instance ASCS01
Shutdown-Log is written to /home/sidadm/stopsap_ASCS01.log
-------------------------------------------
/usr/sap/SID/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Stop
Instance on host hostname stopped
Waiting for cleanup of resources
.
hostname:sidadm 56> 
----------------------------------------------------------------------------------------------------------

Display Primary application server instance: DVEBMGS00 Status (Running or Stopped or Starting):
hostname:sidadm 57> sapcontrol -nr 00 -function GetProcessList

13.01.2022 08:40:15
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
disp+work, Dispatcher, GREEN, Running, 2022 01 13 08:18:11, 0:22:04, 28656
igswd_mt, IGS Watchdog, GREEN, Running, 2022 01 13 08:18:11, 0:22:04, 28657
gwrd, Gateway, GREEN, Running, 2022 01 13 08:18:12, 0:22:03, 28675
icman, ICM, GREEN, Running, 2022 01 13 08:18:12, 0:22:03, 28676
hostname:sidadm 58>

Display ABAP Central Services instance (ASCS instance): ASCS01 Status (Running or Stopped or Starting):
hostname:sidadm  58> sapcontrol -nr 01 -function GetProcessList

13.01.2022 09:29:30
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
msg_server, MessageServer, GREEN, Running, 2022 01 13 08:17:59, 1:11:31, 27122
enserver, EnqueueServer, GREEN, Running, 2022 01 13 08:17:59, 1:11:31, 27123
hostname:sidadm  59> 

----------------------------------------------------------------------------------------------------------

Start & Stop  SAP HANA DB Running in SUSE Linux

Step1: Checking the status of  SAP HANA DB System process list if (running or stopped)

log in to operating system using root where the SAP HANA db is running

hostname1:~ #

hostname1:~ # su - dhtadm

dhtadm@hostname1:/usr/sap/DHT/HDB00> 

dhtadm@hostname1:/usr/sap/DHT/HDB00> sapcontrol -nr 00 -function GetProcessList

05.03.2021 07:53:06

GetProcessList

OK

name, description, dispstatus, textstatus, starttime, elapsedtime, pid

hdbdaemon, HDB Daemon, GREEN, Running, 2020 10 30 19:51:57, 3012:01:09, 16473

hdbcompileserver, HDB Compileserver, GREEN, Running, 2020 10 30 19:52:14, 3012:00:52, 16737

hdbdiserver, HDB Deployment Infrastructure Server, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18668

hdbdiserver, HDB Deployment Infrastructure Server-, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18672

hdbindexserver, HDB Indexserver-DET, GREEN, Running, 2020 10 30 19:52:16, 3012:00:50, 16791

hdbindexserver, HDB Indexserver-QET, GREEN, Running, 2021 03 04 09:00:59, 22:52:07, 29885

hdbindexserver, HDB Indexserver-DHT, GREEN, Running, 2020 10 30 19:52:16, 3012:00:50, 16797

hdbnameserver, HDB Nameserver, GREEN, Running, 2020 10 30 19:51:58, 3012:01:08, 16497

hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2020 10 30 19:52:14, 3012:00:52, 16740

hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18675

hdbxscontroller, HDB XS Controller, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18678

hdbxsengine, HDB XSEngine-DHT, GREEN, Running, 2020 10 30 19:52:16, 3012:00:50, 16803

hdbxsexecagent, HDB XS Execution Agent, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18681

hdbxsuaaserver, HDB XS UAA Server, GREEN, Running, 2020 10 30 19:53:10, 3011:59:56, 18684

hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 04 11:02:57, 20:50:09, 911

hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 04 16:01:11, 15:51:55, 23440

hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 04 11:01:13, 20:51:53, 32001

hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 04 11:14:32, 20:38:34, 3912

dhtadm@ktfhanahost1:/usr/sap/DHT/HDB00> 


Step3:Stoping SAP HANA DB SYSTEM
log in to operating system using root where the SAP HANA db is running

hostname1:~ #

hostname1:~ # su - dhtadm

dhtadm@hostname1:/usr/sap/DHT/HDB00> sapcontrol -nr 00 -function StopSystem ALL

05.03.2021 07:53:27
StopSystem
OK
dhtadm@hostname1:/usr/sap/DHT/HDB00>

Step3.1:Checking the status of  SAP HANA DB System process list if (stopped)
dhtadm@hostname1:/usr/sap/DHT/HDB00> sapcontrol -nr 00 -function GetProcessList

05.03.2021 07:53:40
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, YELLOW, Stopping, 2020 10 30 19:51:57, 3012:01:43, 16473
hdbcompileserver, HDB Compileserver, YELLOW, Stopping, 2020 10 30 19:52:14, 3012:01:26, 16737
hdbdiserver, HDB Deployment Infrastructure Server, YELLOW, Stopping, 2020 10 30 19:53:10, 3012:00:30, 18668
hdbdiserver, HDB Deployment Infrastructure Server-DHT, YELLOW, Stopping, 2020 10 30 19:53:10, 3012:00:30, 18672
hdbindexserver, HDB Indexserver-DET, YELLOW, Stopping, 2020 10 30 19:52:16, 3012:01:24, 16791
hdbindexserver, HDB Indexserver-QET, YELLOW, Stopping, 2021 03 04 09:00:59, 22:52:41, 29885
hdbindexserver, HDB Indexserver-DHT, YELLOW, Stopping, 2020 10 30 19:52:16, 3012:01:24, 16797
hdbnameserver, HDB Nameserver, YELLOW, Stopping, 2020 10 30 19:51:58, 3012:01:42, 16497
hdbpreprocessor, HDB Preprocessor, YELLOW, Stopping, 2020 10 30 19:52:14, 3012:01:26, 16740
hdbwebdispatcher, HDB Web Dispatcher, YELLOW, Stopping, 2020 10 30 19:53:10, 3012:00:30, 18675
hdbxscontroller, HDB XS Controller, YELLOW, Stopping, 2020 10 30 19:53:10, 3012:00:30, 18678
hdbxsengine, HDB XSEngine-DHT, YELLOW, Stopping, 2020 10 30 19:52:16, 3012:01:24, 16803
hdbxsexecagent, HDB XS Execution Agent, YELLOW, Stopping, 2020 10 30 19:53:10, 3012:00:30, 18681
hdbxsuaaserver, HDB XS UAA Server, YELLOW, Scheduled, , , -1
hdbdpserver, HDB DPserver-QET, YELLOW, Scheduled, , , -1
hdbdpserver, HDB DPserver-QET, YELLOW, Scheduled, , , -1
hdbdpserver, HDB DPserver-QET, YELLOW, Scheduled, , , -1
hdbdpserver, HDB DPserver-QET, YELLOW, Scheduled, , , -1
dhtadm@hostname1:/usr/sap/DHT/HDB00>

Step4:Starting SAP HANA DB System

log in to operating system using root where the SAP HANA db is running

hostname1:~ #

hostname1:~ # su - dhtadm

dhtadm@hostname1:/usr/sap/DHT/HDB00> sapcontrol -nr 00 -function StartSystem ALL

05.03.2021 08:06:52
StartSystem
OK
dhtadm@hostname1:/usr/sap/DHT/HDB00> 

Step4.1:Checking the status of  SAP HANA DB System process list if (running)
log in to operating system using root where the SAP HANA db is running

hostname1:~ #

hostname1:~ # su - dhtadm

dhtadm@hostname1:/usr/sap/DHT/HDB00> sapcontrol -nr 00 -function GetProcessList

05.03.2021 08:08:52
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, YELLOW, Initializing, 2021 03 05 08:06:54, 0:01:58, 11594
hdbcompileserver, HDB Compileserver, GREEN, Running, 2021 03 05 08:07:14, 0:01:38, 11831
hdbdiserver, HDB Deployment Infrastructure Server, YELLOW, Scheduled, , , -1
hdbdiserver, HDB Deployment Infrastructure Server-DHT, YELLOW, Scheduled, , , -1
hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 05 08:07:16, 0:01:36, 11885
hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 05 08:07:16, 0:01:36, 11888
hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 05 08:07:16, 0:01:36, 11891
hdbdpserver, HDB DPserver-QET, GREEN, Running, 2021 03 05 08:07:16, 0:01:36, 11894
hdbindexserver, HDB Indexserver-DET, YELLOW, Initializing, 2021 03 05 08:07:16, 0:01:36, 11900
hdbindexserver, HDB Indexserver-QET, GREEN, Running, 2021 03 05 08:07:16, 0:01:36, 11903
dbindexserver, HDB Indexserver-DHT, YELLOW, Initializing, 2021 03 05 08:07:16, 0:01:36, 11915
hdbnameserver, HDB Nameserver, GREEN, Running, 2021 03 05 08:06:54, 0:01:58, 11613
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2021 03 05 08:07:14, 0:01:38, 11834
hdbwebdispatcher, HDB Web Dispatcher, YELLOW, Scheduled, , , -1
hdbxscontroller, HDB XS Controller, YELLOW, Scheduled, , , -1
hdbxsengine, HDB XSEngine-DHT, YELLOW, Initializing, 2021 03 05 08:07:16, 0:01:36, 11924
hdbxsexecagent, HDB XS Execution Agent, YELLOW, Scheduled, , , -1
hdbxsuaaserver, HDB XS UAA Server, YELLOW, Scheduled, , , -1
dhtadm@hostname1:/usr/sap/DHT/HDB00> 
----------------------------------------------------------------------------------------------------------