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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
https://github.com/rsim/oracle-enhanced -- Dheeraj Kumar On Monday 24 December 2012 at 1:11 PM, rails_fan wrote:> 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 > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > For more options, visit https://groups.google.com/groups/opt_out. > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
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 - SQL*Plus: 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 On Dec 24, 2:28 pm, Dheeraj Kumar <a.dheeraj.ku...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> https://github.com/rsim/oracle-enhanced > > -- > Dheeraj Kumar > > On Monday 24 December 2012 at 1:11 PM, rails_fan wrote: > > > > > 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 > > > -- > > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > > For more options, visithttps://groups.google.com/groups/opt_out.- Hide quoted text - > > - Show quoted text --- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
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 Kumar On Tuesday 25 December 2012 at 11:36 AM, rails_fan wrote:> 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 - SQL*Plus: 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 > > > On Dec 24, 2:28 pm, Dheeraj Kumar <a.dheeraj.ku...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org (http://gmail.com)> wrote: > > https://github.com/rsim/oracle-enhanced > > > > -- > > Dheeraj Kumar > > > > On Monday 24 December 2012 at 1:11 PM, rails_fan wrote: > > > > > > > > > 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 > > > > > -- > > > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > > > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > > > For more options, visithttps://groups.google.com/groups/opt_out.- (http://groups.google.com/groups/opt_out.-) Hide quoted text - > > > > > > > > > - Show quoted text - > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org (mailto:rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org). > For more options, visit https://groups.google.com/groups/opt_out. > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
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> 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 - SQL*Plus: 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) > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/ZHC-dhDjaFkJ. For more options, visit https://groups.google.com/groups/opt_out.