I need assistance with an alternative to Oracle 12c since its been deprecated. In my organization we were using Oracle 12c when clients requested access to the ROracle package in order to access an Oracle database. The setup was the following:
Client gets Oracle Client 64 bit - 12CR264 software installed on their machine
Client opens command prompt and runs the two commands to set their environment variables:
Recently, we have upgraded the RStudio version in our organization, along with R and RTools. We are currently running the following versions of these three softwares: RStudio 2024.09.1, R 4.4.3, RTools 4.4. With this upgrade, along with Oracle Client 64 bit - 19CR364 being the current deployment of Oracle our setup process no longer works. Because of this, I am reaching out requesting assistance for if you have any work around or new processes in place for using the ROracle package. It is also worth noting that clients in our organization dont have administrative privileges within RStudio.
Hi @patrick1
Welcome to the Posit Community Forum.
You may have already solved this issue. If not, I suspect that the two environmental variables being set in Windows are not pointing to the location of the new version of Oracle, which means that when the ROracle package is being compiled it is not pointing to the correct location.
See this Gemini AI thread for a (possible) solution: https://share.google/aimode/oYZ39VIJOa6AMMalx
If that approach fails, then I suggest you contact the maintainer of the ROracle package for advice.
I tried your suggestion but it didnt work. I visited the Gemini thread you linked and saw I should use the setx command to point to C:\oracle19c\client\sdk\include however I dont have that path in my folder. When I installed oracle19c through my organization, the file structure was different. For example, the path is like this C:\oracle19c\client19cR364 and there is no sdx folder here, only an xdk. Do you know how I could get in contact with the maintainer of ROracle?