root 4408 1 0 04:23 ? 00:00:05 /oracle/app/grid/product/11.2.0/bin/cssdmonitor
root 4427 1 0 04:23 ? 00:00:05 /oracle/app/grid/product/11.2.0/bin/cssdagent
grid 4445 1 0 04:23 ? 00:00:56 /oracle/app/grid/product/11.2.0/bin/ocssd.bin [grid@node1 bin]$ ps -ef|grep crs
root 4767 1 0 04:24 ? 00:00:20 /oracle/app/grid/product/11.2.0/bin/crsd.bin reboot
[grid@node1 bin]$ ps -ef|grep evm
grid 4623 1 0 04:24 ? 00:00:07 /oracle/app/grid/product/11.2.0/bin/evmd.bin grid
4861
4623
0
04:24
?
00:00:00
-o -l
/oracle/app/grid/product/11.2.0/bin/evmlogger.bin /oracle/app/grid/product/11.2.0/evm/log/evmlogger.info /oracle/app/grid/product/11.2.0/evm/log/evmlogger.log
ÎÒÃÇÀ´¿´Ò»Ï¸÷¸ö½ø³ÌµÄ×÷Ó㺠OCSSD
½ø³ÌÊÇClusterware×î¹Ø¼üµÄ½ø³Ì£¬Èç¹û³öÏÖÒì³£»áµ¼ÖÂÏµÍ³ÖØÆô£¬Õâ¸ö½ø³ÌÌṩCSS£¨Cluster Synchronization Service£©·þÎñ£¬Ëüͨ¹ý¶àÖÖÐÄÌø»úÖÆÊµÊ±¼à¿Ø¼¯ÈºµÄ½¡¿µ×´Ì¬£¬Ìṩ¼¯ÈºµÄ»ù´¡·þÎñ¹¦ÄÜ¡£
CRSD
ÊÇʵÏָ߿ÉÓõÄÖ÷Òª½ø³Ì£¬ËüÌṩÁËCRS£¨Cluster Ready Service£©·þÎñ¡£ÕâЩ·þÎñ°üÀ¨ClusterwareÉϼ¯Èº×ÊÔ´µÄ¹Ø±Õ¡¢ÖØÆô¡¢×ªÒÆ¡¢¼à¿ØµÈ¡£¼¯Èº×ÊÔ´·ÖΪÁ½ÀࣺһÀàÊÇNodeappsÐ͵쬾ÍÊÇ˵ÿ¸ö½ÚµãÖ»ÐèÒªÒ»¸ö¾ÍÐУ¬ÕâÀàÓÐGSD(Global Service Daemon)¡¢ONS£¨Oracle Notification Service Daemon£©¡¢VIP¡¢Listener£»ÁíÒ»ÀàÊÇDatabase-Related£¬¾ÍÊǺÍÊý¾Ý¿âÏà¹Ø£¬²»ÊܽڵãÏÞÖÆ£¬ÕâÀàÓÐDatabase¡¢Instance¡¢ServiceµÈ¡£
EVMD
¸Ã½ø³Ì¸ºÔð·¢²¼CRS²úÉúµÄ¸÷ÖÖʼþ£¬Í¬Ê±Ò²ÊÇCRSDºÍCSSDÁ½¸ö½ø³ÌÖ®¼äµÄÇÅÁº¡£ RACGIMON
¸Ã½ø³Ì¸ºÔð¼ì²éÊý¾Ý¿â½¡¿µ×´Ì¬£¬¸ºÔðServiceµÄÆô¶¯¡¢Í£Ö¹¡¢¹ÊÕÏ×ªÒÆµÈ¡£ OPROCD
ÔÚ·ÇLinuxƽ̨£¬ÇÒûÓÐʹÓõÚÈý·½¼¯ÈºÈí¼þʱ²ÅÓиýø³Ì£¬ÓÃÀ´¼ì²â½ÚµãµÄCPU¹ÒÆð£¬Æð¹ý1.5
9
Ãë»áÖØÆô½Úµã¡£
OHASd
OracleÔÚ11gR2ÒýÈëÁËOHASd£¨Oracle High Availability Services Daemon£¬Oracle¸ß¿ÉÓ÷þÎñºǫ́½ø³Ì£©£¬ÔÙÓÉËüÀ´Æô¶¯ÆäËûµÄ¼¯Èº¼þÊØ»¤½ø³Ì¡£
3. ÍøÂç×é¼þ
ÎÒÃÇ´ÓRAC¼¯Èº¼Ü¹¹ÖеÄÓ²¼þ»·¾³×é³ÉÒѾ֪µÀ£¬¼¯Èº»·¾³ÖеĽڵãÉϱØÐëÅäÖÃÁ½¿éÎïÀíÍø¿¨£¬ÔÚ¹«ÍøÍø¿¨ÉÏÃæÎÒÃdzýÁËÉèÖù«ÓÐIPÍ⻹ÉèÖÃÁËVIP£¬OracleµÄTAF£¨ËùνTAF¾ÍÊÇÁ¬½Ó½¨Á¢ºó£¬Èç¹ûij¸öʵÀý·¢Éú¹ÊÕÏ£¬Á¬½Óµ½Õâ¸öʵÀýÉϵÄÓû§»á±»×Ô¶¯Ç¨ÒƵ½ÆäËû½¡¿µÊµÀýÉÏ£¬¶ÔÓÚÓ¦ÓóÌÐò¶øÑÔ£¬Õâ¸öÇ¨ÒÆ¹ý³Ì͸Ã÷£¬²»ÐèÒªÈ˹¤½éÈ룩Êǽ¨Á¢ÔÚVIP¼¼ÊõÉϵģ¬ËüÓëIP×îÖ÷ÒªµÄ²»Í¬¾ÍÊÇVIPÊǸ¡¶¯µÄ£¬IPÊǹ̶¨µÄ£¬µ±Ä³¸ö½Úµãå´»úʱ£¬¸Ã½ÚµãÉϵÄVIP×Ô¶¯»áÒÆµ½½¡¿µ½ÚµãµÄ¹«ÍøÍø¿¨ÉÏ£¬ËùÄܶԸýڵãµÄÁ¬½Ó×Ô¶¯»áÒÆµ½½¡¿µ½Úµã¡£
VIP»¹Óм¸¸öÌØµãÐèÒªÎÒÃÇ×¢Òâһϣº
a) VIPÊÇÔÚClusterware°²×°×îºó½×¶Îͨ¹ý½Å±¾vipca´´½¨µÄ£»
b) VIP×÷Ϊһ¸öNodeappsÀàÐ͵ÄCRS×ÊÔ´×¢²áµ½OCR£¬²¢ÓÉCRSά»¤×´Ì¬£» c) ÿ¸ö½ÚµãµÄ¼àÌý»áͬʱÔÚPublicÍø¿¨µÄPublic IpºÍVIPÁ½¸öµØÖ·ÉϼàÌý£» d) ¿Í»§¶ËµÄtnsnames.oraÒ»°ãÅäÖÃÖ¸Ïò½ÚµãµÄVIP
2.3 µ¥ÊµÀýÓëRAC»·¾³
1¡¢ µ¥ÊµÀýÓëRAC»·¾³¶Ô±È
×é¼þ SGA ºǫ́½ø³Ì Êý¾ÝÎļþ ¿ØÖÆÎļþ Áª»úÖØ×öÈÕÖ¾Îļþ µ¥ÊµÀý ʵÀýÓÐ×Ô¼ºµÄSGA RAC ÿ¸öʵÀýÓÐ×Ô¼ºµÄSGA ʵÀýÓÐ×Ô¼ºµÄºǫ́½ø³Ì¼¯ ÿ¸öʵÀýÓÐ×Ô¼ºµÄºǫ́½ø³Ì¼¯ ½öÓÉÒ»¸öʵÀý·ÃÎÊ ½öÓÉÒ»¸öʵÀý·ÃÎÊ ÓÉËùÓÐʵÀý¹²Ïí£¬±ØÐë·ÅÓÚ¹²Ïí´æ´¢ÉÏ ÓÉËùÓÐʵÀý¹²Ïí£¬±ØÐë·ÅÓÚ¹²Ïí´æ´¢ÉÏ ×¨¹©Ò»¸öʵÀýдÈëÓë¶ÁÈ¡ Ö»ÓÐÒ»¸öʵÀý¿ÉÒÔдÈ룬µ«ÆäËûʵÀý¿ÉÒÔÔڻظ´ºÍ¹éµµÆÚ¼ä¶ÁÈ¡£¬Èç¹ûÒ»¸öʵÀý¹Ø±Õ£¬ÄÇôÆäËûʵÀýµÄÈÕÖ¾Çл»¿ÉÒÔ¶Ô¿ÕÏÐʵÀýÈÕÖ¾½øÐй鵵 10
¹éµµÖØ×öÈÕÖ¾Îļþ ÉÁ»ØÈÕÖ¾ ¸æ¾¯ÈÕÖ¾ÓëÆäËû¸ú×ÙÎļþ ORACLE_HOME ר¹©Ò»¸öʵÀýʹÓà רÊôÓÚÒ»¸öʵÀý£¬µ«ÔÚ½éÖʻָ´ÆÚ¼ä£¬ÆäËûʵÀýÐèÒª·ÃÎÊËùÐèµÄ¹éµµÈÕÖ¾ ר¹©Ò»¸öʵÀýʹÓà ר¹©Ò»¸öʵÀýʹÓà ÓÉËùÓÐʵÀý¹²Ïí£¬±ØÐë·ÅÓÚ¹²Ïí´æ´¢ÉÏ ×¨ÊôÓÚÿ¸öʵÀý£¬ÆäËûʵÀý²»»á¶ÁдÕâЩÎļþ ͬһ¸ö½ÚµãÉÏ·ÃÎʲ»Í¬Êý¾Ý¿âµÄ¶à¸öʵÀý¿ÉÒÔʹÓÃÏàͬµÄ¿ÉÖ´ÐÐÎļþ ͨ³£Óëµ¥¸öʵÀýÏàͬ£¬µ«Ò²¿ÉÒÔ·ÅÖÃÓÚ¹²ÏíÎļþϵͳÖУ¬ÔÊÐíËùÓÐʵÀý¹²ÓÃÒ»¸öORACLE_HOME 2¡¢ RACÐÂÔöµÄ×é¼þºÍºǫ́½ø³Ì
RACµÄ»·¾³ÖÐËäȻÿ¸öʵÀý¶¼ÓÐ×Ô¼ºµÄbuffer cacheÓëshared pool£¬µ«ËüÃÇÏÖÔÚÒѾ±ä³ÉÈ«¾ÖµÄ£¬ÐèÒªÌØÊâ´¦Àí²ÅÄÜ×öµ½Ã»ÓгåÍ»¡¢ÎÞË𻵵عÜÀí×ÊÔ´£¬ËùÒÔÒ²ÐÂÔöÁËһЩµ¥ÊµÀý»·¾³ÖÐûÓеÄ×é¼þ£¬×îÖ÷ÒªµÄÓÐÒÔÏÂÁ½²¿·Ö£º 1) GRD
RACʵÀýµÄSGAÖжàÁËÒ»¸öGRD£¨Global Resource Directory£©²¿·Ö£¬OracleÊý¾Ý¿âÖÐÊý¾ÝµÄ²Ù×÷¶¼ÊÇÔÚÄÚ´æSGAÖÐÍê³ÉµÄ£¬Ó봫ͳµÄµ¥ÊµÀýÊý¾Ý¿â²»Í¬£¬RACÓжà¸öʵÀý£¬Ã¿¸öÊý¾Ý¿éÔÚÈκÎÒ»¸öʵÀýÖж¼Óп½±´£¬RAC±ØÐëÖªµÀÕâЩ¿½±´µÄ·Ö²¼¡¢°æ±¾¡¢×´Ì¬£¬¶øGRD¾ÍÊDZ£´æÕâÖÖÐÅÏ¢µÄÄÚ´æÇø¡£ÖµµÃ×¢ÒâµÄÊÇ£¬Ã¿¸ö½Úµã¶¼Ö»Óв¿·ÖGRDÄÚÈÝ£¬ËùÓнڵãºÏÔÚÒ»Æð²ÅÄܹ¹³ÉÍêÕûµÄGRD¡£ 2) ºǫ́½ø³Ì
RACÒ²Óк͵¥ÊµÀýÖеÄDBWR¡¢LGWR¡¢ARCn¡¢CKPTÕâЩºǫ́½ø³Ì£¬´ËÍ⻹ÓÐһЩRACÌØÓеĺǫ́½ø³Ì£º lms
¸Ã½ø³ÌÊÇCache FusionµÄÖ÷Òª½ø³Ì£¬¸ºÔðÊý¾Ý¿éÔÚʵÀý¼äµÄ´«µÝ£¬¶ÔÓ¦µÄ·þÎñÊÇGCS£¨Global Cache Service£©£¬¿ÉÒÔͨ¹ýGCS_SERVER_PROCESSES²ÎÊýÀ´¿ØÖƽø³ÌµÄÊýÁ¿£¬Ä¬ÈÏÊÇ2¸ö£¬È¡Öµ·¶Î§Îª0~9¡£ lmd
¸Ã½ø³ÌÌṩGES£¨Global Enqueue Service£©·þÎñ£¬ÔÚ¶à¸öʵÀý¼äе÷¶ÔÊý¾Ý¿éµÄ·ÃÎÊÐò£¬±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ·ÃÎÊ£¬ºÍLMSn½ø³ÌÒÔ¼°GRD¹²Í¬¹¹³ÉRACµÄºËÐŦÄÜCache Fusion¡£ lck
Õâ¸ö½ø³Ì¸ºÔðNon-Cache Fusion×ÊÔ´µÄͬ²½·ÃÎÊ£¬Ã¿¸öʵÀý¶¼ÓÐÒ»¸öLCK½ø³Ì¡£ lmon
¸÷¸öʵÀýµÄLMON½ø³Ì¶¼»á¶¨ÆÚͨÐÅ£¬¼ì²é¼¯ÈºÖи÷½ÚµãµÄ½¡¿µ×´Ì¬£¬µ±Ä³¸ö½Úµã³öÏÖ¹ÊÕÏ£¬¸Ã½ø³Ì¸ºÔð¼¯ÈºÖع¹¡¢GRD»Ö¸´µÈ£¬ËüÌṩµÄ·þÎñÊÇCGS£¨Cluster Group Services£©¡£ diag
Diag½ø³Ì¼à¿ØÊµÀýµÄ½¡¿µ×´Ì¬£¬²¢ÔÚʵÀý³öÏÖÔËÐдíÎóʱÊÕ¼¯Õï¶ÏÊý¾Ý¼Ç¼µ½Alert.logÈÕÖ¾ÖС£ GSD
Õâ¸ö½ø³Ì¸ºÔð´Ó¿Í»§¶Ë¹¤¾ß£¬±ÈÈçsrvctl½ÓÊÕÓû§ÃüÁΪÓû§Ìṩ¹ÜÀí½Ó¿Ú¡£
11
3 Oracle 11g RAC¼¯Èº´î½¨
¸Ã²¿·ÖÏêϸÄÚÈݲÎÓëRACµÄ´î½¨Îĵµ
4 ά»¤
4.1 ¼¯ÈºÎ¬»¤
CRSÓÐÒ»ÕûÌ׵Ť¾ß¼¯£¬ËüÃǶ¼³öÏÖÔÚ$GRID_HOME/binĿ¼Ï£¬ÔÚ$ORACLE_HOMEÖÐÒ²Óв¿·ÖCRS¹¤¾ß¿ÉÓ㬵«OracleÍÆ¼öֻʹÓÃ$GRID_HOME/binĿ¼ÏµĹ¤¾ß¼¯¡£³£ÓõÄÓÐcrsctl¡¢crs_stat¡¢diagcollection.pl¡¢oifcfgµÈ£¬ÏÂÃæ½éÉÜһЩ¼òµ¥µÄÓ¦Óᣠ4.1.1
Æô¶¯ºÍÍ£Ö¹CRS
ͨ³££¬RAC»·¾³ÖеÄCRS¶¼ÅäÖóÉÁËËæ»ú×Ô¶¯Æô¶¯£¬µ«ÓÐʱºòÐèÒªµ÷ÊÔCRS£¬»òÕßOSÐèҪά»¤£¬»òÕßÐèҪΪGIÈí¼þ´ò²¹¶¡Ê±£¬ÐèÒªÊÖ¹¤ÆôÍ£CRS£¬ÊÖ¹¤ÆôÍ£CRSµÄÃüÁîºÜ¼òµ¥£¬ÓëÒÔǰ°æ±¾Ò²ÊÇÒ»Öµģ¬¿ªÆôCRS£ºcrsctl start crs£¬¹Ø±ÕCRS£ºcrsctl stop crs£¬ÒÀ¾ÉÐèÒªÌØÈ¨Óû§rootÀ´Íê³ÉCRSµÄÆôÍ£¡£
11g»¹ÒýÈëÁËÒ»¸öÃüÁÀ´ÆôÍ£ËùÓнڵãÉÏÔËÐеÄÈ«²¿¼¯Èº×ÊÔ´£¬°üÀ¨Êý¾Ý¿âʵÀý¡¢ASM¡¢VIPµÈµÈ×ÊÔ´£¬·Ç³£·½±ã£º
Usage:
crsctl start cluster [[-all]|[-n
Default Start local server -all Start all servers
-n Start named servers
server [...] One or more blank-separated server names ÀýÈ磺
Í£Ö¹ËùÓнڵãÉϵÄcss¼°×ÊÔ´£º crsctl stop cluster -all
Æô¶¯ËùÓнڵãÉϵÄcss¼°×ÊÔ´£º crsctl start cluster -all 4.1.2
ÑéÖ¤CRS
ÏÂÃæÕâЩÃüÁîÓÃÀ´ÑéÖ¤¼¯Èº¼°ÆäÏà¹Ø½ø³ÌµÄ״̬£¨ÒÔgrid¡¢rootÓû§Ö´ÐнԿɣ©¡£ ? ¼ì²éÒ»¸ö¼¯ÈºµÄµ±Ç°ÔËÐÐ״̬£º
12