oracle·ÃÎÊÖ¸¶¨Ò³ÃæÊ±µÄÉí·ÝÑéÖ¤¡£
SQL code: DECLARE req utl_http.req; resp utl_http.resp; value VARCHAR2(1000); BEGIN req := utl_http.begin_request('http://192.168.1.243:8888/test.asp'); utl_http.set_authentication(req,'domain\1085034','645312', 'Basic', true); utl_http.set_header(req, 'Content-Type', 'text/html; charset=utf-8'); resp := utl_http.get_response(req); LOOP utl_http.read_line(resp, value, TRUE); dbms_output.put_line(value); END LOOP; utl_http.end_response(resp); EXCEPTION WHEN utl_http.end_of_body THEN utl_http.end_response(resp); END; ÒòΪ¹«Ë¾¾ÖÄÚ²¿ÍøÕ¾¶¼ÊÇʹÓÃÓòÑéÖ¤µÄÐÎʽÀ´¿ØÖÆ·ÃÎÊȨÏ޵ġ£Ò²¾ÍÊǵ±utl_http·ÃÎÊÄÚ²¿ÍøÒ³ÃæÊ±£¬ÔÚ²»ÉèÖÃȨÏÞµÄÇé¿öÏ£¬»á¸ø³ö¡°Äúδ±»ÊÚ權²é¿´該頁¡±µÄÌáʾ¡£ÎÒʹÓÃÁËutl_http.set_authenticationÕâ¸ö´æ´¢¹ý³ÌÁË£¬½á¹ûÊÇÒ»ÑùµÄ²»ÐС£ ÈκÎÒâ¼û°ïÖú£¬ÎÒ¶¼¸Ð¼¤¡£
ûÓùý£¬¶¥ µÚÒ»´Î¿´¼ûÕâÑùµÄ¼øÈ¨·½Ê½£¬¹Ø×¢Ò»Ï¡£ Â¥Ö÷£¬Äܹ»°ÑÄãÕâ¸öÔõôʵÏֵĽéÉܵÄÏêϸһµãµãºÃÂð£¿Ñ§Ï°Ò»Ï¡£ÒýÓà ¥Ö÷£¬Äܹ»°ÑÄãÕâ¸öÔõôʵÏֵĽéÉܵÄÏêϸһµãµãºÃÂð£¿Ñ§Ï°Ò»Ï¡£ utl_httpÊÇoracle¸øµÄÒ»¸ö·¢ËÍhttpÇëÇóµÄ°ü£¬ÎÒÖ»ÊÇÏëÖªµÀ¶ÔÓÚÓòÑé֤ʱӦ¸ÃÔõôÓᣠ¶î¡£¡£ÎÒËæ±ã˵Á½¾ä Â¥Ö÷μû¹Ö ¸Ð¾õÕâЩҵÎñÐÔºÜÇ¿µÄ¶«Î÷Ϊʲô¶¼Òª·ÅÔÚÊý¾Ý¿âÖÐÄØ£¿·ÅÔÚÓ¦ÓóÌÐòÖÐ Èçjava .net È¥ÑéÖ¤²»¸üºÃ£¿Êý¾Ý¿â¾ÍÊÇÊý¾Ý¿â ÊÇÓÃÀ´´æ´¢¼ìË÷Ê
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #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 ÕýÈ ......