XML Database （XDB）使我们能够使用FTP和HTML协议访问和管理ASM磁盘组中的文件，可以方便的浏览和移入和移出。

Oracle9i 支持 XML 数据库， 8080 是 Oracle XDB （ XML 数据库） Http 服务的默认端口， Oracle XDB 的Ftp 服务，默认端口是 2100 。这2个端口与Tomcat 的端口是冲突的，所以我们在设置的时候可以改成其他端口。如：HTTP:8888, FTP: 2222。

【修改之前】

一. 查看端口信息

在Oracle 10g默认情况下，数据库FTP 和 HTTP的端口是关闭的。这个我们可以通过如下两个函数来验证。

[oracle@yitai ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 21:14:47 2012

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select dbms_xdb.getftpport from dual;

GETFTPPORT
----------
0

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
-----------
0

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
prod OPEN

二. 查看监听

先查看一下监听，等会修改之后好做个对比：

[oracle@yitai ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-AUG-2012 21:15:06

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yitai.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                27-AUG-2012 21:12:48
Uptime                    0 days 0 hr. 2 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yitai.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "prod" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
Service "prodXDB" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
Service "prod_XPT" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
The command completed successfully

【修改之后】

三. 配置FTP 和 HTTP 端口

SQL> exec dbms_xdb.setftpport(2222);

PL/SQL procedure successfully completed.

SQL> exec dbms_xdb.sethttpport(8888);

PL/SQL procedure successfully completed.

查看端口信息：

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
-----------
8888

SQL> select dbms_xdb.getftpport from dual;

GETHTTPPORT
-----------
2222

四. 再次查看监听：

[oracle@yitai ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 27-AUG-2012 21:21:30

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yitai.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                27-AUG-2012 21:12:48
Uptime                    0 days 0 hr. 8 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yitai.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yitai.com)(PORT=2222))(Presentation=FTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yitai.com)(PORT=8888))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "prod" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
Service "prodXDB" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
Service "prod_XPT" has 1 instance(s).
Instance "prod", status READY, has 1 handler(s) for this service...
The command completed successfully