# OCIError (ORA-01017: invalid username/password; login denied

**URL:** <https://www.ruby-forum.com/t/ocierror-ora-01017-invalid-username-password-login-denied/177592>\
**Category:** Rails\
**Created:** [October 20, 2009, 5:45pm UTC](https://www.ruby-forum.com/t/ocierror-ora-01017-invalid-username-password-login-denied/177592 "2009-10-20T17:45:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![atiaxi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/74df32/32.png) [@atiaxi](https://www.ruby-forum.com/u/atiaxi)\
**Post date:** [October 20, 2009, 5:45pm UTC](https://www.ruby-forum.com/t/ocierror-ora-01017-invalid-username-password-login-denied/177592/1 "2009-10-20T17:45:31Z")

</div>

We’re trying to deploy our system on a separate server and have run into  
nothing but trouble; specifically I get the error mentioned in the  
subject. The username/password combo is correct (I verified it via  
SQL+). Manually running script/server works fine in production or  
development mode. Heck, running script/console also works fine. It’s  
just that when it automatically starts up as part of server startup that  
I get this error; it’s unfortunately exactly that situation that we need  
to use it.

My database.yml looks like:

development:  
adapter: oracle\_enhanced  
database: blarg  
username: abcde  
password: abcde

production:  
adapter: oracle\_enhanced  
database: blarg  
username: abcde  
password: abcde

I’ve googled all over the place for answers to this but all I find are  
threads where somebody has the problem and nobody has a solution. Any  
help is welcome!

---

<div class="post-metadata">

**Author:** ![atiaxi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/74df32/32.png) [@atiaxi](https://www.ruby-forum.com/u/atiaxi)\
**Post date:** [October 20, 2009, 7:42pm UTC](https://www.ruby-forum.com/t/ocierror-ora-01017-invalid-username-password-login-denied/177592/2 "2009-10-20T19:42:36Z")

</div>

On Tue, Oct 20, 2009 at 10:45 AM, Roger Ostrander  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> We’re trying to deploy our system on a separate server and have run into  
> nothing but trouble; specifically I get the error mentioned in the  
> subject.

When I deploy to production using Oracle, I have to set two  
environment variables:

LD\_LIBRARY\_PATH=/usr/local/lib  
ORACLE\_HOME=/home/oracle

–  
Greg D.  
[http://destiney.com/](http://destiney.com/)