Hmm, let me make some assumptions here:
You have an app that opens a connection to the db.
This connection does not in itself do anything.
This connection occasionally fails when trying
You are not using the
form to do something on this connection.
You are using all the latest versions of MDAC and the oracle OLEDB Provider.
You are not trying something new on the connection e.g. testing a new dataset, executing a brand-new query or connecting to a different server etc.
Try swapping the oracle provider for the Microsoft version "MSDAORA"
There are two secrets to success in this world:
1. Never tell everything you know