user password reset for user re-use in hdbuserstore list

case studies:

1. If the HDB user password is restarted by the user, with out updating the password in hdbuserstore list. then the following steps need to perform.
2. If the user is locked, due to wrong password in hdbuserstore list.
3. Generally hdbuserstore key allows 6 attempts of wrong password, after that user will locked.
4. hdbuserstore list keys basically use for scripts.

steps:

alter user <user name> reset connect attempts.

alter user <user name> active user now

To change password:

alter user <user nsame> password <password>

HANA Database update check list

when update need to perform:

• while perform several update at application level. SAP recommends for HDB upgrade.
• Based on EWA.

 Pre-requisites:

1. collect all the components installed along the HDB. Based all the respective components also need to update.

2.check the present version of HANA database: with command: HDB version

Update check list:

• Download update software from SMP.
• Unsar the software.
• Stop application.
• Take complete backup (system & tenant database).
• Stop Database.
• Navigate the media --> run  ./hdblcm --> provide inputs.
• start DB, with command: HDB start
• start application.

Post - installation:

• login to application and run the t-code: SICK.

           check for any error logs here.

SAP Upgrade Dependency Analyzer(UDA)

SUM Update plan for reference

Kernal update in linux machine For HDB

1.check the present kernal version in SAP Application server:

• Su - <sid>adm
• Issue the below command to check present kernal version. 

              disp+work


2. Stop SAP Application:

• login to putty session with root user id.
• su - <sid>adm
• cd /usr/sap/hostctrl/exe/
• ./sapcontrol -nr 00 -function Stop                   Note:To stop CI, here CI instance number is 00.
• ./sapcontrol -nr 01 -function Stop                   Note:To stop CS,here CS instance number is 01.
• exit
• ps -ef | grep -i sap                                               check whether any sap services are still running.
• you will found few sap services still running with user, <sid>adm.
• pkill -u <sid>adm                                        Note: To kill all the process running with <sid>adm.

3.Stop DB:   ( here my DB is HANA)

• login to putty session with root user id in to the DB host.
• su - <sid> adm
• pwd                              - To cross check whether you are in /usr/sap/<sid>/HDBXX/ . if not change pwd to /usr/sap/<sid>/HDBXX/
• HDB stop                   - To stop HANA database, it will take some time to complete execution.
•  exit
• ps -ef | grep -i hdb
• in most of the cases, you will found still few services are running with user <sid>adm
• pkill -u <sid>adm                              Note: To kill all the process running with <sid>adm.

4. cleanipc XX remove

here XX - stands for instance number.

for more info above this step: click here

Note: cleanipc command will clean Inter Process Communication.

5.Download the SAPEXE_XXX.SAR and SAPEXEDB_XXX.SAR from service market place.

6.Take backup of present kernal file:

Cd /sapmnt/<sid>/mkdir kernal_old

    hostname: cp -r /sapmnt/<SID>/exe /sapmnt/<SID>/kernal_old

The above highlighted path is backup location of old kernal files.

7. Now move the SAPEXE_XXX.SAR and SAPEXEDB_XXX.SAR from step 4, To the directory /sapmnt/<sid>/exe.

8.Extract the kernal files in the /sapmnt/<sid>/exe using SAPCAR

• Make sure that present  kernal SAPEXE._XXX.SAR and SAPEXEDB_XXX.SAR are removed. Before exacting the latest target version kernal files.
• Can check with below Linux cmd:

         Hostname: ll *.SAR

NOTE: make damn sure that result for the above command should be

1. SAPEXE_XXX.SAR
2. SAPEXEDB_XXX.SAR of the latest target version of kernal files.

• Login as <sid>adm

PWD should be /sapmnt/<sid>/exe:/usr/sap/hostctrl/exe/SAPCAR  -xvf  * -manifest SIGNATURE.SMF


9. log in with root user
   

Issue the below command

./saproot.sh <sid>


10.start DB

• log in to the DB server host with root user.
• Su - <sid>adm
• HDB start  -to start HANA Database.

11.start the SAP Application

• Log in to the SAP Application host with root.
• Su - <sid>adm
• Cd /use/sap/hostctrl/exe/
• ./sapcontrol -nr 01 -function start
• ./sapcontrol -nr 00 -function start

12.check the update kernal version now with the command.

disp+work

Note: make sure that login user is <sid>adm.

HOW to update SPAM/SAINT version

WHY : 

• while updating Support packages to SAP erp system. some time system through the error as the Spam/saint version is too low.
• it is recommend to maintain spam/saint version to maximum version.

How: 

software required

• SAPCAR.
• spam/saint update file.

• check the SAP AP release and download based on RELEASE version.

• download path for Spam/saint file.         

 

                                                                                       

• current version of my system with T-code: spam.

• download the softwares and uncar the files.                                                                                     
• login with 000 client and access Spam T-code.                                                                             

• the initial screen of Spam is as below. which shows about maintenance certificate.      

• click on continue.                                                                                                                  

• load packages.                                                                                                                                  
• follow as shown below.