database - ERROR 12545 : Connect failed because target host or object doesn't exist while trying to connect sqlplus

Question

I want to install oracle instant client but I have been stuck while I was trying to remote DB. I always got error ORA-12545, but my oracle DB is active and works fine.. i already started listener and config /etc/host on both side.

Here's my tnsnames.ora configuration on Oracle Database server:

ROLFSAN =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ullabritta)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rolf)
    )
  )

and here's my tnsname.ora configuration on oracle instant :

SVEN = -- i give this name as i wish, there's no sven on oracle database
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ullabritta)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rolf)
    )
  )

did i do something wrong? or there's specific configuration on oracle database server??

Answer 1

Use the IP address, not the hostname. Oracle client uses DNS to resolve the name, and may not use the hosts file.