 |
Forums |
Admin Discussion Forums: help Start New Thread
By: Daniel Gagne
 RE: OCIInvalidHandle [ reply ]
2013-01-10 20:44
|
Hi Kubo,
It works : that user had an expired password. I uncheck the expiration for that user and it works 100%.
You saved my life,
Thank you,
Closed.
|
By: Kubo Takehiro
RE: OCIInvalidHandle [ reply ]
2013-01-10 19:22
|
Thank you.
Do you get a message "ORA-28002: the password will expire within xxx days" when you login to the Oracle server by sqlplus?
If so, it is same issue with <http://rubyforge.org/forum/message.php?msg_id=96638>.
You need to change the password, change the user's profile to extend the expiration period, or change lib/oci8/oci8.rb as follows:
ruby-oci8 2.1.0
from: if mode.nil? and cred.nil? and (not dbname.is_a? OCI8::ConnectionPool)
to: if false # mode.nil? and cred.nil? and (not dbname.is_a? OCI8::ConnectionPool)
ruby-oci8 2.1.4
from: if mode.nil? and cred.nil?
to: if false # mode.nil? and cred.nil?
If you change lib/oci8/oci8.rb, you need to change the password or change the user's profile within the expiration period.
|
By: Daniel Gagne
RE: OCIInvalidHandle [ reply ]
2013-01-10 17:23
|
Hi Kubo,
Here is the requested info.
ruby-oci8 (2.1.0)
ruby (1.9.3-p125)
Oracle instantclient-sdk-10.2.0.4.0 32 bits
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
I have tried several thing like ruby-oci8 (2.1.4) with ruby (1.9.3-p286) but I get the same error. Like I said earlier everything was running fine using the version mentionned above.
Here is the Stacktrace
oci8.c:365:in oci8lib_191.bundle
ruby-oci8 (2.1.0) lib/oci8/oci8.rb:123:in `initialize'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:319:in `new'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:319:in `new_connection'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:429:in `initialize'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:24:in `new'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:24:in `initialize'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_connection.rb:9:in `new'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_connection.rb:9:in `create'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/gems/1.9.1/bundler/gems/oracle-enhanced-5f797f053111/lib/active_record/connection_adapters/oracle_enhanced_base_ext.rb:13:in `oracle_enhanced_connection'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:304:in `new_connection'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:323:in `checkout_new_connection'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block (2 levels) in checkout'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:261:in `loop'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:261:in `block in checkout'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:260:in `checkout'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:162:in `connection'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:409:in `retrieve_connection'
composite_primary_keys (4.1.2) lib/composite_primary_keys/connection_adapters/abstract/connection_specification_changes.rb:68:in `retrieve_connection'
composite_primary_keys (4.1.2) lib/composite_primary_keys/connection_adapters/abstract/connection_specification_changes.rb:50:in `connection'
activerecord (3.1.3) lib/active_record/query_cache.rb:67:in `rescue in call'
activerecord (3.1.3) lib/active_record/query_cache.rb:61:in `call'
activerecord (3.1.3) lib/active_record/connection_adapters/abstract/connection_pool.rb:477:in `call'
actionpack (3.1.3) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
activesupport (3.1.3) lib/active_support/callbacks.rb:392:in `_run_call_callbacks'
activesupport (3.1.3) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.1.3) lib/action_dispatch/middleware/callbacks.rb:28:in `call'
actionpack (3.1.3) lib/action_dispatch/middleware/reloader.rb:68:in `call'
rack (1.3.6) lib/rack/sendfile.rb:101:in `call'
actionpack (3.1.3) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.1.3) lib/action_dispatch/middleware/show_exceptions.rb:47:in `call'
railties (3.1.3) lib/rails/rack/logger.rb:13:in `call'
rack (1.3.6) lib/rack/methodoverride.rb:24:in `call'
rack (1.3.6) lib/rack/runtime.rb:17:in `call'
activesupport (3.1.3) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.3.6) lib/rack/lock.rb:15:in `call'
actionpack (3.1.3) lib/action_dispatch/middleware/static.rb:53:in `call'
railties (3.1.3) lib/rails/engine.rb:456:in `call'
rack (1.3.6) lib/rack/content_length.rb:14:in `call'
railties (3.1.3) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.3.6) lib/rack/handler/webrick.rb:59:in `service'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run'
/Users/daniel/.rbenv/versions/1.9.3-p125/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread
Thank You.
|
By: Kubo Takehiro
RE: OCIInvalidHandle [ reply ]
2013-01-09 23:39
|
Could you post the following information?
* stacktrace of the OCIInvalidHanlde error
* ruby-oci8 version
* ruby version including patch level
* Oracle version both the server and the client up to the fifth part such as 11.0.1.0.7
|
By: Daniel Gagne
OCIInvalidHandle [ reply ]
2013-01-09 16:29
|
I have an oracle database which run on centos 5. My dev machine is a mountain lion osx. Everything was running fine for the last 2 year. Now I get a OCIInvalidHandle error so I can't connect to the database anymore. Anybody has a clue about that error ?
Thank You
|
|
|
