SAP HANA DB OS level command not found error.

[chaudharyaditya88]

Hi All,

I am facing an issue with the HANA OS level commands. I want to execute hdbsql command at cli level, but its giving me the following error:

Then, i have given 777 permission to the hdbsql file but still getting the same error on execution. However, I tried the execution through ./hdbsql and this was successful.

Also, I tried execution of other commands like hdbuserstore they all are giving the same error.

Please suggest some steps to follow to resolve this issue.

Best Regards,

Aditya Chaudhary

[pfefferf · Accepted solution]

Seems like the folder is not part of your $PATH variable. You can check that with "echo $PATH". Please check in addition if the execution within the .../HDB10/exe folder works (like it is described here) and if yes, if that is part of $PATH.

[chaudharyaditya88 · Accepted solution]

Hi Florian,

Thanks for your reply.

I have checked the $PATH variable, paths are not set in the variable. I have added the path using the export command and the command is working. But its a temporarily solution.

I also tried to run the hdbenv.sh to set the PATH variable but its is giving the following error:

devadm@<HOSTS>:/usr/sap/DEV/HDB10> ./hdbenv.sh

./hdbenv.sh: line 7: /dev/null: Permission denied

./hdbenv.sh: line 83: /dev/null: Permission denied hdbenv.sh:

Error: Instance not found for host <HOSTS>./hdbenv.sh: line 212: return: can only `return' from a function or sourced script

[jgleichmann]

It seems your user environment is broken. Is your installation a systemcopy? Please check your installation with the resident hdblcm as root:

cd /hana/shared/DEV/hdblcm
./hdblcm --action=check_installation

It also seems to be that the hostname does not match the installation host. You may have to rename the host or the instance with the resident hdblcm. In this current status the environment and the DB is not usable.

[chaudharyaditya88]

Hi Jens,

Thanks for your reply. I have already fixed the issue.

As you stated the env variable was broken, so through sidadm created a bash file for updating the variable. And source it the server. This has fixed the issue.

Thanx again.

[PruthvirajGoud]

gcp-hdbs01:/hana/shared/HDX/hdblcm # ./hdblcm --action=check_installation