TNS-03505 - ORACLE tnsping

Question

While trying to drip, using the tnsping.

ex: tnsping UMEXEMPLO

The following error appears to me

TNS-03505: Failed to resolve name

Which solution usually applies?

EDIT:

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

Answer 1

Have you checked the TNSNAMES? He gets in the way:

[youDirectory] Oracle product 11.2.0 client_1 network admin tnsnames.ora

The mistake TNS-03505 means that there has been a failure to resolve the name or SERVICE_NAME.

Below is an example of an input connection:

BDTESTE = 
  (DESCRIPTION =
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 12346))
    )
    (CONNECT_DATA = 
      (SERVICE_NAME = bdteste.xyz.com.br)
    )
  )

1. Check the file if the Service Name who reported exists.
2. Still in the TNSNAMES.ORA, check whether the SERVICE_NAME that is correct.
3. Save the file and ping again: tnsping BDTESTE

Usefulness

To check the service name of a BD use the command below:

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

Also check SQLNET.ORA

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

# 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 archive SQLNET.ORA is in the same place as TNSNAMES informed above.