Inconsistent TNS listener not found

[synapsevampire]

Oracle 9
WIndows NT

I can connect to a database using external tools, such as Toad or Crystal Reports. After some varying amount of usage, I then try to connect again and I get the dreaded TNS Listener not found error

In most cases if I go in and log in through SQL Plus, my other tools will start connecting again, even if I log out of SQL Plus.

Anyone have any experience or insights into why this might be?

-k

 

[sstrobel]

Please reference how you are resolving the Oracle alias. The sqlnet.ora file in ORACLE_HOME\network\admin should reference this through the NAMES.DIRECTORY_PATH entry.

Thanks,

Steve

 

[synapsevampire]

It appears that this was system resource related.

Thanks for the response though.

-k