更改SAPABAP1 HANA Schema密码的步骤

根据审计合规的要求,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.

更改SAPABAP1 HANA Schema密码的步骤

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

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(0)

相关文章

发表回复

登录后才能评论