# I can only halfway connect to oracle

**URL:** <https://www.ruby-forum.com/t/i-can-only-halfway-connect-to-oracle/183018>\
**Category:** Rails\
**Created:** [February 6, 2010, 6:48am UTC](https://www.ruby-forum.com/t/i-can-only-halfway-connect-to-oracle/183018 "2010-02-06T06:48:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cristie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@cristie](https://www.ruby-forum.com/u/cristie)\
**Post date:** [February 6, 2010, 6:48am UTC](https://www.ruby-forum.com/t/i-can-only-halfway-connect-to-oracle/183018/1 "2010-02-06T06:48:52Z")

</div>

Gurus…

If I set up my project to use SQLite (so it can come up) and attempt to  
connect to oracle via:

oracle\_connect = $application\_properties[$connect\_string]  
oracle\_conn = OCI8.new(oracle\_id, oracle\_password, oracle\_connect)

where oracle\_connect equals ‘[//bobs.big.boy.gov:1521/D09](https://bobs.big.boy.gov:1521/D09)’ (with or w/o  
the introductory //) my rails app connect to the oracle database just  
fine.

If I convert my database.yml file to point to oracle however with the  
following config:

development:  
adapter: oracle  
database: pst\_development  
password:  
host: [bobs.big.boy.gov:1521/D09](http://bobs.big.boy.gov:1521/D09) #with or w/o the introductory //  
username: foo  
password: foo

When I try and run my initial migration to get setup I see the following  
error:

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

Help please!