When you change the password of connecting user of SAP HANA database, same should be updated in the key file of the HDBUSERSTORE on the Application Server.
You should be logged in with <SIDADM> for this procedure. Take care of this specially if you application server and database are running on same server.
#> hdbuserstore SET DEFAULT <hostname>:3<instance Number>15 <user> <password>
Note: User option -i along with the command if you want to enter the options (mainly password) interactively.
Example:
hdbuserstore SET DEFAULT hanahost:30015 SYSTEM Hana@123
Once updated check the list using the below command.
#> hdbuserstore list
DATA FILE : /home/appadm/.hdb/hanahost/SSFS_HDB.DAT
KEY FILE : /home/appadm/.hdb/hanahost/SSFS_HDB.KEY
KEY DEFAULT
ENV : HANAHOST:30015
USER: SYSTEM
You can now check the connectivity with the DATABASE using R3trans -d.
If R3trans -d reports error, check the connectivity with hdbsql using the key created above.
#> hdbsql -U <KEY> #Key is “DEFAULT” in our example.
This should connect to the database without any issues.
You might receive error sql code rcSQL = -10709 in case of connectivity issues. Please check the host name and port again in case of issues.
In case of any issues/questions please leave a comment below. Happy learning.
Important Notes:
2250144 – FAQ: SAP HANA Secure User Store
2563762 – hdbuserstore still using old hostname after updating
2399996 – How-To: Configuring automatic SAP HANA Cleanup with SAP HANACleaner
2653777 – Phyton connection to HANA database using hdbuserstore-key fails
2416706 – Check file permissions for SAP HANA client hdbuserstore on application server
2130496 – Application does not start after takeover-HANA Disaster Recovery
2709350 – How To set a HANA System License via HDBSQL