Well, one thing is sure, Toad is not using the same connection driver.

Can you ping the host listed in your tnsnames.ora file?

Both client and server are 9.2.x, right?