Heroku buildpack for setting up Oracle Instant Client
In order for this buildpack to execute, it will look for a .oracle.yml file in your app's root. The file can be empty but it must exist.
touch .oracle.yml
You'll need to use multiple buildpacks. This buildpack will need to be invoked first, followed by heroku-buildpack-ruby. Heroku now supports configuring multiple buildpacks natively, or you can use the heroku-buildpack-multi buildpack.
The benefit to using heroku-buildpack-multi is that you can version-control your environment changes.
heroku buildpacks:clear
heroku buildpacks:set https://github.com/ddollar/heroku-buildpack-multi
Then inside .buildpacks, add the following contents:
https://github.com/Abdurrasheed99/oracle-heroku-buildpack/
It is sometimes desirable to use tnsnames.ora or sqlnet.ora to configure how Oracle connects to a database or to use sqlnet.ora to configure connection wallets.
The tnsnames.ora and sqlnet.ora files are often located in $ORACLE_HOME/network/admin. This buildpack will correctly setup $ORACLE_HOME and $TNS_ADMIN to point to $ORACLE_HOME/network/admin. A location for tnsnames.ora or sqlnet.ora can be configured inside the .oracle.yml file:
cat .oracle.yml
---
tnsnames.ora: config/tnsnames.ora
sqlnet.ora: config/sqlnet.ora
The files will be symlinked into vendor/oracle-instantclient/network/admin
You do not need both tnsnames.ora and sqlnet.ora, they are both optional.