Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ