similar to: Connecting to Oracle

Hi, Environment: Solaris 10, Orale 10g, Apache 2.2, Ruby 1.8.4, Rails 1.2.3, Ruby OCI8 1.0.0-rc2 As soon as I compiled and installed the Ruby/OCI8 interface, I got the following error from my application: ========================= [notice] mod_fcgid: call /export/home/invido/invido/portal2/public/ dispatch.fcgi with wrapper /usr/local/bin/ruby /export/home/invido/

I feel stupid having to ask this, but I haven''t found an answer. I installed ruby-oci8 in order to load data from an oracle db into postgres (part of a jsp to rails conversion). In order to run my ruby script I know I need to set ORACLE_HOME and LD_LIBRARY_PATH environment variables to get it to work (and it does work). I''ve tried setting ENV[''ORACLE_HOME'']

Here''s a solution to the OCI8 problem shown below (change /usr/local/oracle to your site''s oracle): If this happens when you are running scripts at the shell prompt: export LD_LIBRARY_PATH=/usr/local/oracle/lib If this happens in your apache error_log, add to httpd.conf: SetEnv LD_LIBRARY_PATH /usr/local/oracle/lib Kevin Kleinfelter If it''s not documented,

Hi, I''m having problems running my rails application in the following setup Unix/Apache/FastCgi/Oracle10g. I had my app running quite happy until I installed the OCI8 driver. When I try to load the app I get in the apache logs the famous "undefined method ''define_a_column'' for class OCI8:Cursor (NameError)" I think the problem is with the fastcgi set up

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

Hello, Got Ruby 1.8.2, RAILS 1.0, Windows2kx and Ruby-OCI8.mswin (1.1.3) I try a migration test drive for one legacy DB from an original Ora win32 8.1.7 server to a better hardware running Win32 Oracle 9.2. The two DB have 99,999% identical datas. My rails app run on a independant serveur (W2003) using an Oracle Client 8.1.7. I''ve the same results using IIS/FastCgi or script/server

Hi All, I have a problem in connecting to oracle and here is the steps i''ve been going through (i''m using the regular oracle8 client, not the instant one): 1. i installed the one-click ruby installer (ruby184-16p3 windows.exe) 2. i installed the rails-1.0.0 framework using gem successfully 3. i tried connecting to oracle using all possible combination in the database.yml file

I''m trying to get ActiveRecord working with an Oracle DB over the instant client. On a 32bit machine, I can require ''oci8'': Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST 2009 i686 i686 i386 GNU/Linux irb(main):001:0> require ''oci8'' => true However, on a 64bit machine: Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue

I installed Ruby, Rails (using gems install rails -v 1.0.0 --remote), the OCI driver for windows to access Oracle (C:\> ruby ruby-oci8-0.1.13-mswin.rb). I create a an application in rails (C:\> rails tabella) I have a table called tabella in Oracle in the RAILSDB database. I modify my database.yml to read: development: adapter: oci username: ruby password: ruby host: RAILSDB I

I am trying to connect to an older oracle DB remotely, I think version 8 or 9. I downloaded the instant client stuff from oracle and copied oci.dll and oraociei10.dll to my windows/system folder (windows XP) I get the error. C:\rb-play>ar_connect_ss.rb env.c:257:in oci8lib.so: ORA-12514: TNS:listener does not currently know of serv ice requested in connect descriptor (OCIError) from

Has anyone looked into having ActiveRecord use Oracle bind vars? I don''t know if the same concept is supported in other dbs, but Oracle''s OCI driver supports late binding with dramatically improved performance. I did a quick test to confirm that I could expect the same performance improvement through the Ruby OCI8 driver, and in a simple test it looks to be a 5x improvement.

hi I have the latest rails version and would like to connect to an Oracle 9 database: this is my code: ========= ActiveRecord::Base.establish_connection( :adapter => "oci", :host => "host", :username => "user", :port => 1888, :password => "passwd", :database => "tmp1" ) class

Hi I have looked at google about this error as well as in ruby on rails forums, but I can not specifically locate the exact problem and the solution for it. Basically, I successfully installed ruby 1.8.4 on HP-UX 11.11 with rails gem. But unfortunately whenever I try to create a test application by using "rails testapp", I am getting the follwing errror: $ rails testapp

Hello folks. I''m new in Ruby also ROR. I installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But its got some error. like this *custom_require.rb:36:in `require'': cannot load such file -- oci8 (LoadError)* my code is here. require ''oci8'' oci =

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

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

Hi Guys, I?m getting this error with mongrel_cluster. I am able to start mongrel through mongrel_rails start but the cluster is not working. Initially mongrel_rails wouldn?t work but after I added $ORACLE_HOME and $PD_LIBRARY_PATH variables it worked but mongrel_cluster isn?t working still. The mongrel log file looks like below. Any help is appreciated. Thanks. -----------begin

I am attempting to connect to ORACLE11g however i am getting the following error: "OCI Library Initialization Error" IT always errors on OCIENV.init(). I cant see anything wrong on the ENV configurations. Has anyone had this problem, or any suggestions on where i should look for anwers? I am using the following gems: ruby-oci8 (1.0.4) activerecord-oracle-adapter (1.0.0.9250)

My company''s System-admin installed Ruby and Gems (using Sun Coolstack package) and I have sudo access to ruby, gem etc. Now I need to get my app to talk to oracle db (through network). From what I understand, it requires three steps: Step 1: Install oracle instant client ( I installed it in my ~/oracle/ instantclient_11_1) Step2: Install OCI8 libraries (this is where I am stuck). Here is

I have written the small script below. I have the ruby-oci adapter installed, the newest version of gems and the newest version of ActiveRecord. When I run the code I''m getting the follow error following my code. It seems to be an issue with gems as far as I can tell. Any help? Thanks, Drew Code: require ''ruby_gems'' require ''active_record''