[Solved] How To Reset SYSTEM User Password In Multitenant Database Conatiners [Screenhots added]

Reset the SYSTEM User Password of the System Database

If the password of the SYSTEM user in the system database is lost, you can reset it as the operating system administrator by starting the name server in emergency mode.

Step 1. Login to SAP HANA Server

Log on to the server on which the of the master index server is running

Step 2.Switch to SAPHANA Admin user

Now we need to switch to SAPHANA admin user using following command
su – sidadm

Step 3.Stop the Database
Shut down the instance by executing the following command:/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB

hdbstop_mini

 

Step 4.Start the Nameserver with Special Flag resetUserSystemNote

Now start the name server  by executing the following commands:

/usr/sap/<SID>/HDB<instance>/exe/hdbnameserver -resetUserSystem
The following prompt appears: resetting of user SYSTEM – new password

startnameserver

 

Step 5.Enter a new password for the SYSTEM user.

You must enter a password that complies with the password policy configured for the system as shown above.
The password for the SYSTEM user is reset and the index server stops.

 

Step 6.Start the Database
Then start the instance by executing the following command:/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StartSystem
If you previously deactivated the SYSTEM user, it is now also reactivated. This means you will need to deactivate it again.

altersystempassword_mini

 

Note:The password of the SYSTEM user of the system database is reset. You have to change the new password the next time you log on with this user.

If you previously deactivated the SYSTEM user, it is now also reactivated. This means you will need to deactivate it again.

Reset the SYSTEM User Password of a Tenant Database

If the password of the SYSTEM user in a tenant database is lost, you can reset it as the operating system administrator by starting the index server in emergency mode.

Note:You have the system privilege DATABASE ADMIN. Click here

 

 

 

 

Leave a Reply