??????Oracle 11g???????????SCAN ip???????????public ip??virtual ip??private ip??????????????濉�
????????????????
????public ip??
???????????????oracle?????ip????????????????
????virtual ip??vip????
????oracle??rac????????????vip?????????????????????????????????vip??“????”?????????????????????????????????????vip???
????SCAN??
????Single Client Access Name?????????????????????????????jdbc??pl/sql????????????????????????????rac?????????????????????????scan???????????????????????oracle rac??????????????????????????????????????
????private ip?????ip??oracle ??????????????ip???????????
????public ip:
?????????????ip??????????oracle rac????煤???????????????public ip??vip??scan ip?????????????????????
????vip??
?????????????ip???????oracle rac????煤???????????????public ip??vip??scan ip???????????????????????ip?????????????????????????????????????????ping????
????scan ??
???????????dns???????????ip??????????????煤?????????????????dns????????????谩?scan ip?????????????????????ip??????????????????????????'-'??oracle????????hosts??????????????????????scan ip??
????scan??????????ip??????????????ip??????????????????ip???????????ip????????????scan?????????cluster???????????????????????ip?????
????private ip??
?????????????ip??????????????煤??????????????????????校??????????rac????????????????????????????11.2.0.2?????oracle??????????????4?????????????????????????????????
????GNS??Grid Naming Service??
???????????????????
??????Oracle RAC?????锟�??????????卸??IP?????????Public/Private/Vip????????IP???????????????????????些????????????????????
????1. private IP address is used only for internal clustering processing (Cache Fusion)
???????IP??????????????????????????妫�???????????????????Ip?????????????????????????????IP??
????2. virtual IP is used by database applications to enable fail over when one cluster node fails
????????IP??????????????????效?????????????????????????????????????魏胃芯???
????????????????RAC??????????????????????????????
????3. public IP adress is the normal IP address typically used by DBA and SA to manage storage?? system and database.
????????IP???????????????????????????????????????????????????IP??
?????????????????????????????DBA????????tnsnames.ora?????些???????????vip??????些????????????public IP?? ???纾�???????位???????????????????public ip?????????????????????????????????????ip????????????????????????????????????????????锌?????????A????????????????B????
???????纾�
???????????????????VIP
infodb8  =
( DESCRIPTION =
( ADDRESS = ( PROTOCOL = TCP ) ( HOST = 138 . * . 1 . 81 ) ( PORT = 1521 ) )
( ADDRESS = ( PROTOCOL = TCP ) ( HOST = 138 . * . 1 . 82 ) ( PORT = 1521 ) )
( LOAD_BALANCE = yes )
( FAILOVER = ON )
( CONNECT_DATA =
( SERVER = DEDICATED )
( SERVICE_NAME = infodb )
( FAILOVER_MODE =
( TYPE = SELECT )
( METHOD = BASIC )
( RETRIES = 30 )
( DELAY = 5 )
)
) )
???????????????????Public IP?????????1?????????????infodb1???????????????????
INFODB83  =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS = ( PROTOCOL = TCP ) ( HOST = 138 . * . 1 . 83 ) ( PORT = 1521 ) )
)
( CONNECT_DATA =
( SERVICE_NAME = infodb )
( INSTANCE_NAME = infodb1 )
)
( HS  = OK )
)
????Oracle RAC?????????????????IP?????VIP??????IP?????????巍?
???????VIP???Oracle????????“TCP/IP协??????”???卸?????????????TCP/IP协????????OS Kernel??????????????????OS?胁??????????????????????????????????OS Kernel???????????些OS?????????????????????????????????未????????oracle RAC??????VIP??????????TCP协??????????????
????VIP??IP???????????????VIP??????????IP????????????薪????????????????????VIP??????public NIC?????linux??ifconfig????public????????2??IP??????????????宕�??????????VIP?????????????械????????????????public NIC??????????????3??IP?????
????????????宕�????????????IP?????????????????????????IP???????????????????????????????????????????
??????tnsname.ora????????Address?斜?????????????????????????????????????????????
????VIP???
????1 VIP????clusterware??????危???????VIPCA???????
????2 VIP??????Nodeapps?????CRS Resource???OCR?校?????CRS???????
????3 VIP?????????public ??????????public????????????????
????4 ?????????????????CRS?????????VIP??????????????
????5 ???????Listener??????public??????public IP??VIP??????????????
????6 ??????tnsname.ora??????????????VIP??
???????????6???????????????????????????????????????tnsname.ora???????????????VIP???????????锟�?????????????????????????????????榉�????????Oracle11gR2???????????scan????睢�
????scan??single client access name???????????????????????????????????????????????????????DNS?锌???????????ip??????????????????????????????????????????????SCAN VIP??????scan listener??cluster?????service?????scan listener????????scan listener???????????????foward???????Local listener???????????local ??listener?????????????
???????scan??????resolve??????ip?????????????????????scan???????????3????
????VIP ???????
????Oracle ??TAF ???????VIP ????????? IP ??VIP ???????? IP ??????TCP????? VIP ?????????貌???????????VIP ?????????IP?? ?????????????????????????????????????
?????????????2??????RAC?????????????????????????VIP?? VIP1 ??VIP2. ?????2???????????????????? RAC ???????2?????
????1). CRS ????rac2???????????Clusterware ????????rac2???????????????1????渭?????
????2). RAC??Failover ????????2??VIP???????1?????????1??PUBLIC ????????3??IP ????? VIP1??VIP2?? PUBLIC IP1.
????3). ?????VIP2???????????IP??路????????1
????4). ???????1????VIP2???????????????????????路?????????????
????5). ????????1???????VIP1??public IP1??????IP?????????屑???VIP2??????貌???卸?????????????????????????????????????
????6). ??????????????????????????????位????路?????VIP1??????????
????VIP ???
????1). VIP ?????VIPCA?????????
????2). VIP ???Nodeapps?????CRS Resource ???OCR?校?????CRS ???????
????3). VIP ?????????public ?????????public ??????2???????
????4). ?????????????????CRS ?????????VIP ??????????????
????5). ???????Listener ????????public ??????? public ip ??VIP
????6). ??????tnsnames.Ora ??????????????VIP.