Rails - Dec 2010 - ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIEr

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
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
now I am stuck with the below error

C:\Documents and
Settings\SawanKumar.Thammadi\RubyOnRails\datamanger>rake db:migrate
(in C:/Documents and
Settings/SawanKumar.Thammadi/RubyOnRails/datamanger)
rake aborted!
OCI Library Initialization Error
oci8lib.c:98:in oci8lib_191.so
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:239:in
`r
equire''
.
.
.
C:/Ruby192/lib/ruby/gems/1.9.1/gems/ruby-oci8-2.0.4-x86-mingw32/lib/oci8.rb:23:in
`<top (required)>''
.
.
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/con
nection_adapters/oracle_enhanced_oci_connection.rb:4:in `<top
(required)>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:239:in
`r
equire''
.
.
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/con
nection_adapters/oracle_enhanced_connection.rb:114:in `<top
(required)>''
.
.
.
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/con
nection_adapters/oracle_enhanced_adapter.rb:36:in `<top
(required)>''
.
.
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/activerecord-orac
le_enhanced-adapter.rb:12:in `block in
<class:OracleEnhancedRailtie>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/lazy_load_hooks.rb:42:in
`each''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_record/base.rb:1891:in
`<top (requ
ired)>''
C:/Documents and
Settings/SawanKumar.Thammadi/RubyOnRails/datamanger/config/initializers/active_reco
rd.rb:1:in `<top (required)>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:235:in
`l
oad''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:235:in
`b
lock in load''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:225:in
`b
lock in load_dependency''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:596:in
`n
ew_constants_in''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:225:in
`l
oad_dependency''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:235:in
`l
oad''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/engine.rb:201:in
`block (2 levels) in <
class:Engine>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/engine.rb:200:in
`each''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/engine.rb:200:in
`block in <class:Engin
e>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/initializable.rb:25:in
`instance_exec''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/initializable.rb:25:in
`run''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/initializable.rb:50:in
`block in run_in
itializers''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/initializable.rb:49:in
`each''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/initializable.rb:49:in
`run_initializer
s''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/application.rb:134:in
`initialize!''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/application.rb:77:in
`method_missing''
C:/Documents and
Settings/SawanKumar.Thammadi/RubyOnRails/datamanger/config/environment.rb:5:in
`<to
p (required)>''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/application.rb:103:in
`require''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/application.rb:103:in
`require_environm
ent!''
C:/Ruby192/lib/ruby/gems/1.9.1/gems/railties-3.0.3/lib/rails/application.rb:216:in
`block in initial
ize_tasks''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `call''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `block in execute''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `each''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `execute''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:595:in `block in
invoke_with_call_chain''
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:605:in `block in
invoke_prerequisites''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:602:in `each''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:602:in `invoke_prerequisites''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:594:in `block in
invoke_with_call_chain''
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:581:in `invoke''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2041:in `invoke_task''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block (2 levels) in
top_level''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `each''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block in top_level''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2013:in `top_level''
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1992:in `run''
C:/Ruby192/bin/rake:31:in `<main>''

Please help me anyone!!!!!

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

> ORA-12514:
> TNS:listener d
> oes not currently know of service requested in connect descriptor
> (OCIError)
Just a guess... Is it possible that your database name is misspelled
compared to the contents of TNSNAMES.ORA?

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

> 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
> now I am stuck with the below error
>
> C:\Documents and
> Settings\SawanKumar.Thammadi\RubyOnRails\datamanger>rake db:migrate
> (in C:/Documents and
> Settings/SawanKumar.Thammadi/RubyOnRails/datamanger)
> rake aborted!
> OCI Library Initialization Error
> oci8lib.c:98:in oci8lib_191.so
>
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:239:in
> `r
> equire''
Have you installed the ruby-oci8 gem? (http://ruby-oci8.rubyforge.org/
en/InstallBinaryPackage.html)

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

pepe wrote in post #968708:
>>
> 
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:239:in
>> `r
>> equire''
>
> Have you installed the ruby-oci8 gem? (http://ruby-oci8.rubyforge.org/
> en/InstallBinaryPackage.html)
"Hi Thanks for the reply I have found the problem. When I was trying to 
connect to the database I tried
irb>
irb>0>require ''oci8''
irb>0>true
irb>1>OCI8.new(''username'',''password'',''database
name'')
irb>1>OCI8(databsename)

the above confirmed that the tns names were working but the when I run 
the rake db:migrate it still says the listener did not recognize the 
service name. Then I looked into the oracle_enhanced_oci_connection.rb 
the connection according to TNS alias was pretty much trying to grab the 
dynamic value I believe from the database.yml then I tried to change the 
connection query
##conn = OCI8.new username, password, connection_string, privilege

        conn =
OCI8.new(''username'',''password'',''databasename'')
and executed the command rake db:migrate it made the connection and 
migration was successful

I still do not understand why it happened and is their any permanent 
solution "

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.