Oracle+11g+RACÔËάÅàѵÎĵµ ÏÂÔØ±¾ÎÄ

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 [...]]] Start CRS stack where

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