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, started WEBrick
in Radrails but I got this error:
ORA-12154: TNS:could not resolve the connect identifier specified
RAILS_ROOT: ./script/…/config/…
Application Trace | Framework Trace | Full Trace
env.c:257:in oci8lib.so
C:/web/IPSO/app/controllers/attending_ips_controller.rb:140:in
get_most_recent_record' C:/web/IPSO/app/controllers/attending_ips_controller.rb:26:in
new_edit’
-e:4:in `load’
-e:4
C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in initialize' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:585:in
new’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in
new_connection' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:621:in
initialize’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:35:in new' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:35:in
oracle_connection’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
262:in send' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 262:in
connection_without_query_cache=’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/query_cache.rb:54:in connection=' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 230:in
retrieve_connection’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/abstract/connection_specification.rb:
78:in connection' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/base.rb:427:in
find_by_sql’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:1101:in send' C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ action_controller/base.rb:1101:in
perform_action_without_filters’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/filters.rb:696:in call_filters' C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ action_controller/filters.rb:688:in
perform_action_without_benchmark’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/benchmarking.rb:66:in
perform_action_without_rescue' C:/ruby_prod/lib/ruby/1.8/benchmark.rb:293:in
measure’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/benchmarking.rb:66:in
perform_action_without_rescue' C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ action_controller/rescue.rb:83:in
perform_action’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:435:in send' C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ action_controller/base.rb:435:in
process_without_filters’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/filters.rb:684:in
process_without_session_management_support' C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/ action_controller/session_management.rb:114:in
process’
C:/ruby_prod/lib/ruby/gems/1.8/gems/actionpack-1.13.5/lib/
action_controller/base.rb:334:in process' C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/dispatcher.rb: 41:in
dispatch’
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb:
113:in handle_dispatch' C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb: 79:in
service’
C:/ruby_prod/lib/ruby/1.8/webrick/httpserver.rb:104:in service' C:/ruby_prod/lib/ruby/1.8/webrick/httpserver.rb:65:in
run’
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:173:in start_thread' C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:162:in
start’
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:162:in start_thread' C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:95:in
start’
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:92:in each' C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:92:in
start’
C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:23:in start' C:/ruby_prod/lib/ruby/1.8/webrick/server.rb:82:in
start’
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/webrick_server.rb:
63:in dispatch' C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands/servers/ webrick.rb:59 C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require’
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
require' C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/ active_support/dependencies.rb:495:in
require’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/
active_support/dependencies.rb:342:in new_constants_in' C:/ruby_prod/lib/ruby/gems/1.8/gems/activesupport-1.4.4/lib/ active_support/dependencies.rb:495:in
require’
C:/ruby_prod/lib/ruby/gems/1.8/gems/rails-1.2.5/lib/commands/server.rb:
39
C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require' C:/ruby_prod/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
require’
script/server:3
env.c:257:in oci8lib.so
C:/ruby_prod/lib/ruby/site_ruby/1.8/oci8.rb:229:in initialize' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:585:in
new’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:585:in
new_connection' C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/oracle_adapter.rb:621:in
initialize’
C:/ruby_prod/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/connection_adapters/oracle_adapter.rb:35:in `new’
…
…
does this mean my database.yml is not right? I am using exactly same
database.yml compare to prod box.
database.yml
development:
adapter: oracle
database: //xxxx:1521/xxxxx.xxx.org
username: xxxx_dba
password: xxxx
this setup is working fine in prod box that runs ruby 1.8.6, rails
2.1.0, and oracle instant client. The only difference that I can think
of is that prod box runs mongrel as a windows service.
am I missing something here?