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µÄÖмä¼þ±éµØ¿ª»¨
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
sql> alter system set job_queue_processes=n;£¨n>0£©
job_queue_processes×î´óֵΪ1000
²é¿´¸ÃÖµ show parameter processes
²é¿´job queue ºǫ́½ø³Ì
sql>select name,description from v$bgprocess;
¶þ£¬dbms_job package Ó÷¨½é ......
ÔÚwindow·þÎñÆô¶¯Ê±²¢²»Æô¶¯ÊµÀýµÄÁ½ÖÖ·½·¨:
¡¡¡¡(1)ͨ¹ýoradim startup ²ÎÊýÉ趨,ÈçÏÂ:
¡¡¡¡a.²é¿´oradim°ïÖú
C:Documents and SettingsAdministrator>oradim help
DIM-00002: ÓÐЧµÄÃüÁî°üÀ¨: -DELETE, -EDIT, -NEW, -STARTUP ºÍ -SHUTDOWN
¡¡¡¡ÇëÊäÈëÒÔÏÂÃüÁîÖ®Ò»:
¡¡¡¡Í¨¹ýÖ¸¶¨ÒÔϲÎÊý´´½¨Àý³Ì:
-NEW - ......
ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......
ÔÎĵØÖ·oracle lock
1ÓÃPerl TKÄ£¿é ²éѯDBÖеÄLOCK
use DBI;
use Tkx;
use DBD::Oracle qw(:ora_session_modes);
$mw = Tkx::widget->new(”.”);
$mw->g_wm_title(”Oracle Lock”);
$content = $mw->new_ttk__frame(-padding => “5 5 12 0″);
$content->g_grid ......
ÀûÓÃosÉóºË
µÇ¼oracleʱÔÚWinÖÐʵÏÖ¶ÔosµÄÉóºËÓÐÈçϼ¸²½£º
1¡¢ create os user id
2¡¢ create os group ora_dba(Õâ¸ö×éÖÐÓû§¾ßÓйÜÀíËùÓÐoracle database µÄȨÏÞ),
ora_sid_dba£¨Ö»ÄܶÔÓ¦µ½ÏàÓ¦sidµ ......