Issue with connecting to oracle database

73 views
Skip to first unread message

shashank tiwari

unread,
Feb 12, 2019, 1:56:02 PM2/12/19
to Ruby on Rails: Talk
irb(main):004:0> require 'ruby-oci8'
LoadError: Cannot find OCI.DLL in PATH.
        from C:/tools/ruby23/lib/ruby/gems/2.3.0/gems/ruby-oci8-2.2.7-x64-mingw32/lib/oci8/check_load_error.rb:42:in `check_os_specific_load_error'
        from C:/tools/ruby23/lib/ruby/gems/2.3.0/gems/ruby-oci8-2.2.7-x64-mingw32/lib/oci8/check_load_error.rb:138:in `check_load_error'
        from C:/tools/ruby23/lib/ruby/gems/2.3.0/gems/ruby-oci8-2.2.7-x64-mingw32/lib/oci8.rb:110:in `rescue in <top (required)>'
        from C:/tools/ruby23/lib/ruby/gems/2.3.0/gems/ruby-oci8-2.2.7-x64-mingw32/lib/oci8.rb:114:in `<top (required)>'
        from C:/tools/ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require'
        from C:/tools/ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:55:in `require'
        from C:/tools/ruby23/lib/ruby/gems/2.3.0/gems/ruby-oci8-2.2.7-x64-mingw32/lib/ruby-oci8.rb:1:in `<top (required)>'
        from C:/tools/ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:127:in `require'
        from C:/tools/ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:127:in `rescue in require'
        from C:/tools/ruby23/lib/ruby/2.3.0/rubygems/core_ext/kernel_require.rb:40:in `require'
        from (irb):4
        from C:/tools/ruby23/bin/irb.cmd:19:in `<main>'

Walter Lee Davis

unread,
Feb 12, 2019, 2:12:59 PM2/12/19
to rubyonra...@googlegroups.com
Is this your server, or your workstation? If the latter, did you install the instant client or the development package?

Walter

shashank tiwari

unread,
Feb 12, 2019, 2:15:16 PM2/12/19
to rubyonra...@googlegroups.com
I am not getting your question could you please explain me in detail

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/5C7AF4D3-9100-4970-A35C-49F4979C0BBB%40wdstudio.com.
For more options, visit https://groups.google.com/d/optout.

Walter Lee Davis

unread,
Feb 12, 2019, 2:22:09 PM2/12/19
to rubyonra...@googlegroups.com

> On Feb 12, 2019, at 9:14 AM, shashank tiwari <shasha...@gmail.com> wrote:
>
> I am not getting your question could you please explain me in detail

Is this error message coming from your production server, or your development computer (laptop/desktop)? If this is your development machine, which one of the free installer packages from Oracle did you install on that machine? I have never used Windows for anything, but I have to use Oracle for my day job, and there's a whole bunch of software that you have to install if you want to use Oracle for development. If you're using Oracle on a production server, then this question is probably best handled by your DBA. If you're using Oracle in production without hiring a DBA, you are probably going to have a very long road ahead of you.

Walter
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CA%2Bob%2BdE5n4kFnG9sKU4wsmewG97J0TsGMk4x1U4-VrU_vfE8Qg%40mail.gmail.com.

shashank tiwari

unread,
Feb 12, 2019, 2:32:11 PM2/12/19
to rubyonra...@googlegroups.com
The error is coming from my development computer. I am to connect through Oracle client but when I am trying to use Oracle in Ruby I am getting the error message.

Arup Rakshit

unread,
Feb 14, 2019, 3:02:36 PM2/14/19
to rubyonra...@googlegroups.com
Hello,

Please look into this documentation https://github.com/kubo/ruby-oci8/blob/master/docs/install-instant-client.md#windows . They mentioned what needs to be done when such error comes up.

Reply all
Reply to author
Forward
0 new messages