// Get the OracleHome instance corresponding to the "OraClient" Oracle home.
OracleHome home = OracleConnection.Homes["OraClient"];
            
            // Print some globalization settings of the current home.
OracleGlobalization glob = home.GetClientInfo();
Console.WriteLine("The Oracle home is registered for: " + glob.Territory);
Console.WriteLine("Character set is " + glob.ClientCharacterSet);
Console.WriteLine("Time zone is " + glob.TimeZone);
Console.WriteLine("Date format is " + glob.DateFormat);

            // Create a connection.
OracleConnection conn = new OracleConnection();
conn.UserId = "Scott";
conn.Password = "tiger";
            
            // Try to connect to each server available for the current Oracle home.
            Console.WriteLine("\nTrying to connect as Scott/tiger:\n");
string[] servers = home.GetServerList();
            foreach (string serverName in servers)
            {                
                conn.Server = serverName;
                try
                {
                    conn.Open();
                    Console.WriteLine("Successfully connected to " + serverName);
                }
                catch(Exception ex)
                {
                    Console.WriteLine("Failed connecting to " + serverName + ": " + ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }

            Console.ReadLine();