Skip to Content
0

resetting SYSTEM password

May 07 at 09:06 PM

118

avatar image

Hi everyone!

I try to reset HANA SYSTEM user password following this manual

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.03/en-US/6b13cdd1982f4aa6b90b443663d17d7e.html

.I stuck on step 4, where I use command:

/usr/sap/D10/HDB01/hdbenv.sh

And receive: hdbenv.sh: Error: Instance not found for host <my host name>

What does it actually mean in my case? What I'm doing wrong?

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ayman Salem May 07 at 09:59 PM
1

It looks like you are using an instance number other than 01 for your host

So you can check which instance number for which host, (in your case) go to the directory "/usr/sap/D10/SYS/profile" and look at the files there.

you should see file like D10_HDB<instance>_<hostname>

After you receive the instance number for your host, change to the directory "/usr/sap/D10/HDB<instance>" and run the ./hdbenv.sh

I hope that helps you

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your answer!

The output looks like: "D10_HDB01_sonya.ls.local DEFAULT.PFL".

But changing the directory helps to run hdbenv.

Now I have a problems running nameserver with command:

  • /usr/sap/D10>/HDB10/exe/hdbnameserver -resetUserSystem

The output is:

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

Also HDB info and HDB stop returns:

sh: HDB: command not found

0

the path of the command is wrong, in your case, it should:

<admuser>@sonya:/usr/sap/D10>/usr/sap/D10/HDB01/exe/hdbnameserver -resetUserSystem

....

or change to the directory: cd /usr/sap/D10/HDB01/exe and from there run the command as: ./hdbnameserver -resetUserSystem

0

This solution is not working with the same error message

0

It seems the hdbenv.sh did not run correctly

try the whole steps again and note that step 4 is executed as described in a new session.

4. In a new session, start the name server of the system database by executing the following commands

....

....

but first test which hostname that you have with command: hostname

It should match the last part of the profile file name, in your case: D10_HDB01_sonya.ls.local

if not, start the hdbenv as follows: /usr/sap/D10/HDB01/hdbenv.sh sonya.ls.local

0