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
You could maybe try to change the adapter to oracle.
What’s your version of Rails?
And the version of your Oracle driver (I had to fiddle around with that
quite a bit, though it was under linux)
ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor
Are you sure you can connect with the same credentials from Oracle
sql-developer (or any other tool creating a connection to the DB)? If
yes, probably your ruby-oracle driver has some problems…
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
All of these look odd to me. How is your Oracle networking set up? Do
you
have a tnsnames.ora file? For ‘database’, I use the connection name from
my
tnsnames.ora file.