Set up Oracle Connection for Ruby on Rails

gem install ruby-oci8

gem install activerecord-oracle_enhanced-adapter

8 comments on “Set up Oracle Connection for Ruby on Rails”

1. Fred on May 5, 2011 at 10:42 pm said:

   Thanks for this nice and clear HowTo.

   I still have an issue with my installation. The OCI layer is installed and works fine. The adpater seems to install correctly :
   C:railsDQEX>gem install activerecord-oracle_enhanced-adapter
   Fetching: activerecord-oracle_enhanced-adapter-1.3.2.gem (100%)
   Successfully installed activerecord-oracle_enhanced-adapter-1.3.2
   1 gem installed
   Installing ri documentation for activerecord-oracle_enhanced-adapter-1.3.2…
   Installing RDoc documentation for activerecord-oracle_enhanced-adapter-1.3.2…

   I get the RuntimeError : Please install the oracle_enhanced adapter: `gem install activerecord-oracle_enhanced-adapter` (no such file to load — active_record/connection_adapters/oracle_enhanced_adapter)

   The file is present in C:Rubylibrubygems1.9.1gemsactiverecord-oracle_enhanced-adapter-1.3.2libactive_recordconnection_adapters

   What’s wrong ?

   Thanks for your help.

   Kind regards,

   Fred

   Reply ↓
   • shanison on May 5, 2011 at 11:42 pm said:

     Hi, thanks for your comments. First, verify that your OCI is working. open your irb, and type
     require ‘rubygems’
     require ‘oci8′
     see if you get any error. if not, then try
     gem ‘activerecord-oracle_enhanced-adapter’
     see if you get any error. If any of the above steps have error, then you may wanna uninstall these gems(oci8, oracle enhanced adapter and instant client) then redo it again. Let me know if it helps.

     Reply ↓
     • Fred on May 6, 2011 at 11:13 pm said:

       Hi Shanison,
       Thanks for your help. Finally, only oracle enhanced adapter did not work, because it needs to be registered in the Gemfile of my project root (Rails 3.0).
       BR
       Fred

       Reply ↓
2. rails_fan on December 25, 2012 at 8:14 pm said:

   hi shan,
   i have problem with configuring oracle with rails i have installed everything that mentioned here and set the path too ….but it shows activerecord oracle_enhanced adapter could not load ruby-oci8 …pl install ruby-oci8 give me a solution…or kindly explain me the above steps more clear…im new one to rails so only im asking u to explain more elaborate…im using rails3 and ruby 1.9

   Reply ↓
   • shanison on December 25, 2012 at 9:18 pm said:

     Did you put the ruby-oci8 in your Gemfile? For rails 3, it is using bundler, so it will only load the Gems specified in the Gemfile.

     gem “ruby-oci8″, “>=2.0.4″
     gem “activerecord-oracle_enhanced-adapter”, “>=1.3.0″

     Reply ↓
3. rails_fan on December 27, 2012 at 1:57 pm said:

   hi shan again its me…:-)
   now i can able to connect oracle….but can’t load ruby-oci8 libraries
   while i try to run rake db:create in ror cmd prompt
   it shows rake aborted unable to load ruby-oci8 libraries.pl install ruby-oci8 gem
   kindly give me a solution

   Reply ↓
   • shanison on December 27, 2012 at 10:11 pm said:

     Ruby is using ruby-oci8 library to connect to oracle so I don’t quite understand what do you mean by you can connect oracle but can’t load ruby-oci8 library.

     You can test out if your ruby-oci8 library is working fine by running the following

     ruby -r oci8 -e “OCI8.new(‘username’, ‘pwd’).exec(‘select * from table’) do |r| puts r.join(‘,’); end”

     http://www.oracle.com/technetwork/articles/fernandez-rails-connections-101759.html

     Reply ↓
     • rails_fan on December 28, 2012 at 12:34 pm said:

       i can connect oracle means.. sql*plus (oracle) is working in my ruby and rails console window while i run rails db:console
       but when i run rake db:create it shows
       rake aborted! active record oracle enhanced adapter could not load ruby-oci8 library.so pl install ruby-oci8 gem.

       Reply ↓