RAC issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RAC issues

  1. #1
    Join Date
    May 2009
    Posts
    32

    RAC issues

    Hi Everyone,

    tnsping racdb

    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://11.1.0.6.0

    ORACLE DATABASE VERSIOn:10.2.0.1.0
    any suggestions are welcome, Thanks in Advance for your help.

  2. #2
    Join Date
    Oct 2006
    Posts
    175
    can you post tnsnames.ora entry, where are you pinging racdb from?

    Thanks

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  4. #4
    Join Date
    May 2009
    Posts
    32
    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
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width