# Problem with Active Record and Oracle using oracle\_enhanced adapter

**URL:** <https://www.ruby-forum.com/t/problem-with-active-record-and-oracle-using-oracle-enhanced-adapter/137504>\
**Category:** Ruby\
**Created:** [May 13, 2008, 7:12pm UTC](https://www.ruby-forum.com/t/problem-with-active-record-and-oracle-using-oracle-enhanced-adapter/137504 "2008-05-13T19:12:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pabloq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ec9cab/32.png) [@pabloq](https://www.ruby-forum.com/u/pabloq)\
**Post date:** [May 13, 2008, 7:12pm UTC](https://www.ruby-forum.com/t/problem-with-active-record-and-oracle-using-oracle-enhanced-adapter/137504/1 "2008-05-13T19:12:42Z")

</div>

Hi,

I’m having problem connecting activerecord and ruby with oracle\_enhanced  
adapter. I’m running this script directly in the machine with the DB.  
This  
is the example that I’m trying to run:

require ‘rubygems’  
require ‘active\_record’

ActiveRecord::Base.establish\_connection(  
:adapter =\> “oracle\_enhanced”,  
:username =\> “_**",  
:password =\> "**",  
:host =\> "127.0.0.1/_\*\*\*”)

class Testing \< ActiveRecord::Base  
set\_table\_name “idm\_test\_tables”  
set\_primary\_key “deptno”  
end

temp = Testing.new

I’m receiving this:

env.c:257:in oci8lib.so: ORA-12560: TNS:protocol adapter error  
(OCIError)  
from c:/ruby/lib/ruby/site\_ruby/1.8/oci8.rb:229:in `initialize' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.1.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:692:in`new’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-oracle\_enhanced-adapter-1.1.0/lib/active\_record/connection\_adapters/oracle\_enhanced\_adapter.rb:692:in  
`new_connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.1.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:728:in`initialize’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-oracle\_enhanced-adapter-1.1.0/lib/active\_record/connection\_adapters/oracle\_enhanced\_adapter.rb:46:in  
`new' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.1.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:46:in`oracle\_enhanced\_connection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:291:in  
`send' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:291:in`connection=’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:259:in  
`retrieve_connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in`connection’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1080:in  
`columns' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:2363:in`attributes\_from\_column\_definition\_without\_lock’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/locking/optimistic.rb:55:in  
`attributes_from_column_definition' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1922:in`initialize’  
from test\_activerecord\_oracle.rb:19:in `new’  
from test\_activerecord\_oracle.rb:19

Tool completed with exit code 1

It seems that I’m having problem with the connection but I’m already try  
connecting with sqlplus with the same SID and it works. I’m on a windows  
machine, with oracle 11g. Does anyone know what I’m doing wrong?

---

<div class="post-metadata">

**Author:** ![pabloq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ec9cab/32.png) [@pabloq](https://www.ruby-forum.com/u/pabloq)\
**Post date:** [May 13, 2008, 9:42pm UTC](https://www.ruby-forum.com/t/problem-with-active-record-and-oracle-using-oracle-enhanced-adapter/137504/2 "2008-05-13T21:42:27Z")

</div>

I found the problem, It don’t support this syntax:

:host =\> ‘/’

It must be in this way:

:host =\> ‘’ ,  
:database =\> ‘’

so, this is the correct way:

ActiveRecord::Base.establish\_connection(  
:username =\> “pabloq”,  
:password =\> “db345”,  
:host =\> “127.0.0.1”,  
:database =\> ‘’)

2008/5/13 Pablo Q. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

---

<div class="post-metadata">

**Author:** ![pabloq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ec9cab/32.png) [@pabloq](https://www.ruby-forum.com/u/pabloq)\
**Post date:** [May 19, 2008, 7:38am UTC](https://www.ruby-forum.com/t/problem-with-active-record-and-oracle-using-oracle-enhanced-adapter/137504/3 "2008-05-19T07:38:56Z")

</div>

:database =\> ‘localhost/’ should work too.

2008/5/14 Pablo Q. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):