Friday, 24 May 2019

SAP HANA sidadm user login error

Tags

Symptom

It is reported that when logging in with an adm, and the loging scripts initializing the users environment fail to run correctly and the Admin user cannot be used.

It is also reported that other adm accounts do not have the same problem, even for the same SID.

The following errors are seen when logging in:

:~ # su - adm
su: warning: cannot change directory to /usr/sap//home: Permission denied
-sh: grep: command not found
-sh: warning: setlocale: LC_MESSAGES: cannot change locale (en_US.UTF-8): Permission denied
-sh: warning: setlocale: LC_CTYPE: cannot change locale (en_US.UTF-8): Permission denied
-sh: warning: setlocale: LC_COLLATE: cannot change locale (en_US.UTF-8): Permission denied
-sh: warning: setlocale: LC_TIME: cannot change locale (en_US.UTF-8): Permission denied
-sh: warning: setlocale: LC_NUMERIC: cannot change locale (en_US.UTF-8): Permission denied
-sh: warning: setlocale: LC_COLLATE: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_COLLATE: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_CTYPE: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_CTYPE: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_MESSAGES: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_MESSAGES: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_NUMERIC: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_NUMERIC: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_TIME: cannot change locale (en_US.UTF-8)
-sh: warning: setlocale: LC_TIME: cannot change locale (en_US.UTF-8)
-sh: grep: command not found
-sh: grep: command not found
-sh: grep: command not found
-sh: grep: command not found
-sh: grep: command not found
-sh: grep: command not found
-sh: grep: command not found
-sh: sed: command not found
-sh: sed: command not found
-sh: /usr/sap//home/.profile: Permission denied
adm@:/root>


Environment

HANA DB 2.0
Reproducing the Issue

    Log in with the User Account adm (using ssh or su will give the same result).


Cause

The adm user has the following ACL permissions for the /usr directory:

# file: usr
# owner: root
# group: root
user::rwx
user:adm:r--
group::r-x
mask::r-x
other::r-x


Solution

Grant read/write persmissions to the "SID"adm user








More details2780462


EmoticonEmoticon

Note: only a member of this blog may post a comment.