????Oracle RAC??????????????????????????????????л?????????RAC???????????????Щ???????????????й???????
????1?? ??????????
????RAC???????????????????????????????????????μ???????RAC????????????????????????????????????????????????RAC??????????????????????RAC?з????????????????????????????????????????????????????
????1. RAC???????????
?????????????????????????????????????RAC?????????????????????κι????????????????????????κ????????????????????tnsnames.ora????????????????????ü??ɡ???????Linux???????????н????
??????1?? ???/etc/hosts???
??????/etc/hosts???????RAC?????????IP????????????????磺
????192.168.12.231          node-rac1
????192.168.12.232          node-rac2
????192.168.12.230          node-vip1
????192.168.12.240          node-vip2
??????2?? ??RAC??????service_names
????[oracle@node-rac1 ~]$ sqlplus "/as sysdba"
????SQL*Plus: Release 11.1.0.6.0 - Production on Sun Sep 12 22:05:53 2010
????Copyright (c) 1982?? 2007?? Oracle.  All rights reserved.
????Connected to:
????Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
????With the Partitioning?? Real Application Clusters?? OLAP?? Data Mining
????and Real Application Testing options
????NAME           TYPE        VALUE
????---------------------- --------------     -------------
????service_names    string        racdb
?????????????????????????RAC??????????????????????RAC?????????????????????????????SERVICE_NAME?????????“SERVICE_NAME = racdb”
??????3?? ???Oracle?????????????tnsnames.ora
RACDB=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node-vip2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node-vip1)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
??????????????????????￡?
????LOAD_BALANCE = yes?????????????????????????????“LOAD_BALANCE = no”??????????????????????????????“LOAD_BALANCE = yes”?????????????SQLNet????????ADDRESS_LIST?б??е??????????????????????????????????????????????????????“LOAD_BALANCE = no”?????SQLNet????ADDRESS_LIST?б??е??????????????????????????????ü?????
????SERVICE_NAME = racdb?????“racdb“??RAC????????????????????????