Oracle XMLDB 占用了8080端口

解决办法：

1. 修改XMLDB的端口设置
2. 禁止XMLDB监听端口

Change XMLDB Ports

This document explains how to change the default ports (8080 for HTTP and 2100 for FTP) in XMLDB.
Oracle XMLDB uses the ports 2100/8080 by default. Sometimes there are problem with other webservers (e.g. JBOSS) running on the same port.

Even if the package dbms_xdb is granted to PUBLIC you need DBA privileges to change the ports.
用系统管理员身份登陆
-- change HTTP port from 8080 to 8083
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));

-- change FTP port from 2100 to 2111
call dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));

-- refresh settings
exec dbms_xdb.cfg_refresh; 

命令示例：

SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;

[oracle@test11 oracle]$ sqlplus /nolog
 
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Aug 6 14:24:49 2005
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect / as sysdba;
Connected.
-- 把HTTP/WEBDAV端口从8080改到8081
SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
 
Call completed.
-- 把FTP端口从2100改到2111
SQL>  call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()',2111))
  3  /
 
Call completed.
 
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;
 
PL/SQL procedure successfully completed.
-- 检查修改是否已经成功
SQL> select dbms_xdb.cfg_get from dual;
 
CFG_GET
--------------------------------------------------------------------------------
<xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
 
SQL>

[oracle@test11 oracle]$ netstat -ntlp 
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name  
tcp        0      0 0.0.0.0:32768           0.0.0.0:*               LISTEN      -                  
tcp        0      0 127.0.0.1:32769         0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2401            0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:33730           0.0.0.0:*               LISTEN      14987/ora_d000_szdb
tcp        0      0 0.0.0.0:873             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:110             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:8081            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2111            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 :::11009                :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4001   :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4002   :::*                    LISTEN      -                  
tcp        0      0 :::9090                 :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:12005  :::*                    LISTEN      -                  
tcp        0      0 :::12009                :::*                    LISTEN      -                  
tcp        0      0 :::8080                 :::*                    LISTEN      -                  
tcp        0      0 :::80                   :::*                    LISTEN      -                  
tcp        0      0 :::22                   :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:11005  :::*                    LISTEN      -                  
[oracle@test11 oracle]$