hdbuserstore hanadb 1.0 restore

Resolution

1. Maintain the userstore so that it contains the correct hostnames. Multiple hosts/ports can be set for one key
    
        hdbuserstore SET DEFAULT :;:...
2. In case of Windows instances, the correct keys have to be set for the SAPService user as well:
    
        hdbuserstore -u \SAPService SET DEFAULT :;:...

 

 

 

HANA DB의 User/Password 가 변경이 되면서 발생한 것으로 보입니다

SWPM에서는 최초에 입력 받은 값으로 Windows AP 서버의 환경 변수에 Password 를 저장합니다.

하지만 HANA DB를 운영 백업본으로 Restore 하면서 패스워드 불일치가 발생한 것으로 보입니다.

Windows AP 서버에 기 저장된 패스워드를 아래와 같이 restore 된 패스워드로 변경해 보시기 바랍니다.

1. DEFAULT.PFL 에서 DB 정보 변경
2. command 창을 admin 계정으로 실행 후 아래와 같이 hdbuserstore 정보 변경

hdbuserstore.exe delete -u HOME\SAPService<SID> DEFAULT

hdbuserstore.exe delete -u HOME\<sid>adm

hdbuserstore.exe -u HOME\SAPService<SID> SET DEFAULT <IP>:<PORT> SAPABAP1 <PASSWORD>

hdbuserstore.exe -u HOME\<sid>adm SET DEFAULT <IP>:30015 SAPABAP1 <PASSWORD>

hdbuserstore.exe -u HOME\SAPService<SID> list