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;