How to Resetting the SYSTEM User Password in Multitenant Database Containers in SAP HANA Database

How to Resetting the SYSTEM User Password in Multitenant Database Containers in SAP HANA Database.

Steps to change SYSTEM User Password

Log on to the server on which the name server of the system database is running as the operating system user (that is, adm user).

Open a command line interface.

Shut down the instance by executing the following command:

/usr/sap//HDB/exe/sapcontrol -nr -function StopSystem HDB

In a new session, start the name server of the system database by executing the following commands:

/usr/sap//HDB/hdbenv.sh

/usr/sap//HDB/exe/hdbnameserver -resetUserSystem

After some start-up notifications, the prompt resetting of user SYSTEM - new password appears, followed by additional notifications:

The appearance of the last notification, enter a new password for the SYSTEM user.

You must enter a password that complies with the password policy configured for the system.

The password for the SYSTEM user of the system database is reset and the name server stops.

In a new session, start the instance by executing the following command:

/usr/sap//HDB/exe/sapcontrol -nr -function StartSystem HDB