SAP HANA, express edition (32GB) .....
SAP Basis System Administration Tasks
work smart. share your exprience with SAP Solutions from implementation,golive to support,challenges,questions.
Wednesday, 2 February 2022
you want to install SAP HANA on a laptop on a VM ??
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 #
Thursday, 27 January 2022
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)
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
Wednesday, 12 January 2022
SAP TCODE ST22:Check For SAP ABAP Runtime Errors
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
Start SAP Application
switch user to sidadm
1.HOSTNAME:~ # su - sidadm
2.HOSTNAME:sidadm 51> startsap
1.HOSTNAME:~ # su - sidadm
2.HOSTNAME:
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>
hostname1:~ # su - dhtadm
hostname1:~ # su - dhtadm
hostname1:~ # su - dhtadm