Quest Toad 10.6 ORA-12546 TNS:permission denied

Most of the software firewall are designed to provide you a kind of moderate level of security from unwanted intrusions, however at certain occasions, this could jeopardise certain legitimate connection requests…including Quest Toad TNS connections.
Prior breaking your head against the walls, give it another try by disabling the firewall if you receive the error “ORA-12546 TNS:permission denied”, and all other client side oracle tools successfully connect to Oracle database without any issues.
If the firewall was blocking the connections, create exceptions for Toad.exe and enjoy.


Quest toad or Oracle Sql Developer?

There were times when Quest Toad used to desert us with plain statements like “There was an error” especially while compiling procedures or funcations @ database level. We assume it was mostly because of the older versions of toad being used against latest versions of Oracle database. Well usually no firms want to upgrade to latest versions of Toad, as it involves the biting factor, money!

So, we started using Oracle’s own sql developer. The look and feel of Oracle’s SQL developer is so so, nothing compared to the neat and organized look of Quest toad, at the same time it is the most affordable tool for a developer, as it costs nothing for one to download and start using!
Not just that, if you have the latest version of Sql Developer, it does show you the exact error messages under almost all possible scenarios.
A quick post from a very satisfied Oracle’s SQL Developer suite!

for Windows7bugs,