similar to: Oracle connection problem

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

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

I searched this site on Oracle && MySql, nothing came up, so perhaps this is a new topic for this forum. I''d like to access two databases from the same application simultaneously (well, more precisely, in rapid succession, calling one first and then the other, as any "joins" will be done in the application code). One database is in MySql, the other is Oracle.

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

Hi, I am running the 64bit version of R on a AIX RS6000 cluster on which is also running the ' SQL*Plus: Release 9.2.0.2.0' in the 'ORACLE-environment Version 64 bit AIX 5.1'. I have problems setting up an Oralce database connection. I can instantiate a driver using drv <- Oracle(). But when I try to connect to my database using dbConnect (dbConnect(drv,

Hi, After a few days of struggling, I was able to run this command successfully. ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/ xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}" I got "1.0" as output and I got my prompt back. So, I went back to the RoR app that I am working on,

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

Hi I am a new to ROR and learning this framework from various tutorials. I have my new application and had the rails generate scaffold get going but after this when I first ran the rake db:migrate I got this ERROR! ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIError) I''m using database which is on a server and have used the tnsnames.ora

i''m working on ubuntu 11.04; i need to create some rails application with oracle database on local computer. i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6, gem ''activerecord-oracle_enhanced-adapter'', create database user named ''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked new application

Hi folks, Does anyone know how to install the OCI8 ruby interface on Debian64 without having to install Oracle? My understanding, from experience with Debian i386, is that you need Oracle (specifically the SQLPlus) installed to be able to compile OCI8. Since my new dev machine is AMD64 running Debian, I''m stuck. My rails applications need to connect to a remote Oracle 10g, but cannot

Hello, I''m having a trouble when I try to connect RoR and Oracle. I believe that it has something to do with database.yml, this is how my database.yml looks: development: adapter: oci database: 127.0.0.1:1521/XE username: system password: y1984nip0359 host: 127.0.0.1 And this is the Error that i get: -> http://127.0.0.1:3000/blog OCIError in BlogController#index

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

Is rails + oci8 + mac os x intel a winning combination? It appears that oci8 might be a issue.

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

Hi all, I have confgured my oracle application with the Oracle Express Production release database. This all is configured well and tested(I can see that he founds the database). However, when I generate a scaffold application there is no view for the CRUD functions created for the application. Below is listed what is generated for me for a Products table: E:\workdir\ruby\depot>ruby

i have rails-2.1.0 my database.yml development: adapter: oracle database: pe username: or password: or >rake db:create >rake db:version --->Current version: 0 >rake db:migrate rake aborted! ORA-12154: TNS:could not resolve the connect identifier specified (See full trace by running task with --trace) is above idea is possible, then how ? and i thing i should give service

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 =

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

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

Gurus... If I set up my project to use SQLite (so it can come up) and attempt to connect to oracle via: oracle_connect = $application_properties[$connect_string] oracle_conn = OCI8.new(oracle_id, oracle_password, oracle_connect) where oracle_connect equals ''//bobs.big.boy.gov:1521/D09'' (with or w/o the introductory //) my rails app connect to the oracle database just fine. If