# Rails 2.0.1 RC2 - activerecord-oracle-adapter not found **URL:** \ **Category:** Rails\ **Created:** [December 14, 2007, 11:55am UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142 "2007-12-14T11:55:10Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 14, 2007, 11:55am UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/1 "2007-12-14T11:55:10Z")
Hi, Does anyone know why gem can’t find activerecord-oracle-adapter? C:\>rails --version Rails 2.0.1 C:\>gem install activerecord-oracle-adapter ERROR: While executing gem … (Gem::GemNotFoundException) Could not find activerecord-oracle-adapter (\> 0) in any repository It all started when I tried to run Mongrel on a Win32 box: C:\web\FDS\_Server\>mongrel\_rails start -e production -p 4001 \*\* Starting Mongrel listening at 0.0.0.0:4001 \*\* Starting Rails with production environment… c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active\_record/connection\_adapters/abstract/connection\_specificatio n.rb:231:in `establish_connection': Please install the oracle adapter:`gem install activerecord-oracle-adapter` (no suc h file to load – active\_record/connection\_adapters/oracle\_adapter) (RuntimeError) I installed ruby-oci8 and I’m able to communicate with the Oracle database located on a remote machine via: ruby -r oci8 -e “OCI8.new(‘id’, ‘password’, ‘???.???.?.?/xe’).exec( ‘SELECT \* FROM THINGS WHERE ID=7’) do |r| puts r.join(’ | '); end” The weird thing is that activerecord-oracle-adapter isn’t present on my development machine… and the application works fine with Mongrel there. Thanks, Chris. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 14, 2007, 12:10pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/2 "2007-12-14T12:10:13Z")
One extra piece of information: on the production machine, I see no oracle\_adapter.rb in C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.1\lib\active\_record\connection\_adapters but there is one on my development machine (running Rails 1.2.6.)… Chris. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 14, 2007, 3:27pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/3 "2007-12-14T15:27:53Z")
OK, the guys on the Rails France forum told me DHH was in Paris and didn’t have time to put the file on RubyForge… So in the mean time, I installed Rails 1.2.6 and was able to get my Production Mongrel running. Unfortunately, I get an [ORA-12154: TNS:could not resolve the connect identifier specified] error message as soon as the server code tries to connect to the remote Oracle database. I installed Instant Client, so there is no TNSNAMES.ORA file. Instead, I thought putting the remote IP address of the Oracle server in database.yml, next to “host:” would do the trick… What am I missing? Thanks, Chris. P.S.: there is no such thing as Rails 2.0.1 RC2, I got mixed up with Ruby 186-26 RC2… ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 14, 2007, 3:43pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/4 "2007-12-14T15:43:50Z")
I even tried adding “port: 1521” to database.yml, to no avail… ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 14, 2007, 4:28pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/5 "2007-12-14T16:28:00Z")
This is what finally worked: database: ???.???.?.?:1521/xe Chris. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 20, 2007, 2:42am UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/6 "2007-12-20T02:42:57Z")
Hi Chris, Rails 2.0 and later do not ship with Oracle adapter. You can install the latest Oracle adapter via gem: gem install activerecord-oracle-adapter or check it out from svn: svn co [http://svn.rubyonrails.org/rails/adapters/oracle/lib/active\_record/connection\_adapters/](http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/) 2007/12/14, Chris Gers32 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > – Regards, Jesse ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 20, 2007, 11:38am UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/7 "2007-12-20T11:38:18Z")
Hi Jesse, I ended up upgrading to RubyGems 1.0.0 and Rails 2.0.2, but getting the Oracle adapter via “gem install activerecord-oracle-adapter” still isn’t working… So I got it from the SVN repository, like you suggested. Unless it’s a problem on the Rails side, I wish I knew why I can’t use “gem install”… Thanks, Chris. Jesse Hu wrote: > Hi Chris, > > Rails 2.0 and later do not ship with Oracle adapter. > You can install the latest Oracle adapter via gem: > gem install activerecord-oracle-adapter > or check it out from svn: > svn co > [http://svn.rubyonrails.org/rails/adapters/oracle/lib/active\_record/connection\_adapters/](http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/) > > 2007/12/14, Chris Gers32 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > > > > > – > Regards, > Jesse ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 20, 2007, 2:21pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/8 "2007-12-20T14:21:16Z")
I found this on the Nabble forum (thanks, Jean-François…) : gem install activerecord-oracle-adapter --source [http://gems.rubyonrails.org](http://gems.rubyonrails.org) It finally works! ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [January 9, 2008, 11:25pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/9 "2008-01-09T23:25:24Z")
Chris Gers32 wrote: > I found this on the Nabble forum (thanks, Jean-François…) : > > gem install activerecord-oracle-adapter --source > [http://gems.rubyonrails.org](http://gems.rubyonrails.org) > > It finally works! Didn’t work for me on Windows with Rails 2.0.2 and Gem 1.0.1… ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [December 20, 2007, 12:21pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/10 "2007-12-20T12:21:58Z")
No, the idea is that you’re supposed to install them as plugins, afaik. On Dec 20, 2007 9:08 PM, Chris Gers32 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Thanks, > > > svn co > > Regards, > > Jesse > > – > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). > > > – Ryan B. > **[frozenplague.net](http://www.frozenplague.net)** > > This domain may be for sale! ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [January 10, 2008, 8:26am UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/11 "2008-01-10T08:26:02Z")
Could it be due to a temporary problem (server unavailable)? I’ve been experimenting with installing the whole Ruby/Rails stack in different OSs (Vista, XP, Win 2003) and works every time, with Rails 2.0.2 and Gems 1.0.1. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [January 16, 2008, 3:11pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/12 "2008-01-16T15:11:16Z")
Owen Dall wrote: > Chris Gers32 wrote: > > > I found this on the Nabble forum (thanks, Jean-François…) : > > > > gem install activerecord-oracle-adapter --source > > [http://gems.rubyonrails.org](http://gems.rubyonrails.org) > > > > It finally works! > > Didn’t work for me on Windows with Rails 2.0.2 and Gem 1.0.1… If the above solution didn’t work for you try updating your [ruby-oci8 library](http://rubyforge.org/projects/ruby-oci8/ "ruby-oci8"), another resource that I found to be very helpful was this post at [Foliosus.com](http://www.foliosus.com/2007/11/19/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-mac-osx-105/ "oracle\_with\_rails\_2.0"), although its focus is the Mac/Leopard setup, it provided enough insight to get oracle working for me on both \*nix and windows environments. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [March 13, 2011, 8:24pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/13 "2011-03-13T20:24:27Z")
Can anyone please provide me activerecord-oracle-adapter.gem file. I no longer find it i the rubysource website. Also im doing this install from local respository versus using gem source repository over internet as I am behind a firewall on the linux server Regards ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [January 9, 2008, 11:29pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/14 "2008-01-09T23:29:27Z")
Owen Dall wrote: > Chris Gers32 wrote: > > > I found this on the Nabble forum (thanks, Jean-François…) : > > > > gem install activerecord-oracle-adapter --source > > [http://gems.rubyonrails.org](http://gems.rubyonrails.org) > > > > It finally works! > > Didn’t work for me on Windows with Rails 2.0.2 and Gem 1.0.1… I moved this in by had to: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active\_record\connection\_adapters ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [March 13, 2011, 9:04pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/15 "2011-03-13T21:04:20Z")
Frederick C. wrote in post #987224: > On Mar 13, 7:24pm, Sanjeev Me [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > > Can anyone please provide me activerecord-oracle-adapter.gem file. I no > > longer find it i the rubysource website. Also im doing this install from > > local respository versus using gem source repository over internet as I > > am behind a firewall on the linux server > > I think these days you want the activerecord-oracle\_enhanced-adapter > gem > > Fred Fred - I have installed that but I am trying to create sample application per [http://www.oracle.com/technetwork/articles/haefel-oracle-ruby-089811.html](http://www.oracle.com/technetwork/articles/haefel-oracle-ruby-089811.html) and created comics app however when I access it giving errors saying it needs activerecord-oracle-adapter. ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [March 13, 2011, 9:04pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/16 "2011-03-13T21:04:30Z")
On Sun, Mar 13, 2011 at 2:54 PM, Frederick C. \< removed\_email\_address@domain.invalid\> wrote: > Fred Agreed. The gem you are looking for is really old and has been replaced by activerecord-oracle\_enhanced-adapter gem. B.\*\* ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [March 13, 2011, 8:56pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/17 "2011-03-13T20:56:19Z")
On Mar 13, 7:24pm, Sanjeev Me [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Can anyone please provide me activerecord-oracle-adapter.gem file. I no > longer find it i the rubysource website. Also im doing this install from > local respository versus using gem source repository over internet as I > am behind a firewall on the linux server I think these days you want the activerecord-oracle\_enhanced-adapter gem Fred ---
**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\ **Post date:** [March 13, 2011, 9:40pm UTC](https://www.ruby-forum.com/t/rails-2-0-1-rc2-activerecord-oracle-adapter-not-found/123142/18 "2011-03-13T21:40:12Z")
Bryan C. wrote in post #987228: > On Sun, Mar 13, 2011 at 2:54 PM, Frederick C. \< > removed\_email\_address@domain.invalid\> wrote: > > > Fred > > Agreed. The gem you are looking for is really old and has been replaced > by activerecord-oracle\_enhanced-adapter gem. > > B.\*\* Figured out the issue. Changed oracle to oracle\_enhanced in database.yml file and was ok after that. Regards, Sanjeev.