[SAP HANADB]Reset the SYSTEM User Password in the System Database(잠김해제)

**순서 SYSTEM계정 > TENANT 계정
https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/6b13cdd1982f4aa6b90b443663d17d7e.html
위의 URL 참고

**Procedure > SYSTEM 계정 변경 ,  DB shutdown이 필요함.

To reset the SYSTEM user password in emergency mode:

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

1. 2.Open a command line interface.
2. 3.Shut down the instance by executing the following command:
   /usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB
3. 4.In a new session, start the name server of the system database by executing the following commands:
   
   • /usr/sap/<SID>/HDB<instance>/hdbenv.sh
   • /usr/sap/<SID>/HDB<instance>/exe/hdbnameserver -resetUserSystem
   After some start-up notifications, the prompt resetting of user SYSTEM - new password appears, followed by additional notifications:Reset SYSTEM User Password (System Database)
4. 5.After the last notification appears, enter a new password for the SYSTEM user.

5. 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.
6.In a new session, start the instance by executing the following command:
/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StartSystem HDB
 
 

**Procedure > SYSTEM 계정으로 로그인하여 Tenant 계정 패스워드 변경 

ALTER SYSTEM STOP DATABASE SID
ALTER DATABASE ERE SYSTEM USER PASSWORD PW 지정
ALTER SYSTEM START DATABASE SID