Oracle ÊշѺÍÃâ·ÑµÄÓÐÊ²Ã´Çø±ð£¿
´ó¼ÒºÃ£¬ÎÒ¸Õ¸Õ½Ó´¥Oracle£¬ÏÖÔÚµçÄÔÀï×°µÄÊÇOracle 10G £¬°²×°Ô´ÊÇÔÚ¼×¹ÇÎĵĹٷ½ÍøÕ¾ÏÂÔØµÄ£¬ÏÖÔÚÎÒ²»Ã÷°×£¬Õâ¸ö¼¸ÍòÔªµÄÈí¼þ£¬¿ÉÒÔÃâ·ÑÓÃÂ𣿠Èç¹û²»ÊÇÃâ·ÑÓã¬ËûÓÐʲôÏÞÖÆÂð£¬ÎÒµÄÓÃ;ÊÇ£¬×Ô¼º×öÒ»¸öc/s¼Ü¹¹µÄ¹ÜÀíÈí¼þ£¬¿Í»§¶ËÓÐ120¶à£¬ÇëÎÊ£¬Èç¹ûÎÒÏëÓÃOracle Êý¾Ý¿âÊÇ·ñÐèÒª¸¶·Ñ£¿ Ï£Íû°ïæ½âÊÍÇå³þһϰ¡£¡
ÄܸüÏêϸÂ𣿠Çë×¢Ò⣬ÄãÒѾ±»Ì³×ÓÀïORACLEµÄÃÜ̽¶¢ÉÏÁË¡£ Ð꣬СÐİÀ~ ÊÕ·ÑÓÐsupport Ãâ·ÑûÓÐ Ãâ·ÑµÄÖ»ÄÜÓÃÓÚѧϰ£¬Ñо¿ÓÃ;£¬²»¿ÉÒÔÓÃÓÚÉÌÒµÓÃ;¡£ ·ÇÉÌҵʹÓÃÃâ·ÑµÄ, ÏÂÔØµÄ»ù±¾Èí¼þ¶¼Ò»Ñù£¬Ãâ·ÑµÄûÓа취»ñµÃ¹Ù·½Éý¼¶£¬¶øÇÒÖ»ÄÜÊÇ×Ô¼ºÁ·Ï°ÓᣠÄã˵µÄÇé¿ö°´ÕÕÕý³£µÄ˵Ӧ¸ÃÊÇÒªÂòOracleµÄ£¬µ«ÊDz»ÖªµÀÄãÃǵÄÏîÄ¿ÓÐûÓÐÕâ·½ÃæµÄÔ¤Ëã°¡¡£ÒýÓà Ãâ·ÑµÄÖ»ÄÜÓÃÓÚѧϰ£¬Ñо¿ÓÃ;£¬²»¿ÉÒÔÓÃÓÚÉÌÒµÓÃ;¡£ . ²»¹ýÓÐoracle express°æ±¾£¬Êý¾ÝÈÝÁ¿4G£¬Ö§³Öµ¥cpu£¬1G»¹ÊÇ2G×î´óÄÚ´æÉèÖ᣺ÃÏñ¼¸Äêǰ¾ÍÓУ¬ÆäËû²»ÖªµÀÁË¡£ ÄãÕâ¸öÈç¹ûÊÇÉÌÓ㬾ÍÊÇD°æÀ²¡£¡£¡£ 1¡¢ÊշѵÄÓзþÎñ£¬Ãâ·ÑµÄÎÞ¡£ 2¡¢ÊշѵĿÉÉÌÓã¬Ãâ·ÑµÄÉÌÓ÷¸·¨¡£ 3¡¢ÊշѵÄÁ¬½ÓÊýµÈ´óµã£¬Ãâ·ÑµÄСµã¡£ 4¡¢¸öÈËѧϰÓã¬ÊÕ·ÑÓëÃâ·ÑµÄ»ù±¾Ò»Ñù¡£ÒýÓà ´ó¼ÒºÃ£¬ÎÒ¸Õ¸Õ½Ó´¥Oracle£¬ÏÖÔÚµçÄÔÀï×°µÄÊÇOracle 10G £¬°²×°Ô´ÊÇÔÚ¼×¹ÇÎĵĹٷ½ÍøÕ¾ÏÂÔØµÄ£¬ÏÖÔÚÎÒ²»Ã÷°×£¬Õâ¸ö¼¸ÍòÔªµÄÈí¼þ£¬¿ÉÒÔÃâ·ÑÓÃÂ𣿠Èç¹û²»ÊÇÃâ·ÑÓã¬ËûÓÐʲôÏÞÖÆÂð£¬ÎÒµÄÓÃ;ÊÇ£¬×Ô¼º×öÒ»¸öc/s¼Ü¹¹µÄ¹ÜÀíÈí¼þ£¬¿Í»§¶ËÓÐ120¶à£¬ÇëÎÊ£¬Èç¹ûÎÒÏëÓÃOracle Êý¾Ý¿âÊÇ·ñÐèÒª¸¶·Ñ£¿ Ï£Íû°ïæ½âÊÍÇå³þһϰ
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......