I have a user getting "
Network error:: 11004 - The requested name is valid, but no data of the requested type was found" when trying to connect to an Oracle database via TOAD. All of the connection information looks correct. Any assistance in resolving would be most appreciated
Are they using direct connect or a tns names alias (i.e. tnsnames.ora file)? Either way can you post the contextual info so can try to provide feedback …
He is trying to connect using tns alias. I have checked tnsnames file and it is good
From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]
Sent: Tuesday, July 08, 2014 6:10 PM
Subject: RE: [Toad for Oracle - Discussion Forum] Network error trying to connect to Oracle database
RE: Network error trying to connect to Oracle database
Reply by Bert Scalzo
Are they using direct connect or a tns names alias (i.e. tnsnames.ora file)? Either way can you post the contextual info so can try to provide feedback …
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
If the tns names alias is good then you most likely have a network issue. Tad simply calls SQL*Net using the alias - no magic or mystery to what Toad does. So if network errors do occur like this error message than it’s a network problem. Sorry - sure not the answer you want but it is what it is …
No, not the answer I had hoped for but at least I know what direction to look in. Thanks for your response.
From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]
Sent: Tuesday, July 08, 2014 7:48 PM
Subject: RE: [Toad for Oracle - Discussion Forum] Network error trying to connect to Oracle database
RE: Network error trying to connect to Oracle database
Reply by Bert Scalzo
If the tns names alias is good then you most likely have a network issue. Tad simply calls SQL*Net using the alias - no magic or mystery to what Toad does. So if network errors do occur like
this error message than it’s a network problem. Sorry - sure not the answer you want but it is what it is …
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
