We don't have a lot of experience connecting to Oracle. We've done it ... once now. : )
But my policy is to blog all new code, so that if I need it again it'll be here.
So... Connecting to Oracle from .NET: