Fail to install Ranger through Ambari when using Oracle DB

[#1]

SYMPTOM : While installing Ranger through Ambari , on Oracle DB, user runs into error "sqlplus64: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory"

ERROR:

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

ROOT CAUSE : possible missing environment settings and misconfiguration in Ambari .

RESOLUTION : 1. On Ambari Server Machine, please check environment variable in Linux OS level, verify environmental path LD_LIBRARY_PATH=/usr/lib/oracle/<version>/client64/lib is set.

2. AND in Ambari config -> ranger config - advanced ranger-env, set property "oracle_home" with "/usr/lib/oracle/<version>/client64/lib"