I'm trying to add remote databases to my management console. When I use the discovery wizard and type in the IP, it finds the server fine. However, whenever i try to open anything on the server, it fails (target host or object does not exist). I realized after looking at the TNS connect string, that it's using the server name, instead of the server IP. How can I get it to connect using the IP?
Originally posted by Szhark I realized after looking at the TNS connect string, that it's using the server name, instead of the server IP. How can I get it to connect using the IP?
Replace the server name with the IP of the server in the tnsnames.ora at the client side.
IP would be given the first preference to connect.
Check if the IP address given in listener.ora (HOST = #) in server side and IP address given in tnsnames.ora in client side matches.
If the IP address is not given ,but hostname is given then,
you have to check the hosts file in your OS to see if the mapping
of IP address to Hostname is proper.
Reply With Quote
Bookmarks