Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÓÃ


Ïà¹ØÎĵµ£º

±±´óÇàÄñoracleѧϰ±Ê¼Ç26 27 28

Êý¾Ý¿â´¥·¢Æ÷
´¥·¢Æ÷Óï¾ä
    Öƶ¨´¥·¢Æ÷¶¨Ê±¡¢Ê¼þ¡¢±íÃû¼°ÀàÐÍ
´¥·¢Æ÷Ö÷Ìå
    ÊÇpl/sql¿ì»ò¶Ô¹ý³ÌµÄµ÷ÓÃ
´¥·¢Æ÷ÏÞÖÆ
    ¿ÉÒÔͨ¹ýwhen×Ó¾äʵÏÖ
DML(insert update delete)
DDL(create alter drop)
Êý¾Ý¿â²Ù×÷(servererror logo ......

LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplus

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 Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ

    ×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔÇ°·¢ÏÖ²»ÄÜÆô¶¯µÄÔ­ÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔÇ°µÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔÇ°µÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
    ×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......

Oracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨

 
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2  ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......

(ת)oracleµÄdecodeº¯Êý

DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃ; ÄØ£¿ Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ ÖеŤ×Ê×Ö¶ÎÖµ? select ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ