oracle¶Ë¿ÚµÄ¼òµ¥ÎÊÌâ
×î½üͬʱʹÓÃoracle 10gºÍtomcat£¬ÔÚʹÓùý³ÌÖз¢ÏÖÁËЩÎÊÌ⣺ 1¡¢tomcatºÍoracle¼àÌý³ÌÐòͬʱÆô¶¯Ê±£¬tomcat±¨´í£¨tomcatÆô¶¯Ê±Í¨¹ýeclipseÆô¶¯µÄ£© 2¡¢ÍøÉÏ˵oracle¼àÌý³ÌÐòÕ¼ÓÃÁË8080¶Ë¿Ú£¬µ«ÊÇÎÒÔÚ.net assistantÀïÃæ¿´ÁËÏ£¬ ÎÒ¼àÌý³ÌÐòʹÓõĶ˿ÚÊÇ1521£¬²¢²»ÊÇ8080¶Ë¿Ú£¬ÎªÊ²Ã´¶Ë¿Ú»¹»á³öÏÖ³åÍ»ÄØ£¿ 3¡¢¼àÌý³ÌÐòµÄ8080¶Ë¿ÚºÍ1521¶Ë¿ÚÓÐʲô¹ØÏµÂ𣿠Óöµ½ÕâÖÖÎÊÌâÓÐʲôºÃµÄ½â¾ö·½°¸Âð£¿Ï£ÍûÄܹ»¾ßÌåÒ»µã£¬Ð»Ð»
ÎÒÖ»ÖªµÀĬÈϵÄÊÇ1521¶Ë¿Ú,ÄãÊDz»ÊǸü¸ÄÁË? °ï¶¥. tomcatĿ¼ÏÂconf/server.xml ÖУ¬°ÑËùÓеÄport="8xxx"È«»»³Éport="9xxx"£¬Ò»°ãÇé¿öÏ£¬²»»áÓгåÍ»µÄÎÊÌâ ÎÒÕâ±ßûÕâÑùµÄÎÊÌâÒ² ÄãÈ·¶¨oracleµÄlistenerûÓÐÆô¶¯Ê±tomcat¾Í¿ÉÒÔÔËÐÐÂ𣿠ÊDz»ÊÇ ÆäËû³ÌÐòÕ¼Óö˿ÚÁË£¿ ÄãÏÈÆô¶¯oracle È»ºóʹÓà netstat -an ²éѯ¶Ë¿ÚʹÓÃÇé¿ö ¿´8080¶Ë¿ÚʹÓÃû£¿ oracleÊÇ»áÕ¼ÓÃ8080¶Ë¿ÚµÄ¡£ Ò»°ãÊǸÄtomcat£¬±Ï¾¹Êý¾Ý¿â±ÈÓ¦Ó÷¢²¼ÖØÒª¡£ conf/server.xmlÀïÃæ°Ñ8080¸Ä³É8088¡£ÆäËûµÄ²»Óøġ£ÒýÓà ÎÒÕâ±ßûÕâÑùµÄÎÊÌâÒ² ÄãÈ·¶¨oracleµÄlistenerûÓÐÆô¶¯Ê±tomcat¾Í¿ÉÒÔÔËÐÐÂ𣿠Êǵģ¬¿ÉÒÔ oracleÔÛÓÃ8080¶Ë¿Ú£¬ºÃÏñ²»»á¡£ Äã¿ÉÒÔÓÃһЩ¹¤¾ß¼ì²éÒ»ÏÂ8080¶Ë¿ÚµÄÕ¼ÓÐÇé¿ö¡£ÒýÓà tomcatĿ¼ÏÂconf/server.xml ÖУ¬°ÑËùÓеÄport="8xxx"È«»»³Éport="9xxx"£¬Ò»°ãÇé¿öÏ£¬²»»áÓгåÍ»µÄÎÊÌâ Õý½â {{----}
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í Ö»ÄÜÓÃjdbcÖ±Á¬ Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì ±ÈÈç student(studentid,classid) class(classid,classname) class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
score±í scoreid course studentid score 1 Êýѧ 2 99 2 Êýѧ 3 60 3 Êýѧ 4 80 4 ÓïÎÄ 5 79 5 ÓïÎÄ 6 58 6 ÓïÎÄ 1 66 7 Ó¢Óï 6 76 8 Ó¢Óï 4 87 9 Ó¢Óï 3 100 10Ó¢Óï 2 69 ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......