similar to: Ruby on Rails and Oracle

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

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

I''ve a remote database create using Oracle. This database use schemas. I tried to connect to it using Ruby On Rails,with this file Database.yml : development: adapter: oci host: liber database: ENERGIA username: user password: pass test: adapter: oci host: liber database: ENERGIA username: user password: pass production: adapter: oci host: liber database:

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 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''m using the following configuration in the database.yml to connect to Oracle, however I could not connect while the settings seems to be correct: development_oracle: adapter: oci host: 127.0.0.1:8080/XE username: rubydb password: rubyrails What is wrong here? Can anyonbe help me? -- Posted via http://www.ruby-forum.com/.

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, 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 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

> bundle exec rails s => Booting WEBrick => Rails 3.1.5 application starting in development on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server Warning: NLS_LANG is not set. fallback to US-ASCII. [2012-12-19 12:17:10] INFO WEBrick 1.3.1 [2012-12-19 12:17:10] INFO ruby 1.9.3 (2012-10-12) [x86_64-linux] [2012-12-19 12:17:10] INFO WEBrick::HTTPServer#start:

Hi My name i Lorenzo, I'm new on linux's world. I wold like to know is someone has tried to use Wine with Pro/Intralink (a PTC product). During installation...no problem. Lunching the program after installation... no results. Following, more informations: WINE Version: Wine 1.2-rc1 TERMINAL OUTPUT DURING INSTALLATION [code]icelolli at ascari:/media/PRO$ wine setup.exe icelolli at

I have been trying to connect to an Oracle database on a windows machine. I succesfully ran a test program using ODBC to connect to Oracle, but I am out of luck on doing this with rails. I am unable to install the OCI Adapter on Windows and am trying to figure it out. Meanwhile, if anyone could provide me with some pointers or references, I would be grateful. I am finding it a bit difficult in

Has anyone out there compiled R for the Umbutu Linux* (ne? Debian) v. 5.04 distribution for Intel-type platforms (32 and 64 bit) ? Thank you, Derek Eder * Umbutu, a popular new Linux distribution, not a Nigerian scam, I promise! http://www.ubuntulinux.org/ -- Derek Eder SDS KLINIKEN Vasaplatsen 8 SE 411 34 G?teborg (Gothenburg) Sweden phone: +46 (31)* - 10 77 80 fax: +46 (31)* - 10 77

ORA-12154: TNS:could not resolve the connect identifier specified I''ve updated rails to 2.0.2 and I start having a problem with oracle connection. I installed activerecord-oracle-adapter, and changed oci to oracle in database.yml but I keep getting the oracle error ORA-12154: TNS:could not resolve the connect identifier specified Can someone help me with this problem? Thanks. --

This is pretty ugly. I''m using puppet to install Oracle, ie an exec{} wrapped around: /u01/oracle_extract/linux.x64_11gR2_database/database/runInstaller -silent -responseFile /etc/oracle_response.rsp The problem is that the damn installer backgrounds itself and returns control to the shell. I tried putting the above command in a script, followed by a wait command, but that

I want to migrate my R workspace databases (e.g., .Rdata) from Windows to Linux. The R help file for "save" says that "[a]ll R platforms use the XDR representation of binary objects in binary save-d files, and these are portable across all R platforms." Is it is simple as that? Copy the Windows .Rdata file to the Linux .ext3 file system? Thanks, Derek Derek N. Eder

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

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not

Windows-32 has a time structure called FILETIME, a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC). That is not a typo, the year is 1601. Does anyone have a clue(or algorhithm)for how this is converted to something a little more POSIX-like ? Thank you, Derek -- Derek N. Eder Gothenburg University VINKLA - Vigilance and Neurocognition

Hi, Does anyone know why gem can''t find activerecord-oracle-adapter? C:\>rails --version Rails 2.0.1 C:\>gem install activerecord-oracle-adapter ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord-oracle-adapter (> 0) in any repository It all started when I tried to run Mongrel on a Win32 box: C:\web\FDS_Server>mongrel_rails start