Oracle RACÈëÃÅ
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ¾ºÍÊý¾ÝÎļþ´æ·ÅÔÚ¹²ÏíµÄÉ豸ÉÏ£¬Äܹ»±»¼¯ÈºÖеÄËùÓнڵãͬʱ¶Áд¡£Æäϵͳ¼Ü¹¹ÈçÏÂͼ£º
RACÌṩµÄºÃ´¦°üÀ¨£º
(1)¶à½Úµã¸ºÔؾùºâ;
(2)Ìṩ¸ß¿ÉÓ㺹ÊÕÏÈÝ´íºÍÎÞ·ìÇл»¹¦ÄÜ£¬½«Ó²¼þºÍÈí¼þ´íÎóÔì³ÉµÄÓ°Ïì×îС»¯£¬Ï±íÊÇRACÓ봫ͳµÄË«»úÈȱ¸·½Ê½Çл»Ê±¼äµÄ¶Ô±È£º
(3)ͨ¹ý²¢ÐÐÖ´Ðм¼ÊõÌá¸ßÊÂÎñÏìӦʱ¼ä----ͨ³£ÓÃÓÚÊý¾Ý·ÖÎöϵͳ;
(4)ͨ¹ýºáÏòÀ©Õ¹Ìá¸ßÿÃë½»Ò×ÊýºÍÁ¬½ÓÊý ;----ͨ³£¶ÔÓÚÁª»úÊÂÎñϵͳ;
(5)½ÚÔ¼Ó²¼þ³É±¾£¬¿ÉÒÔÓöà¸öÁ®¼ÛPC·þÎñÆ÷´úÌæ°º¹óµÄСÐÍ»ú»ò´óÐÍ»ú£¬Í¬Ê±½ÚÔ¼ÏàӦά»¤³É±¾;
(6)¿ÉÀ©Õ¹ÐԺ㬿ÉÒÔ·½±ãÌí¼Óɾ³ý½Úµã£¬À©Õ¹Ó²¼þ×ÊÔ´;
RACµÄȱµãÓУº
Ïà¶Ôµ¥»ú£¬¹ÜÀí¸ü¸´ÔÓ£¬ÒªÇó¸ü¸ß;
ÔÚϵͳ¹æ»®Éè¼Æ½Ï²îʱÐÔÄÜÉõÖÁ²»Èçµ¥½Úµã;
¿ÉÄÜ»áÔö¼ÓÈí¼þ³É±¾(Èç¹ûʹÓøßÅäÖõÄpc·þÎñÆ÷£¬OracleÒ»°ã°´ÕÕCPU¸öÊýÊÕ·Ñ)
ÔÚOracle9i֮ǰ£¬RACµÄÃû³ÆÊÇOPS (Oracle parallel Server)¡£RAC Óë OPS Ö®¼äµÄÒ»¸ö½Ï´óÇø±ðÊÇ£¬RAC²ÉÓÃÁËCache Fusion(¸ßËÙ»º´æºÏ²¢)¼¼Êõ¡£ÔÚ OPS ÖУ¬½Úµã¼äµÄÊý¾ÝÇëÇóÐèÒªÏȽ«Êý¾ÝдÈë´ÅÅÌ£¬È»ºó·¢³öÇëÇóµÄ½Úµã²Å¿ÉÒÔ¶ÁÈ¡¸ÃÊý¾Ý¡£Ê¹ÓÃCache fusionʱ£¬RACµÄ¸÷¸ö½ÚµãµÄÊý¾Ý»º³åÇøͨ¹ý¸ßËÙ¡¢µÍÑÓ³ÙµÄÄÚ²¿ÍøÂç½øÐÐÊý¾Ý¿éµÄ´«Êä¡£
Oracle RAC/ClusterwareµÄ½á¹¹ºÍ×é¼þ
Ò»¡¢RACÖ÷Òª×é¼þ, ÈíÓ²¼þÁ½²¿·Ö
(1) ·þÎñÆ÷ >= 2
(2) ²Ù×÷ϵͳ£¬ÍƼöʹÓÃOracleÈÏÖ¤µÄϵͳ;°æ±¾²»ÒªÌ«ÀÏ£¬Ò²²»ÒªÌ«ÐÂ
(3) CPU/ÄÚ´æ ¸ù¾ÝÒµÎñÐèÒª£¬ÄÚ´æÖÁÉÙ1G
(4) ±¾µØ´ÅÅ̿ռ䣬>=30G
(5) Íø¿¨ >=2 £¬ÍƼö4¸öÒÔÉÏǧÕ×Íø¿¨
(6) ˽ÓÐÒÔÌ«ÍøÂ磬ÍƼöǧÕ×½»»»»úÒÔÉÏ
(7) HBA¿¨ £¬Èç¹ûÊÇSAN£¬ÍƼö2¸öÈßÓàHBA
(8) ¹²Ïí´æ´¢É豸£¬ÍƼöSANÉ豸
(9) ´æ´¢¹ÜÀí£¬ ASM/Cluster LV/Âã·ÖÇø/CFS£¬²»ÍƼöÓÃOCFS£¬¾í¹ÜÀíÈí¼þ¡¢¶à·¾¶Èí¼þµÈ
(10) µÚÈý·½¼¯ÈºÈí¼þ: ¿ÉÑ¡
(11) Oracle Clusterware Èí¼þ
(12) Oracle RDBMS Èí¼þ
¶þ¡¢ClusterwareÖ÷Òª½ø³Ì
(1)crsd£º ¸ºÔð¹ÜÀí¼¯ÈºµÄ¸ß¿ÉÓòÙ×÷¡£¹ÜÀíµÄcrs×ÊÔ´°üÀ¨Êý¾Ý¿â¡¢ÊµÀý¡¢¼àÌý¡¢ÐéÄâIP£¬ons£¬gds»òÕßÆäËû£¬²Ù×÷°üÀ¨Æô¶¯¡¢¹Ø±Õ¡¢¼à¿Ø¼°¹ÊÕÏÇл»¡£¸Ä½ø³ÌÓÉrootÓÃ
Ïà¹ØÎĵµ£º
LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......
ÐèÒª´óÁ¿oracle²âÊÔÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ·½·¨¡£
DECLARE
i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
i := i + 1;
INSERT INTO TEST_TABLE(ID, XM) VALUES(i, 'ÐÕÃû' || i);
END LOOP;
COMMIT;
END; ......
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......
select nvl2(replace(translate('69584.00.00','.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber from dual;
select id,nvl2(replace(translate(id,'.0123456789','000000000000'),'0',''),'·ñ','ÊÇ') IsNumber
from tbl2 ......
ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓкܶàµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......