TNS-03505 - ORACLE tnsping

2

When attempting to ping, using tnsping .

ex: tnsping UMEXEMPLO

I get the following error

  

TNS-03505: Failed to resolve name

Which solution usually applies?

EDIT:

From other machines we normally access the Bank on the server. The service name is configured according to the server, the environment variables also, when we dribble it receives the jumps successfully but, when we ping directly on the server where the Bank is, gives the error informed.

    
asked by anonymous 09.05.2017 / 16:41

1 answer

2

Have you checked TNSNAMES ? It's on the way:

  

[yourDirectory] \ Oracle \ product \ 11.2.0 \ client_1 \ network \ admin \ tnsnames.ora

The error TNS-03505 means that there was a failure to resolve the name or SERVICE_NAME .

Here is an example of an incoming connection:

BDTESTE = 
  (DESCRIPTION =
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 12346))
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = bdteste.xyz.com.br)
    )
  )
  • Check the file if the Service Name you reported exists.
  • Not yet TNSNAMES.ORA , check that SERVICE_NAME is correct.
  • Save the file and ping again: tnsping BDTESTE
  • Usefulness

    To check the service name of a DB, use the command below:

    select value from v$parameter where name like '%service_name%';
    

    Also check the SQLNET.ORA

    If you are using the local name (file tnsnames.ora ) check that TNSNAMES is listed as one of the NAMES.DIRECTORY_PATH parameter values in the Oracle Net profile ( sqlnet.ora file). SQLNET.ORA Example:

    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.
    
    SQLNET.AUTHENTICATION_SERVICES = (NTS)
    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
    

    The SQLNET.ORA file is in the same location as TNSNAMES reported above.

        
    09.05.2017 / 17:43