search

kubo / ruby-oci8

Ruby-oci8 - Oracle interface for ruby
Other
169 stars 78 forks source link

Could not find file (completely broken) #220

Closed ughstudios closed 3 years ago

ughstudios commented 4 years ago

Hey Kubo, I hope your day is going well. I was wondering if you might be able to assist me with an issue with your ruby gem. I work for a company which makes use of your ruby gem for oracle connections and when we upgraded to a new version of Ubuntu 18 there is an issue when trying to load up our puma server. I have an image to show you. However, when I see the error it says the file could not be found, but when I check the directory, the file is in fact there. Maybe you have seen this?  https://github.com/kubo/ruby-oci8/issues/193  

It looks similar to this issue, perhaps? I will also post this to /issues on your git repository.  https://i.imgur.com/Wbt8Kq4.png

image

ughstudios commented 4 years ago

So I fixed it sort of when adding a new file to /etc/ld.so.conf.d called 'oracle.conf' and then added /opt/instantclient into that file (which is a link to the path) and it seems to boot my server. But now I have a new issue when I try to run rails console. image

kubo commented 4 years ago

oci8.c:561: in oci8lib_220.so: ORA-12170: TNS:Connect timeout occurred (OCIError)

This will not be a ruby-oci8 issue. Could you connect to the server using sqlplus? If you get same error from sqlplus, see http://www.dba-oracle.com/t_ora_12170_tns_connect_timeout.htm.