Tns-03505 Failed To Resolve Name Error

Contents

Answer: Obviously, both TNS-03505 and ORA-12154 are TNS errors; however, they can each have a variety of possible causes and resolutions. Stay logged in Sign up now! Following is the correct TNSNAMES.ORA from my system # tnsnames.ora Network Configuration File: D:\app\app\product\11.1.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. Install 11gR2 database, software only.4. http://evasiondigital.com/failed-to/tns-03505-error.php

Tns-03505 Failed To Resolve Name 12c

If you have TNS_ADMIN declared, check the tnsnames.ora file in the directory, which it points to. NAMES.DIRECTORY_PATH=(TNSNAMES) NAMES.DIRECTORY_PATH=(TNSNAMES, HOSTNAME) Though NAMES.DIRECTORY_PATH parameter is not needed, but if it exists then it should look ok. Make sure by using IP Address entry instead of hostname inside TNSNAMES.ORA. TNS-03505: Failed to resolve Name Discussion in 'General' started by SudeepShakya, Aug 13, 2011.

After removing the parameter, save the SQLNET.ORA file, and try connecting again. Apurva T. Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Tns-03505 Failed To Resolve Name Linux SQLNET.ORA sample provided below.

Just e-mail: and include the URL for the page. I have copied over the entry in tnsnames.ora entry from the $ORACLE_HOME/network/admin/tnsname.ora to the tnsnames file that Spotlight or Toad for Oracle uses, but with no success. apps_expert, Aug 15, 2011 #5 zargon Community Moderator Forum Guru Messages: 2,310 Likes Received: 340 Trophy Points: 1,430 Location: Aurora, CO Most likely you have more than one tnsnames.ora file on http://www.oraclenerd.com/2010/09/tns-03505-failed-to-resolve-name.html More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Apr 22, 2012 4:11 AM by Prashant Dixit Tnsping Errror - TNS-03505:

All rights reserved. Tns-03505: Failed To Resolve Name Ldap Verify that there are not multiple tsnnames.ora files as it may be attempting a connection to the wrong database. The TNS-03505 error indicates that the service name is missing : TNS-03505: Failed to resolve name Cause: The service name you provided could not be found in TNSNAMES.ORA, an Oracle Names In case of Windows XP, - Make sure TNS_ADMIN environemental points to correct location.

From Command prompt, Defin TNS_ADMIN for the current Command Prompt session. In C Shell, the syntax is: % setenv TNS_ADMIN full_path_to_tnsnames.ora_file In K Shell, the syntax is: % TNS_ADMIN=full_path_to_tnsnames.ora_file; export TNS_ADMIN After setting try the connection/tnsping again. Action: Verify that you entered the service name correctly. this page try use here SID keyword instead of SERVICE_NAME.

Continue × Access Disabled Our records indicate that your access has been disabled. Tns 03505 Used Parameter Files assistant tab (sorry, I don't remember more exactly where it is). Many a times it has turned out that this variable was pointing to a different location than the one I was looking in (especially since the release of PUM, DPKs etc).

Covered by US Patent.

Recent Posts Creating a New PeopleSoft Account Tree PeopleSoft WorkCenter Introduction Processing in PeopleSoft FSCM What is Puppet and what's its significance in PeopleSoft? For example: C:\> set tns_admin=c:\oracle\network\admin (set this to your own "admin" folder) After you do that try tnsping again and see what happens. Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? Tns-03505 Failed To Resolve Name 10g thanks [Updated on: Tue, 18 June 2013 07:37]Report message to a moderator Re: TNS-03505: Failed to resolve name tips - tnsping orcl [message #587759 is a reply to

Scream and yell when the configuration doesn't work.Rinse and repeat 12 times.I've gotten quite good at it.Then I ran into this lovely error...TNS-03505: Failed to resolve name Cause: The service name Guest Bloggers Michael O'Neill Gary Myers Enrique Aviles John Piwowar Ted Simpson Kellyn Pot'vin-Gorman Victor Fagundo Miscellaneous caveats ORACLENERD on Facebook katezilla katezilla on Facebook Popular Posts DROP DATABASE; TNS-12533: TNS:illegal If yes, did you set TNS_ADMIN? You type "tnsping tns" and if you have default_domain set it is looking for an alias in tnsnames.ora called tns.websmiths.com.

Action: - If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile Re: Tnsping Errror - TNS-03505: Failed to resolve name Prashant Dixit Apr 22, 2012 4:10 AM (in response to Prashant Dixit) Below are the new contents of tnsnames.ora file - ====== Now you have to ensure that your TNSNAMES.ORA is in the correct location and you have used correct TNS entry while connecting. If nothing exist you can add one user variable.