I've started a project using Oracle database and ODP.NET as the provider. I've faced some issues, which are commonly asked about here( in the forums).

I documented everything I faced and learned here: http://walaapoints.blogspot.com/2007/06/odpnet-llblgen-pro.html

Hope this can help others taking the same road.

For v3, this is no longer necessary: just install ODP.NET 10g or higher