Displaying 19 results from an estimated 19 matches for "tnsnames".
Did you mean:
dnsnames
2005 Jul 27
7
Oracle OCI8, or "am I going crazy?"
...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.16...
2006 Mar 28
2
Rails Oracle connection
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/.
2006 Feb 20
2
Oracle & Ruby on Rails
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:
2012 Dec 19
0
Oracle listner with port forwarding issue
....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)...
2004 Aug 11
2
possible suppression for output ?
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 Administrato...
2011 Nov 19
11
Installing Oracle
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
2006 May 16
4
Oracle and MySql simultaneously from rails app
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.
2007 Oct 23
3
Ruby on Rails and 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
2010 Jun 01
12
Wine & Pro/Intralink
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
2010 Apr 27
3
"ORA-12154: TNS:..." error after successful oracle connection
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,
2010 Dec 15
3
ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIEr
...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
no...
2005 Dec 28
2
OCI/ODBC on Windows
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
2002 Aug 29
1
Oracle 8.1.7 client
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
2005 Apr 25
0
Oracle connection problem: rails ok!
...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.
>
>
> ------------------------------
--
_______________________________________________...
2007 Nov 15
0
Problems connecting to remote Oracle DB on windows using active record
...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 => ...
2006 Mar 28
2
Problem with generating a scaffold with an Oracle DB
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
2011 Sep 02
3
problems with oracle xe server connection
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
2012 Oct 24
13
Puppet & Oracle Database config management
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
2007 Dec 14
17
Rails 2.0.1 RC2 - activerecord-oracle-adapter not found
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