??????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.