Friday, March 21, 2025

HDBUSERSTORE COMMANDS FOR HANA

 HDBUSERSTORE COMMANDS:


Set-up userstore for schema:

hdbuserstore list:   this will show the list of saved user details in the userstore.

Update the schema name and password at OS level

hdbuserstore SET <keyname> <db_hostname>:3<nn>13@SID <schemaname> <password> 

hdbuserstore set DEFAULT <sappmdb01>:31813@HDB SAPABAP1 password_123

hdbuserstore set BACKUP_KEY <sappmdb01>:32213 <backup_user>  <password_123>

login to SQL console at OS level:

hdbsql -U <KeyName> : use this to login to sql console using the key from OS level

hdbsql -u <user name> -p <password> -n <dbhostname>:3<##>13 : login to sql console(os level) by providing the user name and password 

=======================================

hdbnsutil -sr_unregister

CREATE USER <user> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;


sapcontrol -nr 00 -function StartService PS4
ps -ef | grep sapstartsrv
sapcontrol -nr 00 -function Start

python systemReplicationStatus.py

sapcontrol -nr <##> -function GetSystemInstanceList

sapcontrol -nr <##> -function StartSystem

sapcontrol -nr 00 -function GetProcessList


No comments:

Post a Comment