sql - ORA-12545: Connect failed because target host or object does not exist -


have encounter error before? tried refer link: http://www.ardentperf.com/2007/04/02/local_listener-and-ora-12545/

but doesn't resolve our issue. our scenario able connect database encounter error when try select data view.

i have enabled client-side sqlnet trace unable interpret exact cause of issue.

any ideas anyone?

thanks

for me problem host not being detected name in tnsnames.ora, using ip address instead resolved (i think due domain controller issue):

xyzd =   (description =     (address = (protocol = tcp)(host = 123.45.67.89)(port = 1521))     (connect_data = (service_name = xyzd))   ) 

do command: “ping host” find servers ip address.

  • ping host
  • telnet host port
  • tnsping tns_alias

edit:

just ran again, time firewall blocking tcp via port.


Comments

Popular posts from this blog

java - SNMP4J General Variable Binding Error -

windows - Python Service Installation - "Could not find PythonClass entry" -

Determine if a XmlNode is empty or null in C#? -