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

OracleºÍTomcat¶Ë¿Ú³åÍ»

OracleºÍTomcat¶Ë¿Ú³åÍ»
Ô­Òò:
    Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈÏ°üº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
 1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Define a non-SSL Coyote HTTP/1.1 Connector on the port specified during installation -->
     <Connector port="8080"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
                enableLookups="false" redirectPort="8443" acceptCount="100"
                debug="0" connectionTimeout="20000"
                disableUploadTimeout="true" />            ÐÞ¸Äport="8080"¼´¿É¡£
2.¸Ä¶¯oracle µÄXDB 8080¶Ë¿Ú
·½·¨1:(ÒѲâÊÔ)
   ½øÈë database configuration assistant £¬Ò»Â·Nextºó»á¿´µ½£¬“ÔÚÊý¾Ý¿âÖÐÅäÖÃÊý¾Ý¿âÑ¡Ï¬Ñ¡ÔñÄãÒªÐ޸ĵÄÊý¾Ý¿â—>³öÏÖ“Êý¾Ý¿âÌØÐÔ”±êÇ©£¬µã“±ê×¼Êý¾Ý¿â¹¦ÄÜ”£¬ÔÙµã“×Ô¶¨Òå”°´Å¥£¬¾ÍÄÜ¿´µ½ÅäÖö˿ڵÄÐ޸ĵط½¡£
·½·¨2:(ÒѲâÊÔ)
ʹÓÃsys(SYSTEM)µÇ¼Oracle SQL Plus£¬ÀûÓÃdbms_xdbÐ޸Ķ˿ÚÉèÖÃ.ÊäÈëÒÔÒÔÏ´úÂë:
  SQL> -- Change the HTTP/WEBDAV port from 8080 to 8081
  SQL> call dbms_xdb.cfg_update(updateXML(
           dbms_xdb.cfg_get()
         , '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()'
         , 8081))
     /
³É¹¦Ìáʾ:
Call completed.
SQL> -- Change the FTP port from 2100 to 2111
  SQL> call dbms_x


Ïà¹ØÎĵµ£º

OracleʹÓõÄhintsµ÷Õû»úÖÆ

 
10gÊý¾Ý¿â½éÉÜ£º¿ÉÒÔʹÓøü¶àеÄoptimizer hintsÀ´¿ØÖÆÓÅ»¯ÐÐΪ¡£ÏÖÔÚÈÃÎÒÃÇ¿ìËÙ½âÎöÒ»ÏÂÕâЩǿ´óµÄÐÂhints:
spread_min_analysis

ʹÓÃÕâÒ»hint£¬Äã¿ÉÒÔºöÂÔһЩ¹ØÓÚÈçÏêϸµÄ¹ØϵÒÀÀµÍ¼·ÖÎöµÈµç×Ó±í¸ñµÄ±àÒëʱ¼äÓÅ»¯¹æÔò¡£ÆäËûµÄһЩÓÅ»¯£¬Èç´´½¨¹ýÂËÒÔÓÐÑ¡ÔñÐԵĶ¨Î»µç×Ó±í¸ñ·ÃÎʽṹ²¢ÏÞÖÆÐÞ¶©¹æÔòµÈ£¬µÃµ ......

oracleÖÐrownumµÄÓ÷¨

 
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂΪתÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......

Oracleѧϰ±Ê¼Çժ¼5

 Êý¾Ý¿â¶ÔÏó
<1>±í(Ô¼Êø)
<2>ÈçºÎ×Ô¶¯±àºÅ
SQLserver
  --IDENTITYÊôÐÔ
  create table test(
    xh int identity(1,2) primary key,
    name varchar(20)
);
  insert into test(name) values ('mike');
ORACLE
  Ò»¸ö¶ÔÏó(ÐòÁÐsequenc ......

hpux+slvm+mc/sg+oracle 10g racʵʩÊÖ²á

 Ó²¼þ»·¾³:hp rx2660*2+hp eva4400
Èí¼þ»·¾³:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.18
1.°²×°HPUX
2.´ò²¹¶¡,²ÎÕÕÎĵµ¼´¿É,»ò´òµ½magepatch dec.12.07ÒÔºóÒ²¿ÉÒÔ
3.°²×°mc/sg+SGeRAC(hp MC/ServiceguardΪÅäºÏoracle racËùʹÓõÄÄ£¿é)
4.¹æ»®´æ´¢
lock vg:1G
rac:100G
5.ÐÞ¸ÄÄÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ