Home » Developer & Programmer » Forms » TNS-03505:Failed to resolve name
TNS-03505:Failed to resolve name [message #175332] Thu, 01 June 2006 15:39 Go to next message
pbalakr2
Messages: 4
Registered: June 2006
Junior Member
Hi All,

I am able to connect to the oracle database using TOAD, but when I connect it using ODP from the application, getting an err:TNS-03505: Failed to resolve name. Please let me know how to resolve this.

Thanks
Re: TNS-03505:Failed to resolve name [message #175335 is a reply to message #175332] Thu, 01 June 2006 16:09 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would this help?
Quote:

TNS-03505 Failed to resolve name

Cause: The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names server, or a native naming service.

Action: Verify that you entered the service name correctly. You may need to ensure that the name was entered correctly into the network configuration.
Re: TNS-03505:Failed to resolve name [message #175341 is a reply to message #175335] Thu, 01 June 2006 16:37 Go to previous messageGo to next message
pbalakr2
Messages: 4
Registered: June 2006
Junior Member
Hi,

We are using Citrix, so I was informed that there is no need of any entry in the tnsnames, Please let me know which network configuration needs to be checked. Should I check the tnsnames.ora file or something else.

Thanks
Re: TNS-03505:Failed to resolve name [message #175342 is a reply to message #175341] Thu, 01 June 2006 16:39 Go to previous messageGo to next message
pbalakr2
Messages: 4
Registered: June 2006
Junior Member
Hi,

The server is located in a remote place. I have dba privilage to the database, how can I fix this error.

Thanks
Re: TNS-03505:Failed to resolve name [message #175344 is a reply to message #175341] Thu, 01 June 2006 16:41 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, I don't know what "Citrix" is and why Oracle shouldn't have TNSNAMES.ORA (and/or any other congifuration files) if installed on it. I hope you'll get a better answer from other forum members.
Re: TNS-03505:Failed to resolve name [message #175363 is a reply to message #175342] Thu, 01 June 2006 23:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
For a fuller explanation of 'tnsnames.ora' then search this forum for 'tnsnames'.

I assume that the TOAD about which you talk is on the 'Citrix' box. Please confirm this.

David
Re: TNS-03505:Failed to resolve name [message #175582 is a reply to message #175332] Sat, 03 June 2006 01:58 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

While using citrix, you don't need to configure tnsname.ora file in your clients for citrix.
Citrix is just like accessing the desktop of a remote computer like Remote Desktop in windows XP. If you connect to the server from citrix you work directly on the server from the client so there is no need to configure the tnsnames.ora file.

regards
Re: TNS-03505:Failed to resolve name [message #176034 is a reply to message #175332] Tue, 06 June 2006 08:22 Go to previous messageGo to next message
ingalesd
Messages: 10
Registered: June 2006
Location: Mumbai
Junior Member

use
LOCALHOST
instead of <ipaddress>
in TNSNAMES.ORA configuration file
ur prb will solved
we are using CITRIX Server too and doing the same thing

(
One Clarification needed
for toad which home is set as toad home can u tell
)

if any prb commes mail me to ingalesd@yahoo.com

regards
shantaram
Re: TNS-03505:Failed to resolve name [message #176042 is a reply to message #176034] Tue, 06 June 2006 09:13 Go to previous message
pbalakr2
Messages: 4
Registered: June 2006
Junior Member
Hello,

There was no entry in tnsnames of the server where the application is running.
Now the problme is fixed. Thanks to every one for the quick responses.

Regards
Prabakaran
Previous Topic: make the form cannot be updated or insert in it
Next Topic: How I get error number
Goto Forum:
  


Current Time: Fri Sep 20 09:51:01 CDT 2024