Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tnsping is not showing VIP

Mayur RahateMar 24 2014 — edited Mar 31 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2014
Added on Mar 24 2014
14 comments
5,377 views