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

ɨä ORACLE RACµÄ°Ù¿Æ½éÉÜ

Oracle RAC
¡¡¡¡RAC£¬È«³Æreal application clusters£¬ÒëΪ“ÕæÕýÓ¦Óü¯Èº”£¬ ÊÇOracleаæÊý¾Ý¿âÖвÉÓõÄÒ»Ïîм¼Êõ£¬Ò²ÊÇOracleÊý¾Ý¿âÖ§³ÖÍø¸ñ¼ÆËã»·¾³µÄºËÐļ¼Êõ¡£
¡¡¡¡Oracle RACÖ÷ÒªÖ§³ÖOracle9i¡¢10g¡¢11g°æ±¾£¬¿ÉÒÔ¿ÉÒÔÖ§³Ö24 x 7 ÓÐЧµÄÊý¾Ý¿âÓ¦Óà ϵͳ£¬Ôڵͳɱ¾·þÎñÆ÷ÉϹ¹½¨¸ß¿ÉÓÃÐÔÊý¾Ý¿âϵͳ£¬²¢ÇÒ×ÔÓɲ¿ÊðÓ¦Óã¬ÎÞÐèÐ޸ĴúÂë¡£
¡¡¡¡ÔÚOracle RAC»·¾³Ï£¬Oracle¼¯³ÉÌṩÁ˼¯ÈºÈí¼þºÍ´æ´¢¹ÜÀíÈí¼þ£¬ÎªÓû§½µµÍÁËÓ¦Óóɱ¾¡£µ±Ó¦ÓùæÄ£ÐèÒªÀ©³äʱ£¬Óû§¿ÉÒÔ°´ÐèÀ©Õ¹ÏµÍ³£¬ÒÔ±£Ö¤ÏµÍ³µÄÐÔÄÜ¡£
¡¡¡¡Oracle RACÒ»°ãÒ²¿É¹¹½¨ÓÚ´óÐÍSMPÖ÷»ú£¬IBMµÄAIXϵÁзþÎñÆ÷ÍùÍùÊÇÆäÖÐ¸ß¶ËÆ½Ì¨£¬Intel LinuxÍùÍù×÷ΪÆäµÍ¶Ëƽ̨¡£µ±AIX UNIXÓÃÀ´ÔËÐÐOracle RAC×÷Ϊ´óÐÍÊý¾Ý¿âϵͳƽ̨ʱ£¬Æä¼¯ÈºÏµÍ³¹¹½¨¡¢ÊµÊ©¡¢ÔËά¡¢¸ß¿ÉÓÃÉèÖã¬ÓÐÆäÆ½Ì¨ÌØµã¡£¿ÉÒÔ²ÎÕÕ¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/UNIXÉϵÄʵսÏê½â¡·£¬¸ÃÊéÒÔAIX UNIXƽ̨ΪÖ÷Ïߣ¬ÒÔÆäËûUNIXϵͳΪ²ÎÕÕ£¬ÃèÊöÁËÊý¾Ý¿âϵͳOracle 10g¡¢Oracle 11gµÄRACµÄ¹¹¼Ü·½·¨ºÍ¹ý³Ì¡£ÔÚLinuxƽ̨£¬Ôò¡¶´ó»°OracleRAC¼¯Èº¡¢¸ß¿ÉÓÃÐÔ¡¢±¸·ÝÓë»Ö¸´¡·ÓÐןܺõÄÂÛÊö¡£
      PowerBuilder 11ÒÔºóµÄ°æ±¾,ÔÚÔ­Óлù´¡ÉÏÔö¼ÓÁ˶Ôoracle racµÄÖ§³Ö.ÁíÍ⻹Ôö¼ÓÁ˶Ômobilink(Ó¦¸ÃÊÇSQL anywhereµÄͬ²½¼¼Êõ°É?)µÄÖ§³Ö.


Ïà¹ØÎĵµ£º

Oracle»ù´¡Ñ§Ï°±Ê¼Ç

1.sqlplus-----¿ªÆô·þÎñ
2.ÊäÈëÓû§ÃûºÍÃÜÂ루ĬÈÏ3¸öÓû§,×¢Ò⣬ÃÜÂëÊÇ¿ÉÒÔÐ޸ĵģºsystem/manager;scott/tiger;sys/change_on_install£©£¬Á¬½ÓÊý¿â¡£
3.´´½¨±í¿Õ¼ä£º
 create tablespace ±í¿Õ¼äÂß¼­Ãû datafile '±í¿Õ¼äÎļþµÄÎïÀíÂß¼­'
 size Îļþ´óС£¨È磺10m£© autoextend ÊÇ·ñ×Ô¶¯Ôö³¤Îļþ´óС£¨on/off ......

ÍÆ¼öѧϰOracleµÄºÃÊé

    ¸Õ¿ªÊ¼Ñ§Ï°Orace£¬Óöµ½Ò»Ð©·Ç³£ºÃµÄÊ飬ÔÚÏÂÃæÁгö£¬Ëæ×ÅѧϰµÄÉîÈë»á°ÑÓöµ½µÄºÃÊé¶¼ÁгöÀ´£¬¹©Ñ§Ï°OracleµÄÅóÓѲο¼£¬
Ò²»¶Ó­¸÷λÅóÓѲ¹³ä£º
»ù´¡£º
      1. ORACLE DBA»ù´¡Åàѵ½Ì³Ì      ºÎÃ÷Öø            Ç廪´óѧ³ö°æÉç
&n ......

¡¾×ª¡¿ ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ

ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍÆ³öÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......

ϲ»¶oracleÕâÔò¹ã¸æ

Ô­Á´½Ó£ºhttp://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=7731619&src=6817982&Act=4&sckw=APACMK09050910MPP005.GCM.8074.110
ÄÜ·ñÔÚµÚһʱ¼ä
      »ñµÃÐÂÕ½ÂԵķ´À¡Òâ¼û£¿
ÄÜ·ñͨ¹ý¹ÜÀíÄ£ÐÍ
      À´Ô¤²âÒµÎñÊý¾Ý£¿ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç25

¹ý³ÌÖеÄÊÂÎñ
¶¨Òå¹ý³Ìp1
create or replace procedure p1
as
begin
insert into student values(5,'xdh','m',sysdate);
rollback;
end;
¶¨Òå¹ý³Ìp2
create or replace procedure p2
as
begin
update student set stu_sex = 'a' where stu_id = 3;
p1;
end;
Ö´Ðйý³Ìp2

exec p2;
Ö´ÐÐÍê±Ï·¢ÏÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ