根据审计合规的要求,HANA数据库的密码一般是要周期性地更换的,SAPABAP1一般是ECC或者S4默认的数据库Schema,更换这个schema的用户密码时需要一定的步骤和注意事项、否则会导致SAP无法连接数据。
This article will show you the steps to take when changing the SAPABAP1 HANA database schema password.
Step 1: Bring down the SAP application server(s).
Step 2: Launch the SAP HANA Studio and change the password of SAPABAP1.
Step 3: Login to the application server as sidadm. Execute below command to update the hdbuserstore. In our case, the application server is on Windows operating system.
hdbuserstore -u [SAPServiceSID] set default [DB_HOSTNAME]:[DB_PORT] [DB_USER] [DB_PASSWORD] |
Note: If you are getting Error 91007: Impersonation not supported, use sudo on this platform. Use below command instead,
hdbuserstore set default [DB_HOST]:[DB_PORT] [DB_USER] [DB_PASSWORD] |
Step 4: Once executed, confirm the database connection test by using the R3trans -d. In some cases of the error return code, please check on the user’s password or user deactivation status (too many invalid connect attempts).
Step 5: Bring up the application server.
SAP Note 2750829 – How to change SAPABAP1 schema password In HANA
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/4004.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。