// Get the complete collection of Oracle homes available in this system.
OracleHomeCollection homes = OracleConnection.Homes;

            // Check the default Oracle home.
OracleHome defaultHome = homes.DefaultHome;
Console.WriteLine("The default Oracle home in this system is " + defaultHome.Name);

            // Create a connection.
OracleConnection conn = new OracleConnection();
conn.Server = "OraServer";
conn.UserId = "Scott";
conn.Password = "tiger";            

            // Try to connect to the "OraServer" Oracle server as Scott/tiger using each of Oracle homes available.
Console.WriteLine("\nTrying to connect to server \"OraServer\" as Scott/tiger:\n");            
foreach (OracleHome home in homes)
            {
                conn.Home = home.Name;
                try
                {
                    conn.Open();
                    Console.WriteLine("Successfully connected using " + home.Name);
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Failed trying to connect via " + home.Name + ": " + ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }

Console.ReadLine();