# Upgrading from rails 1.1.6 to 2.3.2; problems with activerecord-oracle-adapter **URL:** \ **Category:** Rails\ **Created:** [May 16, 2009, 9:06pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146 "2009-05-16T21:06:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 16, 2009, 9:06pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/1 "2009-05-16T21:06:42Z")
## I’m upgrading from rails 1.1.6 to 2.3.2 and having problems with activerecord-oracle-adapter. Following are the ruby, rails & gems versions. “ruby script/about” has the problems. ## $ ruby -v ruby 1.8.6 (2007-09-23 patchlevel 110) [i686-linux] ## $ rails -v Rails 2.3.2 $ gem list \*\*\* LOCAL GEMS \*\*\* ## actionmailer (2.3.2) actionpack (2.3.2, 1.13.6) actionwebservice (1.2.6) activerecord (2.3.2, 1.15.6) activerecord-oracle-adapter (1.0.0.9250) activeresource (2.3.2) activesupport (2.3.2, 1.4.4) cgi\_multipart\_eof\_fix (2.5.0) composite\_primary\_keys (2.2.2) daemons (1.0.10) fastthread (1.0.7) gem\_plugin (0.2.3) mongrel (1.1.5) mongrel\_service (0.1) rails (2.3.2) rake (0.8.7) ruby-yui (0.0.5) ## $ sqlplus userid/password [works fine] edited environment.rb ##RAILS\_GEM\_VERSION = ‘1.1.6’ RAILS\_GEM\_VERSION = ‘2.3.2’ unless defined? RAILS\_GEM\_VERSION edited database.yml: ## adapter: oci ## adapter: oracle $ ruby script/about * * * ``` * config.breakpoint_server has been deprecated and has no ``` effect. \* * * * /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle- adapter-1.0.0.9250/lib/active\_record/connection\_adapters/ oracle\_adapter.rb:575: undefined method `define_a_column' for class`OCI8::Cursor’ (NameError) from /usr/local/lib/ruby/site\_ruby/1.8/rubygems/ custom\_require.rb:31:in `gem_original_require' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in`require’ from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/ active\_support/dependencies.rb:156:in `require' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/ active_support/dependencies.rb:521:in`new\_constants\_in’ from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/ active\_support/dependencies.rb:156:in `require' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 71:in`establish\_connection’ from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active\_record/connection\_adapters/abstract/connection\_specification.rb: 60:in `establish_connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 55:in`establish\_connection’ … 7 levels… from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/ commands/about.rb:1 from /usr/local/lib/ruby/site\_ruby/1.8/rubygems/ custom\_require.rb:31:in `gem_original_require' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/ custom_require.rb:31:in`require’ from script/about:3 ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 16, 2009, 9:31pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/2 "2009-05-16T21:31:20Z")
Quoting sultan [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > I’m upgrading from rails 1.1.6 to 2.3.2 and having problems with > activerecord-oracle-adapter. I really suggest you upgrade from 1.1.6 to 1.2.6 first. Rails 1.2.6 has many checks for deprecated (soon to be dropped) features. When your app runs without warnings on 1.2.6, then move to 2.x. I’d also suggest a quick stop at the latest version of 2.0.x or 2.1.x before jumping to 2.3.2. Much has changed and trying to untangle it all at once will shorten you life, your marriage (relationship), and hair coverage regardless of gender. HTH, Jeffrey ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 16, 2009, 9:48pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/3 "2009-05-16T21:48:18Z")
Don’t forget rake rails:update to update scripts, config etc. Colin 2009/5/16 Jeffrey L. Taylor [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 16, 2009, 10:24pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/4 "2009-05-16T22:24:40Z")
Hi Jeffrey & Colin, Thanks for your quick response. Just to give you a brief back ground: Currently we have the application on a “production” box where we make the client requested changes in the evenings or week-ends. We have recently got a development box where I installed ruby 1.8.6; rubygems 1.3.3; rails 2.3.2 & ruby-oci8-2.0.1. The application itself is not very large, so the changes and testing for rails 2.3.2 should not be a problem. Regarding the actual problem, I did do “rake rails:update” which was suggested when I first ran “ruby script/about”. After that, when I ran “ruby script/about” again, I got the oracle adaptor error message. Is it a gem installation, configuration or an application problem? ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 18, 2009, 10:40pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/5 "2009-05-18T22:40:27Z")
Thanks Joyce. I am a step ahead when I went to ruby-oci8 1.0.4 Now I am struggling with the following: /usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in `gem\_original\_require’: no such file to load – environments/ localization\_environment (MissingSourceFile) On May 17, 11:48 pm, Joyce Z. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [May 18, 2009, 7:48am UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/6 "2009-05-18T07:48:41Z")
Rails 2.3 does not work with ruby-oci8 2.0.0. gem install ruby-oci8 -v 1.0.4 You can find detail info at [http://wiki.rubyonrails.org/database-support/oracle](http://wiki.rubyonrails.org/database-support/oracle). ---
**Author:** ![sultan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/aeb1de/32.png) [@sultan](https://www.ruby-forum.com/u/sultan)\ **Post date:** [September 5, 2009, 10:16pm UTC](https://www.ruby-forum.com/t/upgrading-from-rails-1-1-6-to-2-3-2-problems-with-activerecord-oracle-adapter/168146/7 "2009-09-05T22:16:35Z")
sultan wrote: > Thanks Joyce. I am a step ahead when I went to ruby-oci8 1.0.4 > > Now I am struggling with the following: > /usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in > `gem\_original\_require’: no such file to load – environments/ > localization\_environment (MissingSourceFile) > > On May 17, 11:48�pm, Joyce Z. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) Did you ever solve this last problem? I am struggling with the same issue.