Home > RAC10G, RAC11G., RAC_GENERAL > SAMPLE TNS ENTRY FOR RAC.,

SAMPLE TNS ENTRY FOR RAC.,

June 23, 2013

As a part of trouble shooting or providing to user,  we may need to prepare TNS for rac servers.  following is the sample entry. Just we need to add VIP all nodes. in this.

 

TEST.ORACLE.COM =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=TEST1-vip.ORACLE.COM)(PORT=1521)) ——-> “B”
(ADDRESS=(PROTOCOL=tcp)(HOST=TEST2-vip.ORACLE.COM)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=11GR2TEST.ORACLE.COM))
)

 

Following are we need to do the changes.

1) add replace VIP address for each nodes. if we have three nodes, then we need to add three lines of “B”.

2) replace the VIP and port values.

3) replace SID values

 

enjoy blog reading…………………:)

 

Advertisements
Categories: RAC10G, RAC11G., RAC_GENERAL
%d bloggers like this: