ÍÆ¼öЩORACLE·½ÃæµÄÊé - Oracle / »ù´¡ºÍ¹ÜÀí
×îºÃÊÇÓеç×Ó°æµÄ ¿ÉÒÔ´ÓÈëÃÅ¿ªÊ¼ ÎÒµÄÄ¿µÄ²»ÊÇÓÃORACLE×öÔöɾ¸Ä²é»òÕßдʲô´æ´¢¹ý³Ì Ö»ÊÇÏ£Íû´ÓÒ»¸ö±È½ÏµÍµÄÆðµãÈ¥Á˽âÕâ¸öÊý¾Ý¿â~ лл(ÎÒÕâÀàÎÊÌâ¸Ã·¢µ½Äĸö°æ?)
ÓиöpptµÄ½Ìѧ£¬¿ÉÒÔ¸øÄãÒýÓà Oracle 11g »ù´¡ÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³Ì »ù´¡µÄÊé²»¹ó£¬¿ÉÖ§³ÖÒ»ÏÂ×÷Õß ¾«Í¨Oracle 10g PL/SQL±à³Ì ÎÒºÃÏóÓÐÕâһϵÁÐµÄÆäÖÐÒ»±¾Êé (¾«Í¨Oracle 10g SQLºÍPL/SQL±à³Ì) Ë®ÀûË®µç³ö°æÉçµÄ? ÎÒÊÖÍ·Õâ±¾ ¸øÎҸоõ½Ú×àÌ«¿ì ²»ÊÇ˵Ëû²»ºÃ(ÊÇÎÒ¼ûµ½¹ý×î²»·Ï»°µÄÒ»±¾Êé..) µ«ÊÇÎÒÏëÈ¥Á˽âÕâ¸öÊý¾Ý¿â Á˽âÈ»ºóȥʹÓà ÏÖÔÚÎÒÊÖÍ·Óб¾ÀàËÆÎÒ˵µÄÊé µ«ÊÇÎÒ¿´²»Ì«¶®°¡.. ÄúÍÆ¼öµÄÊéÎÒÔÚÏ ÏÈ¿´¿´¿© 153996072@qq.com ÎÒµÄÓÊÏä ¸÷λ´ó¸çÒ²¿ÉÒÔ¼ÓÏÂÎÒµÄQQ ÎÒѧϰѧϰ »ù´¡µÄÄǾÍÊÇÊý¾Ý¿âÔÀíÁË· Íõº£ÁÁºÍ¸Ç¹úÇ¿µÄÊé²»´í£¬Â¥Ö÷¿ÉÒÔ°Ù¶ÈÒ»ÏÂËûÃǵÄÊé ²»´íµÄ£¬Ð»Ð»¡£ ·¢ÁË£¬¼ÇµÃ¸øÎÒ¼Ó·Ö!!!ºÙºÙ!!!!ÒýÓà ¾«Í¨Oracle 10g PL/SQL±à³Ì ÊǵÚÒ»°æ ÎÒ¿´ÁËÕâ±¾µç×Ó°æµÄ ¾«Í¨Oracle 10g SQLºÍPL/SQL±à³Ì Êǵڶþ°æ,ÎÒÅóÓÑÄÇÓÐÊé,Ò²¿´ÁËÏÂ.Ôö¼ÓÁËЩÄÚÈÝ 2±¾¶¼²»´í ÔõôÐÎÈݵڶþ±¾ÄØ ¿ÉÒÔÕâô˵ ÎÒÊÇ´Ó»ù´¡¿ªÊ¼¿´µÄ Ê×ÏÈ´ò¿ªÊé È»ºó¿´ ´ÓµÚÒ»Ò³¿´µ½50Ò³ È»ºóºÏÉÏÊé ûÓÐÈκβ»ÊÊ.. ËٶȾÍÊÇÕâô¿ì... ÎÒÒ²Ïëѧoracle£¬µ«ÊÇÊéÉÏдµÄÓеIJ»Ì«ºÃÀí½â¡£²»ÖªµÀ¿ÉÓÐÕâ·½ÃæµÄÅàѵ ÎÒ¿´oRACLEµÄÊéµÄʱºò¾Í¸Ð¾õ ¿ªÍ·¶®µÄ ºóÀ´¾Í²»´ó¶® Ò²Ðíû×Ðϸ¿´ ºÇºÇ ºÍÂ¥Ö÷¹²Í¬Ñ§Ï° °ï¶¥¸ö Oracle 11g »ù´¡ÓëÌá¸ß ¾«Í¨Oracle 10g PL/SQL±à³
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡± ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ ʹÓÃmicrosoft ole db pro ......