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