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

rubyonrails-talk
1

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

'

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

2

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?

3

after some search related to the error I happen to check this link "http://www.ruby-forum.com/topic/96884&quot; 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)

4

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

0>require 'oci8' 0>true 1>OCI8.new('username','password','database name') 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 "