I have the weirdest bug ever. I wonder if this is a bug with Oracle. I have Oracle 11g database installed on a machine in one subnet and the 11g client on another subnet. These are two machines in different subnet but under the same network domain. In C# application code, I can connect to the database and does a SQL query retrieving the data. However, when I do GetSchema("Tables"), it hangs forever. GetSchema() is OK.
Here is an interesting observation: if the application is on a machine under the same subnet as the database server, everything works. Anyone has seen this weird error with Oracle database?