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
Ïà¹ØÎĵµ£º
10gÊý¾Ý¿â½éÉÜ£º¿ÉÒÔʹÓøü¶àеÄoptimizer hintsÀ´¿ØÖÆÓÅ»¯ÐÐΪ¡£ÏÖÔÚÈÃÎÒÃÇ¿ìËÙ½âÎöÒ»ÏÂÕâЩǿ´óµÄÐÂhints:
spread_min_analysis
ʹÓÃÕâÒ»hint£¬Äã¿ÉÒÔºöÂÔһЩ¹ØÓÚÈçÏêϸµÄ¹ØϵÒÀÀµÍ¼·ÖÎöµÈµç×Ó±í¸ñµÄ±àÒëʱ¼äÓÅ»¯¹æÔò¡£ÆäËûµÄһЩÓÅ»¯£¬Èç´´½¨¹ýÂËÒÔÓÐÑ¡ÔñÐԵĶ¨Î»µç×Ó±í¸ñ·ÃÎʽṹ²¢ÏÞÖÆÐÞ¶©¹æÔòµÈ£¬µÃµ ......
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂΪתÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......
Êý¾Ý¿â¶ÔÏó
<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 ......
Ó²¼þ»·¾³: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.ÐÞ¸ÄÄÚ ......