How to set up Privilege Delegation to sudo to oracle with shell set to /sbin/nologin
We've recently begun migrating server to a 3rd party data centre and are no longer allowed to SSH to the oracle user on Linux servers (RHEL 5,6,7).
The oracle user has it's shell set to /sbin/nologin and we have to SSH with an Active Directory account and then su - oracle -s /bin/bash.
Enterprise Manager accesses these servers using a shared key account. However, this account is not usable for some actions, such as creating a Standby, as it doesn't own the Oracle Home.
I'm trying to set EM up to be able to sudo as needed but am not sure it's possible.