Configuring ORACLE db to rails?

Rails
1

hi everyone i’m newer to ruby on rails…for the past few days i used
default sqlite db with rails and now im in the situation to use ORACLE
db in my upcoming application…can anybody give some suggestions that
what are the tools needed to configure oracle with rails
environment…step by step manner.

~Thanks in advance

2

–
Dheeraj K.

3

Try adding ruby-oci8 before activerecord-oracle_enhanced-adapter in the
gem file. Also, I guess you’ll be fine with the basic package, but I
haven’t worked with oracle databases, so play around.

–
Dheeraj K.

4

i have tried to connect oracle by doing the procedures mentioned as
per in the above url
and here it is my gem
gem ‘activerecord-oracle_enhanced-adapter’, ‘~> 1.4.0’
gem ‘ruby-oci8’, ‘~> 2.1.0’
in that procedure they said to install oracle instant client there it
has lot of files as below
Version 11.2.0.3.0
Instant Client Package - Basic: All files required to run OCI, OCCI,
and JDBC-OCI applications
instantclient-basic-nt-11.2.0.3.0.zip (51,149,941 bytes)

*Instant Client Package - Basic Lite: Smaller version of the Basic,
with only English error messages and Unicode, ASCII, and Western
European character set support
instantclient-basiclite-nt-11.2.0.3.0.zip (20,043,020 bytes)

*Instant Client Package - JDBC Supplement: Additional support for XA,
Internationalization, and RowSet operations under JDBC
instantclient-jdbc-nt-11.2.0.3.0.zip (1,565,746 bytes)

Instant Client Package - SQLPlus: Additional libraries and
executable for running SQL*Plus with Instant Client instantclient-
sqlplus-nt-11.2.0.3.0.zip (759,693 bytes)

*Instant Client Package - SDK: Additional header files and an example
makefile for developing Oracle applications with Instant Client
instantclient-sdk-nt-11.2.0.3.0.zip (1,110,835 bytes)

*Instant Client Package - ODBC: Additional libraries for enabling ODBC
applications instantclient-odbc-nt-11.2.0.3.0.zip (740,177 bytes)

*Instant Client Package - WRC: Workload Replay Client used to replay
workload for RAT’s DB Replay Feature instantclient-tools-
nt-11.2.0.3.0.zip (12,534 bytes)

whether i have to download all those files???
but without those files when i try to connect oracle it shows

activerecord oracle_enhanced adapter could not load ruby-oci8
library…please install ruby-oci8 gem
i have used bundle install and bundle update too… but it doesnt
work’s

5

I suggest you install the following packages from Oracle. Then use the
SQLPlus to verify that the Oracle libraries you need are installed and
available to your user AND that you are able to connect to the Oracle
database with the username and password you have been given. Once you
have
connected successfully from the command line, then work on getting
RubyOCI8
working - and then the ActiveRecord adapter working

Version 11.2.0.3.0