Toad World® Forums

Network error trying to connect to Oracle database


#1

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


#2

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 …


#3

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

To: toadoracle@toadworld.com

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.


#4

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 …


#5

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

To: toadoracle@toadworld.com

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.