Connecting to Oracle from Rails 2.0.2

Long afternoon, but finally got it. Hope this spares you some pain:

Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm

Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip instantclient-basic-OS-VERSION.zip unzip instantclient-sdk-OS-VERSION.zip unzip instantclient-sqlplus-win32-11.1.0.6.0.zip

Append the following value to your system path: C:\oracle\instantclient_11_1

Download the following file: http://rubyforge.org/frs/?group_id=256 Run the following from the command prompt: c:\where you saved file>"ruby ruby-oci8-1.0.0-mswin32.rb" Answer "Yes"

Assuming that you have previously installed rails 1.x, copy the oracle adapters manually from: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb to:

C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters and rename it to oci_adapter.rb

Copy the ora.dll & oraociei11.dll from C:\oracle\instantclient_11_1 to c:\ruby\bin

Edit your database.yml to read:

development:   adapter: oci   host: <your db host>:<your db port>/<your db sid>   username: <uid>   password: <pwd>

go to http://localhost:3000 expand "About your application's environment" the Database adapter should read: oci

good luck. Next up, trying to get this to work on OSX & Linux. weee, the fun!

Silvio Galea wrote:

Assuming that you have previously installed rails 1.x, copy the oracle adapters manually from: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb to:

C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters and rename it to oci_adapter.rb

Alternatively, get the new adapter for Rails 2: http://gems.rubyonrails.org/gems/activerecord-oracle-adapter-1.0.0.gem Then run: gem install activerecord-oracle-adapter -l

and use "oracle" as the adapter...

More convenient way to install the Oracle adapter : gem install activerecord-oracle-adapter --source http://gems.rubyonrails.org or check it out from svn: svn co http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/ since Rails 2.0 will not ship with Oracle adapter.