oracle RACµÄ½ø³ÌÃÇ
GSD global services daemon (GSD)
ÓëracµÄ¹ÜÀí¹¤¾ßdbca srvctl
oem½øÐн»»¥£¬ÓÃÀ´Íê³ÉʵÀýµÄÆô¶¯¹Ø±ÕµÈ¹ÜÀíÈÎÎñ¡£
ΪÁ˱£Ö¤ÕâЩ¹ÜÀí¹¤¾ßÔËÐÐÕý³£±ØÐëÔÚËùÓеĽڵãÉÏÏÈstart
gsd,²¢ÇÒÒ»¸öGSD½ø³ÌÖ§³ÖÔÚ
Ò»¸ö½ÚµãµÄ¶à¸örac.gsd½ø³ÌλÓÚ$ORACLE_HOME/binĿ¼Ï£¬ÆälogÎļþ
Ϊ$oracle_home
/srvm/log/gsdaemon.log
ÀýÈ磺
¼ÙÉèʹÓÃoem¹¤¾ßÀ´Æô¶¯Ò»¸öʵÀý£¬oem°Ñ¸Ã
ÈÎÎñ´«µÝ¸øÏàÓ¦µÄÖÇÄÜÒýÇ棬¸ÃÖÇÄÜÒýÇæÉú³É
Ò»¸ö°üº¬SRVCTLÃüÁîµÄ½Å±¾Îļþ£¬GSD½ø³Ì¶ÁÈ¡¸Ã½Å±¾Îļþ²¢ÇÒÖ´Ðиýű¾£¬×îºóGSD°Ñ
Ö´
Ðнá¹û·µ»Ø¸øÖÇÄÜÒýÇæ,½ü¶øÖÇÄÜÒýÇæ·µ»Ø¸øOEM.
ÓÖÀýÈç¼ÙÉèʹÓÃsrvctl¹¤¾ß¹Ø±ÕËùÓеÄʵÀý£¬GSD½ø³Ì½ÓÊÜÀ´×ÔSRVCTL¹¤¾ß·¢³öµÄÇë
Ç󣬲¢
ÔÚ±¾µØ½ÚµãÉÏÖ´ÐиÃÇëÇó£¬È»ºó°ÑÖ´Ðнá¹û·µ»Ø¸øSRVCTL»á»°¡£
LMON:GLOBAL ENQUEUE SERVICE
MONITORLMON
Ö÷Òª¼à²âȺ¼¯ÄÚµÄÈ«¾Ö¶ÓÁкÍÈ«¾Ö×ÊÔ´£¬¹ÜÀíʵÀýºÍ´¦ÀíÒì³£²¢ÏàÓ¦µÄȺ¼¯¶ÓÁнøÐлָ´²Ù×÷¡£
LMD:GLOBAL
ENQUEUE SERVICE DAEMONLMD½ø³Ì
Ö÷Òª¹ÜÀí¶ÔÈ«¾Ö¶ÓÁкÍ×ÊÔ´µÄ·ÃÎÊ£¬²¢¸üÐÂÏàÓ¦¶ÓÁеÄ״̬£¬´¦ÀíÀ´×ÔÓÚÆäËûʵÀý
µÄ×ÊÔ´Çë
Çó¡£Ã¿Ò»¸öÈ«¾Ö¶ÓÁеĵ±Ç°×´Ì¬´æ´¢ÔÚÏàÓ¦µÄʵÀý¹²ÏíÄÚ´æÖУ¬¸Ã״̬±íÃ÷¸ÃʵÀý
¾ßÓÐÏàÓ¦µÄȨÀûʹÓøÃ×ÊÔ´¡£Ò»¸öʵÀý£¨master)µÄ¹²ÏíÄÚ´æÖдæ
ÔÚÒ»¸öÌØÊâµÄ¶ÓÁУ¬¸Ã¶Ó
ÁмͼÀ´×ÔÆäËûÔ¶³ÌʵÀýµÄ×ÊÔ´ÇëÇ󣬵±Ô¶³ÌʵÀýµÄLMD½ø³Ì·¢³öÒ»¸ö×ÊÔ´ÇëÇóʱ£¬¸ÃÇëÇó
Ö¸ÏòmasterʵÀýµÄ
LMD,µ±masterʵÀýµÄLMD½ø³ÌÊܵ½¸ÃÇëÇóºó£¬ÔÚ¹²ÏíÄÚ´æÖеÄÌØÊâ¶ÓÁÐ
Öмà²â¸Ã×ÊÔ´ÊÇ·ñÎÞЧ£¬Èç¹ûÓÐЧÔòLMD½ø³Ì¸üиÃ×ÊÔ´¶ÔÁеÄ×´
̬£¬²¢Í¨ÖªÇëÇó×ÊÔ´µÄ
LMD½ø³Ì¸Ã×ÊÔ´¶ÓÁпÉÒÔʹÓÃÁË£¬Èç¹û×ÊÔ´¶ÓÁÐÕýÔÚ±»ÆäËûʵÀýʹÓûòÕßµ±Ç°ÎÞЧ£¬Ôò
LMD½ø³Ì֪ͨÕýÔÚʹÓÃÖеÄʵÀý
µÄLMD½ø³ÌÓ¦¸ÃÊͷŸÃ×ÊÔ´£¬µÈ×ÊÔ´ÊͷűäµÃÓÐЧʱ£¬
MASTERʵÀýµÄLMD½ø³Ì¸üиÃ×ÊÔ´¶ÓÁеÄ״̬²¢Í¨ÖªÇëÇó×ÊԴʵÀýµÄLMD½ø³Ì¸Ã×ÊÔ´
¶Ó
ÁпÉÒÔʹÓÃÁË¡£ÁíÍâLMD½ø³ÌÒ²¸ºÔð¶ÓÁеÄËÀËøÎÊÌâ¡£¡£¡£
LMSn:GLOBAL CACHE SERVICE PROCESS(n
0~9)
LMS½ø³ÌÖ÷ÒªÓÃÀ´¹ÜÀí¼¯ÈºÄÚÊý¾Ý¿éµÄ·ÃÎÊ£¬²¢ÔÚ²»Í¬ÊµÀýµÄBUFFER CACHEÖд«Êä¿é
¾µÏñ¡£LMS½ø³Ì¿ç¼¯Èº¹ÜÀíÊý¾Ý¿âµÄÇëÇó£¬
²¢±£Ö¤ÔÚËùÓÐʵÀýµÄBUFFER CACHEÖÐÒ»¸ö
Êý¾Ý¿éµÄ¾µÏñÖ»ÄܳöÏÖÒ»´Î¡£LMS½ø³Ì¿¿×ÅÔÚʵÀýÖд«µÝÏûÏ¢À´Ðµ÷Êý¾Ý¿éµÄ·ÃÎÊ£¬µ±
Ò»
¸öʵÀýÇëÇóÊý¾Ý¿éʱ£¬¸ÃʵÀýµÄLMD½ø³Ì·¢³öÒ»¸öÊý¾Ý¿é×ÊÔ´µÄÇëÇ󣬸ÃÇëÇóÖ»Ïò
MASTERÊý¾Ý¿éµÄʵÀýµÄLMD½ø³Ì£¬MASTERʵÀýµÄLMD
½ø³Ì
Ïà¹ØÎĵµ£º
Oracle RAC ÖÐOCR ºÍVoting Disk ±¸·ÝÔÚÎÒµÄblog£º Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ÖÐÒѾÓÐ˵Ã÷£¬ÏÖÔÚÔٴΰÑËüµ¥¶ÀÄóö×öÒ»¸ö˵Ã÷£¬ ÒòΪOCR ºÍ Voting Disk ¶ÔÓÚRAC ϵͳÀ´ËµÌ«ÖØÒªÁË¡£
Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ......
ÒÔÍù´ÓÀ´Ã»ÓÐÏëÈ¥ÈÏÕæ¶ÁÒ»´ÎOracleµÄ°æȨÉùÃ÷£¬½ñÌì´ò¿ªOracle10gR2µÄÎĵµ£¬ÓÚÊǾÍË÷ÐÔ´ÓÍ·¿ªÊ¼¶ÁÒ»ÏÂÕâƪÎÄÕ¡£
һЩÎÒÏë´ó¼Ò¶¼Ó¦¸ÃÈ¥ÖªµÀµÄ£¬ËäÈ»¹úÄڵİæȨ¸ÅÄîʵÔÚÊDZȽϵ±¡£¬µ«ÏëÀ´»áÔ½À´Ô½ºÃµÄ¡£
Oracle10g·ÖΪ4¸ö°æ±¾£¬·Ö±ðÊÇ£º
1¡£Oracle Database Standard Edition One£¬×î»ù±¾µÄÉÌÒµ°æ± ......
1.
¿ªÊ¼-->ÔËÐÐ-->cmd-->
.µ¼³öÊý¾Ý
exp help=y ²é¿´°ïÖú
exp rbt/rbt@ora10 file=c:\db.dmp full=y °´EnterÖ´ÐÐ
.³É¹¦Ö´ÐС£¡£¡£
.µ¼ÈëÊý¾Ý
imp help=y ²é¿´°ïÖú
impÓÉÓµÓÐDBAȨÏÞµÄÓû§eXPÖ´ÐÐ.
imp kxself2/kxself2@ora10 full=y file=c:\db.dmp
»ò
Imp username/password file=f ......
OracleÖÐÌṩһϵÁÐÀàÐÍ£¬Ã¿¸öÀàÐ͵ÄÌصãÈçÏ£º
char£º´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ö·û£¬Èç¹û×Ö·û³¤¶È²»¹»»áÔÚÓұ߲¹¿Õ¸ñ¡£±ÈÈ磺name char£¨10£©£¬µ±¸øname¸³ÖµÎª'zhangsan'ʱ»áÔÚÓұ߲¹³ä2¸ö¿Õ¸ñ¡£charÀàÐ͵ÄÈÝÁ¿Îª1¡«2000B£¬Ã»ÓÐÖ¸¶¨ÔòĬÈϳ¤¶ÈΪ1¡£
varchar2£º´æ´¢³¤¶È¿É±äµÄ×Ö·û£¬ºÍcharÀàÐ͵IJ»Í¬£¬Ëü²»»á×Ô¶¯²¹³ä¿Õ¸ñ£¬ÇÒ¶¨ÒåÊ ......
½ñÌì×öÏîÄ¿µÄʱºò£¬½«null´«ÈëOracleµÄ±íÖУ¬¾ÍÊDz»³É¹¦
¾¹ý³¢ÊԵóöÁËÁ½¸ö½â¾ö·½°¸£º
1.´«ÈëOracleDateTime.NULL
2.Nullable<DateTime> optime = DBNull.Value; ´«Èëoptime(¿ªÊ¼ÍøÉÏÕҵĴð°¸ÊÇNullable<DateTime> optime = null·¢ÏÖ»¹Êǻᱨ´í) ......