Ranger Service connection with Oracle database

If you have configured Ranger with Oracle Database as its backend, you must add the property with Key and Value.

Ranger connection with Oracle DB

If you have configured Ranger with Oracle Database as its backend, you must add the property conf/ranger-admin-site.xml with the key and value provided below for the Custom ranger-admin-site section in Ambari: Key: ranger.jpa.jdbc.preferredtestquery value: select 1 from dual;