Cannot reset SYSTEM user

[Former Member]

Hello,

I am facing an issue, I am not able to connect to HANA with SYSTEM account. I tried via the studio and via command line but it's not working.

Then I stopped HANA and I tried to reset the SYSTEM password with the hdbnameserver -resetUserSystem command line, but I am having this error.

If anyone faced this issue?

Thank you for your help

[deepak_chodha]

Hi Majid,

Saw you getting troubled a lot here. Sorry about that. For your information the way of resetting the password of SYSTEM user has changed.

1. is your system a Multi-tenant db or Single db?

2. Depending upon that you got to execute different commands. All steps using <sidadm>

If it is multidb and you want to reset SYSTEM user password for system/tenant db follow: Guide for Multidb

If it is a single db and you want to reset the SYSTEM user password follow: Guide for Single

3. And about the issue you are getting for library I guess that will be resolved by running hdbenv.sh using sidadm user.

Try it and let us know the result.

Happy HANA, Deepak.

[Former Member]

This message was moderated.

[Former Member]

Hi Ning, Hi Devpriy,

Thank you for your responses but unfortunately I tried all these solutions but doesn't work.

I am having the same issue when I run hdbnameserver & and hdbindexserver –console :

error while loading shared libraries: libhdbpythonbase.so: cannot open shared object file: No such file or directory

Thanks

[former_member182967]

Hello Majid,

Can you use the command below to find if libhdbpythonbase.so exists.

host:/hana/shared > find ./ -name libhdbpythonbase.so

./SID/exe/linuxx86_64/HDB_1.00.74.02.392316_1577375/libhdbpythonbase.so

and the permission should be that:

-r-xr-xr-x 1 sidadm sapsys 6900729 Jun 11  2014 libhdbpythonbase.so

Regards,

Ning Tong

[Former Member]

Hello Ning,

I find the libhdbpythonbase.so and has the same permissions as you mentioned.

-r-xr-xr-x 1 hdpadm sapsys    7121558 Aug 17  2014 libhdbpythonbase.so

But when I am trying to find it I am having this permission denied:

adpaphan02:/hana/shared> find ./ -name libhdbpythonbase.so

./HDP/exe/linuxx86_64/HDB_1.00.82.00.394270_1662528/libhdbpythonbase.so

find: `./lost+found': Permission denied

find: `./hdbinst_remote_check_adpaphan02_7708': Permission denied

Regards,

Majid

[former_member182967]

Hello Majid,

The above permission deny can be ignored.

Please make sure that you switch to user sidadm with command su - sidadm and sidadm with right user environment, then run command hdbnameserver....

I make a test with user root:

root@hostA:/usr/sap/TE1/HDB05/exe > ./hdbnameserver

./hdbnameserver: error while loading shared libraries: libhdbpythonbase.so: cannot open shared object file: No such file or directory

Regards,

Ning Tong

[Former Member]

Hello Majid,

As mentioned by previous posters, please follow the password reset guide verbatim.

1. As user hdpadm, please run  HDB info. This will give you a list of running HDB processes.

2. Just to make sure, please run HDB stop as user hdpadm.

3. As user hdpadm please run the command "which libhdbpythonbase.so"

This should return: /usr/sap/HDP/HDB00/exe/libhdbpythonbase.so

4. Follow the steps from the password reset guide mentioned above.

Kindest Regards,

Amerjit

[Former Member]

Hello Amerjit,

I am connected with hdpadm and having:

adpaphan02:/usr/sap/HDP/HDB00/exe> which libhdbpythonbase.so

which: no libhdbpythonbase.so in (/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib64/jvm/jre/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin)

Is it means that is not located in the above folder or the way around?

Thanks

Majid

[Former Member]

Majid,

Now I see from you last post that you are in directory: adpaphan02:/usr/sap/HDP/HDB00/exe>

1. As hdpadm ,please run "ls -l libhdbpythonbase.so" and post the output.

2. As hdpadm ,please run "echo $PATH" and post the output.

3. As hdpadm, please prepend /usr/sap/HDP/HDB00/exe to your existing path by executing the following:

export PATH=/usr/sap/HDP/HDB00/exe:$PATH

4. Try running hdbnameserver again.

If you find the libhdbpythonbase.so in the exe path shown above along with all the other executables then it looks like your PATH may be incorrect for whatever reason so you would have to correct this.

Kindest Regards,

Amerjit

[Former Member]

Hi Amertjit,

Please find the outputs:

1.

adpaphan02:/usr/sap/HDP/HDB00/exe> ls -l libhdbpythonbase.so

-r-xr-xr-x 1 hdpadm sapsys 7121558 Aug 17  2014 libhdbpythonbase.so

2. /root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib64/jvm/jre/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib64/jvm/jre/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin

3. Done with success, I check the path and contains the added folder

4. Still have the same problem: ...cannot open shared object file...

Regards,

Majid

[Former Member]

Majid,

Are you absolutely sure that the "echo $PATH" is as user hdpadm ?

The output seems to looks like it was executed as "root".

If the "echo $PATH" was indeed executed as user hdpadm then the problem is that your PATH environment is messed up.

If you have another HANA instance, logon as the <sid>adm user of that instance and run "echo $PATH". Assuming everything is fine on the other system, it will give you an indication of what you output should look like for HDP.

KR,

Amerjit

[Former Member]

You have stooped hana server - so your name server too is down.

First start the name server and try again.

Follow this :

Thanks

Dev

[former_member182967]

Hello Majid,

The link below can help you reset your system db user:

Regards,

Ning Tong