Skip to Main Content
Forums

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!

Why VIP and Public IP has to be mentioned in listener.ora file

YasuMay 10 2010 — edited May 12 2010
Hi All,

I was just confused like why we need to configure listener with both VIP and Public IP as shown below.
SID_LIST_LISTENER_ABCD =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/local/opt/oracle/product/10.2.0)
      (PROGRAM = extproc)
    )
  )

LISTENER_ABCD =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = abcd-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10........)(PORT = 1521)(IP = FIRST))
    )
  )
Why public IP is required for listener??

-Yasser

Edited by: YasserRACDBA on May 10, 2010 1:18 PM
This post has been answered by Billy Verreynne on May 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2010
Added on May 10 2010
#performance-availability, #real-application-clusters
10 comments
2,700 views