# Rake db:migrate hanging w/ oracle

**URL:** <https://www.ruby-forum.com/t/rake-db-migrate-hanging-w-oracle/150482>\
**Category:** Rails\
**Created:** [October 9, 2008, 1:41am UTC](https://www.ruby-forum.com/t/rake-db-migrate-hanging-w-oracle/150482 "2008-10-09T01:41:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![frank\_programmer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/958977/32.png) [@frank\_programmer](https://www.ruby-forum.com/u/frank_programmer)\
**Post date:** [October 9, 2008, 1:41am UTC](https://www.ruby-forum.com/t/rake-db-migrate-hanging-w-oracle/150482/1 "2008-10-09T01:41:23Z")

</div>

When I run rake db:migrate w/ oracle it hangs on the db:schema:dump  
part and I am not sure why.

E:\work\sandbox\codeReview\>rake db:migrate --trace  
(in E:/work/sandbox/codeReview)  
\*\* Invoke db:migrate (first\_time)  
\*\* Invoke environment (first\_time)  
\*\* Execute environment  
\*\* Execute db:migrate  
\*\* Invoke db:schema:dump (first\_time)  
\*\* Invoke environment  
\*\* Execute db:schema:dump

I think I configured my database.yml correctly.

development:  
adapter: oracle  
host: sid  
#database: sid  
username: foo  
password: 12345  
timeout: 5000

Note that it doesn’t seem to matter whether I use host or database.

Also I was able to connect directly to my Oracle DB using Ruby and the  
OCI8 driver.

E:\>ruby -r oci8 -e “OCI8.new(‘foo’,‘12345’,‘sid’).exec(‘SELECT \* from  
users’) do |r| puts r.join(’ | ') ; end”

And I did install the activerecord-oracle-adapter.

Anyone know what I’m doing wrong?

---

<div class="post-metadata">

**Author:** ![frank\_programmer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/958977/32.png) [@frank\_programmer](https://www.ruby-forum.com/u/frank_programmer)\
**Post date:** [October 9, 2008, 10:14pm UTC](https://www.ruby-forum.com/t/rake-db-migrate-hanging-w-oracle/150482/2 "2008-10-09T22:14:22Z")

</div>

It turns out it is not hanging, it is just that the “Execute  
db:schema:dump” phase takes a long time. In my case it took ten  
minutes because I had a bunch of tables from other applications in my  
database.

-Frank

On Wed, Oct 8, 2008 at 4:40 PM, Frank K. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> \*\* Invoke environment  
> timeout: 5000
> 
> Anyone know what I’m doing wrong?

–  
Frank K.

> **[betweengo.com](http://ww38.betweengo.com/)**
>
> This domain may be for sale!