Ruby connect to oracle failing

Question

I have installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But got this
error
CUSTOM_REQUIRE.RB:36:IN `REQUIRE: CANNOT LOAD SUCH FILE -- OCI8 (LOADERROR)

my code is here.

require oci8
oci = OCI8.new(user,pass,ip:port/sid)
 oci.exec(select * from table) do |record|
  puts record.join(,)
end

Any clue?

Comments

Have u installed ruby-oci8 gem package

---

Yes I tried to install ruby-oci8 from source but it failed.

Answer 1

For installing that ruby-oci8 gem u need
1. instantclient-basic
2. instantclient-sdk
3. u need to export LD_LIBRARY_PATH of that path
4. then run bundle install