How to unlock system user in hana

[anderson_cardozo]

Hi, Hana gurus.

I got problem, how to know if SYSTEM user is lock, because i can´t login into hana studio, and when try to connect through hdbsql, i don´t know which user to use because system user refuse connect.

Plese help me about it.

Thank you!

[Former Member]

For reset SYSTEM user ...follow these commands.

EXAMPLE

Session one (screen on .... logon 1)

/usr/sap/HCP/HDB05/exe/sapcontrol -nr 05 -function StopSystem HDB

/usr/sap/HCP/HDB05/hdbenv.sh

/usr/sap/HCP/HDB05/exe/hdbnameserver

Session two (the one need to be active)

/usr/sap/HCP/HDB05/hdbenv.sh

/usr/sap/HCP/HDB05/exe/hdbcompileserver

Session three (the one and two need to be active)

/usr/sap/HCP/HDB05/hdbenv.sh

/usr/sap/HCP/HDB05/exe/hdbindexserver -resetUserSystem

After reset you need start the HANA

/usr/sap/HCP/HDB05/exe/sapcontrol -nr 05 -function StartSystem HDB

For last action ... you need leave the sessions (close all sessions) ...

http://help.sap.com/saphelp_hanaplatform/helpdata/en/df/025d7abb5710148ba8b0ed6476b597/content.htm

Regards.

P. A. G. Jr.

[jitendra_kumar01]

Hi Anderson,

Go through this link, it would help you.

https://scn.sap.com/thread/3396725

BR

jitendra

[former_member183326]

Wild guess, but do you have an application connected to HANA? Have you checked the hdbuserstore? try resetting the hdbuserstore:

[former_member43352]

Please contact with your Admin team and get checked the log details.

[lucas_oliveira]

Hi,

Please search before posting. There are answers here in SCN and in the official documentation.

Reset the SYSTEM User's Password - SAP HANA Administration Guide - SAP Library

Pay attention to

Regards,

Lucas de Oliveira

[anderson_cardozo]

I appreciate you answer, Lucas.

I saw this link, but before to reset SYSTEM user, i would like check is really locked. I´m new with sap hana.

[lucas_oliveira]

Hm... looking at your screenshot it does not show an incorrect password error.. so I'm probably jumping the gun here. Apologies for that.

Are you positively sure your system is up and running on that instance? Can you log in with another user? Or maybe just try 'HDB info' with your <sid>adm user and see if all the services are up. You should see something like this:

BRs,

Lucas de Oliveira

[former_member182967]

Hi Anderson,

Check use the SQL below to check if the System user is locked or not (with another user):

select * from sys.INVALID_CONNECT_ATTEMPTS where user_name='SYSTEM'

Then execute the activities if locked mentioned in note 2251556 - SAP HANA SYSTEM user can now be locked for too many failed logon attempts

To unlock the SYSTEM user that was locked after <maximum_invalid_connect_attempts> (default 5 times), run this SQL statement: ALTER USER SYSTEM RESET CONNECT ATTEMPTS

Regards,

Ning

[Former Member]

Hi,

Have you tried logging in via the HANA Studio as another user account, for example SAPABAP1 or SAPJAVA1 as appropriate?  Thereafter you can check whether the SYSTEM account is locked.

Regards,

Graham