search for: tnsname

...yntax 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 file, I can still connect using the sid name by itself. Did something change? I''ve tried it with the trunk and 0.13.1. Thanks, --Wilson. irb(main):001:0> require ''oci8'' => true irb(main):002:0> conn = OCI8.new("user", "secret", "192.1...

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''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:

....missiondata.net> Finally, my $ORACLE_HOME points to the right spot, and PATH=$PATH:/bin So everything is set up to hit the oracle server through port 1522. This ORA-12541, the misconfigured oracle listener (I assume on my local, which has already been started) in $ORACLE_HOME/network/admin/tnsnames.ora appears as: # tnsnames.ora Network Configuration File: /opt/app/oracle/product/11/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED...

Hi, Whenever i sync certain files in ( like /etc/tnsnames.ora ) from our hostA to hostB, rsync always print out /etc/ it prints out the files modified. it does that for every directory name in the path of files i update... Is there a way to suppress that output, since it is not modifying that directory ? Thanks Daniel Bourque Unix Systems Administrat...

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

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

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

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,

...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 configs so my database.yml looks like development: adapter: oracle_enhanced database: contrl username: ucontrl password: control123 after some search related to the error I happen to check this link " http://www.ruby-forum.com/topic/96884 " and followed the procedures but n...

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

I am SOOOOOOOOOOOOOO close to getting my ERP package to run. GRRR. Latest version of Codeweaver WINE, just downloaded yesterday. IE works, MSOffice works well - no icons, but still runs, including JAVA. So, WINE seems to work OK. The program is a Delphi EXE, using the BDE. I can even run BDEADMIN, but when attempting to login to the database, there is a lot of disk churning (indicating I am

...opment: > > adapter: oci > > database: <my db sid here> > > host: <my db host ip here> > > username: scott > > password: tiger > > I''ve found the host parameter should be the name of the entry for the > database you want in your tnsnames.ora file. The database parameter > seems to be ignored. > > So, try setting host to what you had as <my sid here> in your manual > OCI8.new call and it should work. > > -d. > > > ------------------------------ -- ______________________________________________...

...er.rb:585:in `new'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_recor d/connection_adapters/oracle_adapter.rb:585:in `new_connection'' I''ve done a bunch of google searches on this. I read if I am using instant client I don''t need a tnsnames.ora file, which I''m not that familiar with that file anyway. Any ideas on this let me know, it has not been as easy as I''ve hoped for this. ################################### require ''active_record'' ActiveRecord::Base.establish_connection( :adapter => &...

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

Afternoon all. I''ve been reading around on Puppet and Oracle, and have come up with a few links that suggest how to get Oracle installed and base configured, which has got me started in the right direction on that. My next challenge is maintaining Oracle database specific configuration on the relevant hosts. This contains various elements, such as /etc/oratab, /etc/oranfstab (as

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