# Oracle connection problem

**URL:** <https://www.ruby-forum.com/t/oracle-connection-problem/133914>\
**Category:** Rails\
**Created:** [April 4, 2008, 10:08pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/133914 "2008-04-04T22:08:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [April 4, 2008, 10:08pm UTC](https://www.ruby-forum.com/t/oracle-connection-problem/133914/1 "2008-04-04T22:08:24Z")

</div>

ORA-12154: TNS:could not resolve the connect identifier specified

I’ve updated rails to 2.0.2 and I start having a problem with oracle  
connection.

I installed activerecord-oracle-adapter, and changed oci to oracle in  
database.yml but I keep getting the oracle error  
ORA-12154: TNS:could not resolve the connect identifier specified

Can someone help me with this problem?  
Thanks.

---

<div class="post-metadata">

**Author:** ![sunfish](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/96bed5/32.png) [@sunfish](https://www.ruby-forum.com/u/sunfish)\
**Post date:** [April 21, 2008, 11:07am UTC](https://www.ruby-forum.com/t/oracle-connection-problem/133914/2 "2008-04-21T11:07:40Z")

</div>

Hi Sunny,

Do you follow the installation guide of Ruby-OCI8?  
[http://ruby-oci8.rubyforge.org/en/HowToInstall.html](http://ruby-oci8.rubyforge.org/en/HowToInstall.html)  
If so, how is your database.yml like? can you connect to the DB using  
sqlplus?  
please provide more information so we can help you solve your problem 🙂

2008/4/5, Sunny B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> ## Can someone help me with this problem? Thanks.
> 
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> >

–  
Cheers,  
Jesse