Oracle和Tomcat端口(8080)冲突的解决方法

原因:     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_xdb.cfg_update(updateXML(     2         dbms_xdb.cfg_get()     3       , '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()'     4       , 2111))     5  /

  Call completed.

接着输入以下代码(我没有输入了,似乎也可以用)   SQL> COMMIT;

  Commit complete.

  SQL> EXEC dbms_xdb.cfg_refresh;

  PL/SQL procedure successfully completed.

<script type="text/javascript"> </script> <script src="http://jsa.733.com/JS/ShowMe.js" type="text/javascript"></script> <script src="http://app4.733.com/Agent/Show.aspx?511%7C2008051904583184%7C2008041816261665%7C205027%7C0%7C0%7C2%7CMSIE%206.0%7CWindows%20NT%205.1%7Chttp%3A//www.baidu.com/s%3Fwd%3Doracle+%25BA%25CDtomcat%25B6%25CB%25BF%25DA%25B3%25E5%25CD%25BB%25B8%25C3%25D4%25F5%25C3%25B4%25B0%25EC%7Chttp%3A//www.unselectedcolor.cn/article.asp%3Fid%3D11297%7Czh-cn%7C%23000000%7C%23000000%7C%23000000%7C%23000000%7C%23000000%7Cgb2312" type="text/javascript"></script> <script type="text/javascript"> var IsFirst=true; window.οnblur=SmartADFouce; function SmartADFouce() { if(IsFirst) { window.focus(); IsFirst=false; } } </script> <script type="text/javascript"> var SmartADDoURL="http://app4.733.com/Agent/jump.aspx?126%7c2008051904583184%7c2008041816261665%7c205027%7c0%7c0%7c2%7cMSIE+6.0%7cWindows+NT+5.1%7chttp%3a%2f%2fwww.baidu.com%2fs%3fwd%3doracle+%25BA%25CDtomcat%25B6%25CB%25BF%25DA%25B3%25E5%25CD%25BB%25B8%25C3%25D4%25F5%25C3%25B4%25B0%25EC%7chttp%3a%2f%2fwww.unselectedcolor.cn%2farticle.asp%3fid%3d11297%7czh-cn%7c%23000000%7c%23000000%7c%23000000%7c%23000000%7c%23000000%7cgb2312%7c222.66.128.126%7c2008051616101220%7c8A5CB991CCABEF27D53E7CDAC1BE07A5"; var O9=Array(0,120000); var O10=Array(300000,420000,600000); var O11="",O12="",O13=0,O14=1,O15=0,O16=0,O17=0,O18=0,O19=0; function O0(O20,O21,O22){ O23=new Date(); O23.setTime(O23.getTime());//+O22*3600000 document.cookie=O20+"="+O21+";expires="+O23.toGMTString(); } function O1(O20){ var O24=O20+"="; var O25=""; if (document.cookie.length>0){ O26=document.cookie.indexOf(O24); if(O26!=-1){ O26+=O24.length;O27=document.cookie.indexOf(";",O26); if(O27==-1){ O27=document.cookie.length; } O25=unescape(document.cookie.substring(O26,O27)); } } return O25;} function O2(){ if(!O14){ O28=window.open(O12,"","width="+window.screen.availWidth+",height="+window.screen.availHeight+",top=0,left=0, toolbar=yes, menubar=yes, scrollbars=yes, resizable=yes,location=yes, status=yes");window.focus(); if(O28){ O14=1;O13++;O29=new Date().getTime();O0(O11,O13+","+O29,24); }else{ O16=1;O3(); } } } function O3(){ if(!O14 && !O15){ //if(window.Event)document.captureEvents(event.click); document.οnclick=O4; O15=1; } } function O4(){O2();} function O5(O30,O31,O36){ O33=O1(O30).split(","); if(O33.length>1){ O32=O33[0];O35=O33[1]; }else{ O32=0;O35=0; } if(O32 O9[O32]){ O11=O30;O12=O31;O13=O32;O14=0; if(!O16){O2();} } } } function O6(adtn){O19=adtn;O7();} function O7(){ O34=O1("c19").split(","); if(O34.length>1){ O17=O34[0];O18=O34[1]; }else{ O17=0;O18=new Date().getTime();O0("c19",O17+","+O18,24); } if(O17 O10[O17] && O14){ O11="c19";O12=SmartADDoURL; if(!O16){O2();}O7(); }else{ setTimeout(O8,1000); } } O6(3); function pop2_131377_2(O30,O31){O5(O30,O31,2);} function pop2(O30,O31){O5(O30,O31,2);} function pop1_131377_2(O30,O31){O5(O30,O31,1);} document.writeln(" "); O0("banner","1",0); pop2('banner01',SmartADDoURL); </script> <script type="text/javascript"> </script> <script src="http://jsa.733.com/JS/ShowMe.js" type="text/javascript"></script> <script src="http://app4.733.com/Agent/Show.aspx?306%7C2008051904583184%7C2008042112121687%7C213200%7C359%7C249%7C0%7CMSIE%206.0%7CWindows%20NT%205.1%7Chttp%3A//www.baidu.com/s%3Fwd%3Doracle+%25BA%25CDtomcat%25B6%25CB%25BF%25DA%25B3%25E5%25CD%25BB%25B8%25C3%25D4%25F5%25C3%25B4%25B0%25EC%7Chttp%3A//www.unselectedcolor.cn/article.asp%3Fid%3D11297%7Czh-cn%7C%23000000%7C%23000000%7C%23000000%7C%23000000%7C%23000000%7Cgb2312" type="text/javascript"></script> <script type="text/javascript"> var SmartADDoURL="http://app4.733.com/Agent/jump.aspx?306%7c2008051904583184%7c2008042112121687%7c213200%7c359%7c249%7c0%7cMSIE+6.0%7cWindows+NT+5.1%7chttp%3a%2f%2fwww.baidu.com%2fs%3fwd%3doracle+%25BA%25CDtomcat%25B6%25CB%25BF%25DA%25B3%25E5%25CD%25BB%25B8%25C3%25D4%25F5%25C3%25B4%25B0%25EC%7chttp%3a%2f%2fwww.unselectedcolor.cn%2farticle.asp%3fid%3d11297%7czh-cn%7c%23000000%7c%23000000%7c%23000000%7c%23000000%7c%23000000%7cgb2312%7c222.66.128.126%7c2008042112130666%7cF9C61512CEA9F86DD7C157FD9637599E"; var SourceUrl="http://img.733.com/UploadFile/20080421_1528102810.gif"; var width="359"; var height="249"; document.writeln('

'); document.write(' '); document.writeln("

"); var bodyfrm = ( document.compatMode.toLowerCase()=="css1compat" ) ? document.documentElement : document.body; var adst = document.getElementById("ad733ad_2").style; adst.top = ( bodyfrm.clientHeight - height ) + "px"; adst.left = ( bodyfrm.clientWidth - width ) + "px"; function moveR() { adst.top = ( bodyfrm.scrollTop + bodyfrm.clientHeight/2-height+100 ) + "px"; adst.left = ( bodyfrm.scrollLeft + bodyfrm.clientWidth/2-width+200) + "px"; } setInterval("moveR();", 80); drawCloseBtn(); function drawCloseBtn(){ var elem = document.createElement('div'); elem.style.background = 'url(http://img.com.com/b.gif) top right'; elem.onclick = CloseX; elem.display = 'block'; elem.style.cursor = 'pointer'; elem.style.position= 'absolute'; elem.style.right= '0px'; elem.style.top= '0px'; elem.style.height= '0px'; elem.style.width = '0px'; document.getElementById('ad733ad_2').appendChild(elem); } function CloseX(){ adst.display='none'; } </script>