Home » RDBMS Server » Server Administration » TNS-03505: Failed to resolve name (Oracle,10.2.0,Redhat 5)
TNS-03505: Failed to resolve name [message #526989] Fri, 14 October 2011 04:07 Go to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
NAMES.ORA Network Configuration File: /u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

college=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID =college)
    )
  )


This is my tnsnames.ora but when i try to tnsping college it gives me following error
[oracle@localhost 10.2.0]$ vi tnsnames.ora
[oracle@localhost 10.2.0]$ tnsping college

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-OCT-2011 14:37:22

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

TNS-03505: Failed to resolve name
Re: TNS-03505: Failed to resolve name [message #526993 is a reply to message #526989] Fri, 14 October 2011 04:45 Go to previous message
Michel Cadot
Messages: 58857
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.


Post sqlnet.ora

Also:
/u01/app/oracle/product/8.1.7/network/admin/tnsnames.ora
TNS Ping Utility for Linux: Version 10.2.0.1.0
Check ORACLE_HOME

Regards
Michel

[Updated on: Fri, 14 October 2011 04:45]

Report message to a moderator

Previous Topic: Error While Creating The Database
Next Topic: How to know oracle port no
Goto Forum:
  


Current Time: Fri Aug 22 01:51:59 CDT 2014

Total time taken to generate the page: 0.10205 seconds