Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = racdb)))
TNS-12560: TNSrotocol adapter error
I am not able to ping to Rac1-vip on node rac1, this whole setup is on vmware
and the versions are as follows
/crsctl query crs softwareversion
Oracle Clusterware version on node rac1 is http://126.96.36.199.0
ORACLE DATABASE VERSIOn:10.2.0.1.0
any suggestions are welcome, Thanks in Advance for your help.
can you post tnsnames.ora entry, where are you pinging racdb from?
Can you ping the IP address of rac1-vip?
If you can alter tnsnames entry to use IP address instead of dns name.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Thanks for your reply sir. I tried to ping my VIP address which is 192.168.2.122 but no response. Is there any point I am missing?, I configured VIP explicitly with VIPCA and it is successful.
PING 192.168.2.122 (192.168.2.122) 56(84) bytes of data.
From 192.168.2.125 icmp_seq=2 Destination Host Unreachable
From 192.168.2.125 icmp_seq=3 Destination Host Unreachable
Click Here to Expand Forum to Full Width