can tnsping but sqlplus gets ora-12545:Connect failed because target host or object does not exist

https://www.experts-exchange.com/questions/20622245/ORA-12545-Connect-failed-because-target-host-or-object-does-not-exist.html

may be this link will be usefull to u

Still not having any luck, I've verified I only have a single sqlnet.ora and tnanames.ora file on client, oracle_home looks OK, and I've tried a service name both with and without domain name suffix, nothing working yet.

When you do tnsping does it say it makes use of the TNSNAMES.ora file? Can you take a screenshot of the tnsping result? Is there a SQLNET.ORA file present?

Here's a screen shot of the tnsping, and yes, there's a sqlnet.ora present
Ora12545Document1.doc

Sorry! I don't have any DOC viewer installed in my laptop yet.. Can you please post it as a JPEG file?

Also provide the TNSNames.ora file entry. In that, there would be a server name. Are you able to ping that server using "ping" command?

I've attached the jpg, I am able to ping the server, here's the tnanames.ora file

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\ClientOnly\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ULTRAPACS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.170.8.180)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = pacs)
    )
  )


ORA12545Error.JPG

Global database name is of the format database_name.domain_name. In your case database_name is pacs and domain_name is something else (probably .world??)

So your tnsnames entry should be <something>.world. You can update the tnsnames.ora file to name the entry in this convention.

Other option is to comment out the NAMES.DEFAULT_DOMAIN parameter in SQLNet.ora file. Hope this helps!

I've tried it with and without the domain name, on both the entry name and service name, results are the same either way. I don't have a DEFAULT_DOMAIN entry in sqlnet.ora

Is the Oracle listener running properly on the server machine?

can you show a screenshot of the actual error?