Unable to cast object of type 'Oracle.DataAccess.Client.OracleConnection' to type 'System.Data.Common.DbConnection'.

for this problem just add this string in your hibernate configuration file
none
or for details refer to
http://stackoverflow.com/questions/1210037/error-with-nhibernate-2-1-and-oracle-10g-client