½â¾öOracle ºÍTomcat¶Ë¿Ú³åÍ»(תÔØ)
·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½·¨£º
Ò»¡¢¸ü¸ÄTOMCATµÄĬÈ϶˿Ú
Ïà¹ØÎļþ£º"TOMCAT ROOT"confserver.xml
¶þ¡¢Ê¹ÓÃsysµÇ¼Oracle£¬ÀûÓÃdbms_xdbÐ޸Ķ˿ÚÉèÖÃ
SQL> call dbms_xdb.cfg_update(updateXML(
2 dbms_xdb.cfg_get()
3 , '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()'
4 , 8081))
5 /
ÔËÐÐÍêºóÌáʾ£ºCall completed.
½Ó×Å
SQL> COMMIT;
Ìáʾ£ºCommit complete.
SQL> EXEC dbms_xdb.cfg_refresh;
Ìáʾ£ºPL/SQL procedure successfully completed.
Èý¡¢Ê¹ÓÃEnterprise Manager Console£¬Ñ¡ÔñÊý¾Ý¿â——XML Êý¾Ý¿â——ÅäÖ㬸ü¸Ähttp-portµÄĬÈÏֵΪ8081¡£
·½°¸¶þ£º
°²×°OracleÊý¾Ý¿âºó£¬µ±ÎÒÃÇ·ÃÎÊ8080¶Ë¿Úʱ£¬»áµ¯³öÒ»¸öXDB´°¿Ú£¬ÒªÇóÊäÈëÓû§ÃûºÍÃÜÂë¡£ÕâÑù½«ºÍÎÒÃDZ¾µØһЩʹÓøö˿ڵÄÓ¦ÓóåÍ»£¬±ÈÈçtomcat¡¢jbossµÈ£¬ËäÈ»ÕâЩ¶Ë¿ÚÊÇ¿ÉÒÔÐ޸ĵģ¬µ«×ÜÊDz»Ë¬oracleÒ»Ö±Õ¼ÓÃÕâ¸ö¶Ë¿Ú¡£
OracleÊý¾Ý¿â¿ÉÒÔʹÓÃTCPÐÒéͨ¹ý8080¶Ë¿Ú½øÐÐÁ¬½Ó£¬ËùÒÔÕ¼ÓÃÁË8080¶Ë¿Ú¡£
ҪȡÏûÕ¼Ó㬿ÉÒÔ´ò¿ªOracle°²×°Ä¿Â¼ÏµÄdatabaseĿ¼ÄÚµÄSPFILE[SIDÃû].ORAÎļþ½øÐÐÐ޸ġ£Õâ¸öÎļþÊÇOracleµÄÆô¶¯ÅäÖÃÎļþ¡£
°ÑÆäÖеÄ*.dispatchers='(PROTOCOL=TCP) (SERVICE=or9iXDB)'ÕâÒ»ÐÐÈ¥µô¼´¿É¡£
È»ºóÖØÆô¼ÆËã»ú£¬»òÕßÔÚ·þÎñÖÐÖØÆôOracleService[SIDÃû]Õâ¸ö·þÎñ¡£ÖØÆôºó¿ÉÄÜÎÞ·¨Ê¹ÓÃEnterprise Manager ConsoleºÍÆäËû¿Í»§¶ËÁ¬½Ó£¬ÕâʱÇëʹÓÃOracleµÄConfiguration and Migration Tools/Net Configuration Assistant¹¤¾ßɾ³ý¼àÌýÆ÷£¬È»ºóн¨Ò»¸ö¼àÌýÆ÷£¬ÖØÆô¼àÌýÆ÷¡£
ʹÓÃConfiguration and Migration Tools/Net Manager¹¤¾ß£¬½«·þÎñÃüÃûɾ³ý£¬È
Ïà¹ØÎĵµ£º
// ½¨Á¢±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
create TABLESPACE EAS_D_sptcc0_STANDARD DATAFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD.dbf' size 10000M EXTENT MANAGEMENT local;
// ɾ³ý±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
DROP TABLESPACE temp_data INCLUDING CONTENTS AND DATAFILES;
// ½¨Á¢ÁÙʱ±í¿Õ¼ä¡£
CREATE TEMPORARY TABLESPA ......
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º
create table myseq ( &nb ......
http://www.anysql.net/oracle/oracle_olap_dimension.html
ÔÚOracleµÄÊý¾Ý²Ö¿â(OLAP)ÖÐ, ʵÌ廯ÊÓͼ(MVIEW), ²éѯÖØд(Query Rewrite)ºÍά(Dimension)ÊǷdz£ÖØÒªµÄÓÅ»¯ÊÖ¶Î, ¶ÔÓÚÇ°Á½ÕßÎÒ²»ÏëÔÚÕâ¶ùÖظ´½²ÁË, Ö÷ÒªÀ´ÌåÑéÒ»ÏÂάµÄ×÷ÓÃ. Òª·¢»ÓάµÄ×÷ÓÃ, »¹ÊÇÐèÒªÓõ½Ç°ÃæÁ½Õß, ÏÂÃæÊÇÎÒÉè¼ÆµÄÖ»ÓÐÒ»¸öά±íµÄ×î¼òµ¥µÄÀý×Ó ......
Checkpoint
ºÜ¶àÈ˶¼°ÑcheckpointµÄ¸ÅÄî¸ø¸´ÔÓ»¯ÁË£¬ÆäʵcheckpointÕâ¸öÊý¾Ý¿â¸ÅÄîÒýÈëµÄÕæÕýÒâÒå¾ÍÊÇÓÃÀ´¼õÉÙÔÚÊý¾Ý¿â
»Ö¸´¹ý³ÌÖÐËù»¨µÄʱ¼ä(instance recovery),ÄÇôcheckpointÊÇÓÉËÀ´×öµÄÄØ?ÎÒÃǶ¼ÖªµÀÊý¾Ý¿âÖÐÓиöCKPT½ø³Ì£¬ÕâÊǸö
¿ÉÑ¡½ø³Ì£¬µ«ÊÇÕæÕýÖ´Ðмì²éµãµÄÈÎÎ ......