14 Replies Latest reply: Mar 31, 2014 2:49 PM by r_g_financials_dba RSS

    Tnsping is not showing VIP

    Avadhut

      Hi All,

       

      We have configured Oracle EBS 11i with RAC 11gR2. We are using VIP not using SCAN IP.

       

      After configuring the tns on application server. When we tnsping the connection string it is showing only one vip.

      The output must show me both the vip entries.

       

      $tnsping DAN

       

       

      TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production on 24-MAR-2014 13:47:42

       

       

      (c) Copyright 1997 Oracle Corporation.  All rights reserved.

       

       

      Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=idcglbsl01-vip.dan.com)(PORT=1522))

      OK (0 msec)

       

      As per the below entry from TNS. It contains both VIP.

       

      DAN=

              (DESCRIPTION=

                  (LOAD_BALANCE=YES)

                  (FAILOVER=YES)

                  (ADDRESS_LIST=

                      (ADDRESS=(PROTOCOL=tcp)(HOST=idcglbsl01-vip.dan.com)(PORT=1522))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=idcglbsl02-vip.dan.com)(PORT=1522))

                  )

                  (CONNECT_DATA=

                      (SERVICE_NAME=DAN)

                  )

              )

       

      Database server is hosted on Linux server and Apps is hosted on IBM AIX server.

       

      Why it is not showing both the VIPS.

       

      Please suggest

       

      Thanks