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
Post a Comment