Oracle drivers require user click through acceptance as well as an Oracle Account in order to download.
So while the Oracle professional driver is actually present in /opt/rstudio-drivers/oracle/bin/lib /liboracleodbc_sb64.so, two shared libraries are not present (libocci.so.12.1 and libclntsh.so.12.1) which prevent the driver from loading.
I will share this post with colleagues who work on the drivers who might be able to add more context.