Oracle ÊÕ¹ºSunÖ®ºóµÄÑÝÒ壺IBM ºÍSAPºÎÈ¥ºÎ´Ó
SunÖÕÓÚµ¹ÏÂÁË£¬Ò»¸ö²»µ«´´Ôì¼¼ÊõÉñ»°£¬¸øÊÀ½çIT¼¼Êõ´øÀ´¸ïÃüÐÔÓ°ÏìµÄ¹«Ë¾µ¹ÏÂÁË£¬ÎÒ»³ÄîËü¡£
ÎÒ¸öÈËÈÏΪORACLEºÍSUNµÄºÏ²¢£¬ÊÇÁ½¼Ò
¹«Ë¾µÄÐÒÊ£¬ORACLE½øÒ»²½ÍêÉÆÁ˲úÆ·Ïߣ¬²¢ÇÒ·ûºÏÁËĿǰSaaSºÍÔÆ¼ÆËãµÄÇ÷ÊÆ£¬³ÉΪһ¸öÔÚ²úÆ·ÏߺͷþÎñÉÏ¿ÉÒÔºÍIBM½øÐоºÕùµÄ¹«Ë¾£¬¶øSUNµÄ
¼¼Êõ¿ÉÄܻᱻORACLE¹«Ë¾µÄÓªÏúÄÜÁ¦·½·¨£¬Ê¹SUNµÄ¼¼Êõ¸ü¼Ó·¢Ñï¹ã´ó¡£
²»ÐÒµÄÊÇIBMºÍSAP,×î½ü¼¸Ä꣬IBMµÄÖмä¼þºÏ×÷»ï°é
Siebel¡¢PeopleSoft¡¢JDEµÈÏà¼Ì¸øORACLE¹ºÂò£¬¶ø2010ÄêÊÇORACLEÕûºÏÕâЩ¹«Ë¾×î¼ÑÒµÎñʵ¼ù¡¢ÍƳöÐÂÒ»´ú²úÆ·
ORACLE Fusion
ApplicationsµÄʱ¼ä;ORACLE¹«Ë¾ÔÚ¹ýÈ¥¼¸ÄêÊÕ¹ºÓ¦ÓÃÈí¼þ¹«Ë¾µÄЧ¹û½«»áÏÔÏÖ£¬IBMµÄÖмä¼þ½«»á»áÊܵ½³å»÷£¬SaaSµÄ³öÏÖ½«µ¼ÖÂ
IBMµÄ¶ÀÁ¢Èí¼þ¿ª·¢É̵ļõÉÙ£¬ÕâÊÇÒ»¸öÇ¿Õ߸üÇ¿µÄʱ´ú£»¹ýÈ¥IBM²»×öÓ¦ÓÃÈí¼þ¶ø±ÜÃâºÍ¶ÀÁ¢Èí¼þ¿ª·¢É̵IJßÂÔ½«»áÊܵ½Ó°Ïì¡£
¶øSAPÒòΪ¹ÅÀϵÄ
¼¼Êõ£¬²»Á÷ÐеÄÖмä¼þ£¬Á½ÖÖ¿ª·¢ÓïÑԵĵ¼Öµĸ߳ɱ¾ÊµÊ©³É±¾£¬·Ö¸îµÄÊý¾Ý¿âÉè¼ÆµÈ¶àÖÖÔÒòµ¼ÖµÄÓû§·ÃÎÊËÙ¶È»ºÂýÊÆ±ØÓ°Ïì¿Í»§µÄÑ¡Ôñ£¬²»¹ÜSAPµÄ¹ÜÀí˼
ÏëºÍ×î¼úÒµÎñʵ¼ù¶àôÁìÏÈ£¬ÆóÒµ¹ÜÀíÈí¼þÖÕ¾¿ÊÇÈí¼þ£¬Ò»¸öÔÚÈí¼þ¼¼ÊõÉÏÂäºóµÄ¹«Ë¾ÏòÓÀÔ¶´¦ÓÚ°ÔÖ÷µØÎ»ÊǺÜÄѵġ£
ÎÒµÄÒÉÎÊÊÇIBM»á×öÆóÒµ¹ÜÀíÈí¼þÂð£¿Èç¹û²»×ö£¬ÈçºÎÃæ¶Ôoracleһͳ½ºþµÄ¾ÖÊÆ¡£SAPÈçºÎÃæ¶ÔORACLE Fusion Applications¿ÉÄÜ´øÀ´µÄ³å»÷£¬IBM»áͶ×Ê»òÕß¹ºÂòSAPÂð£¿
´ÓÀíÂÛÉϽ«£¬SAPÁªºÏIBMÔÚIBMÖмä¼þÉÏÖØÐÂʵÏÖSAP Business SuiteÐèÒªµÄʱ¼äÓ¦¸Ã±ÈORACLE×öORACLE Fusion Applications¶Ì£¬µ«ÊÇSAP¿ÉÄܲ»Ô¸ÒâÃæ¶ÔÏÖʵ£¬ÈÎȻҹÀÉ×Ô´óµÄÈÏΪ¿Í»§»áËÀÐÄËúµØµÄÑ¡Ôñ×Ô¼º¡£
IBM×Ô¼ºÈ¥×öÆóÒµ¹ÜÀíÈí¼þÊÆ±ØºÍ¶ÀÁ¢Èí¼þ¿ª·¢É̲úÉú¾ºÕù£¬ºÃÏñÒ²²»´ó¿ÉÄܲÉÓô˲ßÂÔ£¬¶ø·öÖ²ºÍͶ×ÊÓоºÕùÁ¦µÄ¶ÀÁ¢Èí¼þ¿ª·¢É̾ͳÉΪĿǰΨһµÄÑ¡Ôñ£¬µ«ÊÇ·ÅÑÛÈ«Çò£¬Äܹ»ºÍSAPºÍORACLE¾ºÕùµÄ¹«Ë¾¼¸ºõûÓС£Èç¹ûÓУ¬Î´±Ø½«À´²»±»oracleÊÕ¹º¡£
¿ÉÄÜÖ§³Ö¿ªÔ´ÆóÒµ¹ÜÀíÈí¼þÊÇÒ»¸ö²»´íµÄÑ¡Ôñ£¬Ö§³ÖÒ»¸öÔÚIBMÖмä¼þÉϵĿªÔ´ÆóÒµ¹ÜÀíÈí¼þ¿ÉÒÔʹIBMµÄÖмä¼þ±éµØ¿ª»¨
Ïà¹ØÎĵµ£º
oracle²¹¶¡ÏÂÔØµØÖ·
DB 2009-10-28 18:00 ÔĶÁ56 ÆÀÂÛ0
×ֺţº ´ó´ó ÖÐÖРСС
Oracle 11g 11.1.0.7
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_2of2.zip
ftp://upda ......
Ë÷Òý¾Û´Ø±í
create cluster emp_dept_cluster
(deptno number(2)) size 1024;
size 1024 ±íʾÿ¸ö¾Û´Ø¼üÖµ¹ØÁª´óÔ¼1024×Ö½ÚµÄÊý¾Ý,
oracle»áÔÚÓÃÕâ¸öÊý¾Ý¿â¿éÉÏͨ¹ýsize¼ÆËã×î¶à¿ÉÒԷŶàÉÙ¸ö´Ø
Èç¹û¿éÊÇ8KB,ÄÇôÕâ¸ö¿éÉÏ×î¶à·Å7¸ö¾Û´Ø¼ü
Ïò¾Û´ØÖзÅÊý¾Ý֮ǰ,ÐèÒªÏȶԾ۴ؽ¨Á¢Ë÷Òý.
create index emp_dept_cluster_id ......
ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......
OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......
ÀûÓÃosÉóºË
µÇ¼oracleʱÔÚWinÖÐʵÏÖ¶ÔosµÄÉóºËÓÐÈçϼ¸²½£º
1¡¢ create os user id
2¡¢ create os group ora_dba(Õâ¸ö×éÖÐÓû§¾ßÓйÜÀíËùÓÐoracle database µÄȨÏÞ),
ora_sid_dba£¨Ö»ÄܶÔÓ¦µ½ÏàÓ¦sidµ ......