oracle里xdb用户,修改Oracle XDB默认监听端口

默认情况下,  oracle listener监听1521 端口接受客户端对数据库的访问, 使用lsnrctl stat可以查看当前监听器的情况:

oracle@blueice:~/product/9.2.0/network/admin$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUL-2006 09:31:16

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /home/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production

System parameter file is /home/oracle/product/9.2.0/network/admin/listener.ora

Log messages written to /home/oracle/product/9.2.0/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                15-JUL-2006 09:31:16

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /home/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File         /home/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521)))

Services Summary...

Service "orcl.blueice.com" has 1 instance(s).

Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

oracle@blueice:~/product/9.2.0/network/admin$ lsnrctl stat

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUL-2006 09:31:19

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                15-JUL-2006 09:31:16

Uptime                    0 days 0 hr. 0 min. 2 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /home/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File         /home/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521)))

Services Summary...

Service "orcl.blueice.com" has 1 instance(s).

Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

使用root用户运行netstat -lnp|grep tns可以看到当前listener监听的端口

blueice:/home/oracle/product/9.2.0# netstat -lnp|grep tns

tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN     10583/tnslsnr

unix  2      [ ACC ]     STREAM     LISTENING     88815    10583/tnslsnr       /var/tmp/.oracle/s#10583.1

数据库启动后, oracle listener增加了XDB的监听端口, lsnrctl stat结果如下

blue_stone@blueice:~$ lsnrctl stat

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUL-2006 09:34:29

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                15-JUL-2006 09:31:16

Uptime                    0 days 0 hr. 3 min. 12 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /home/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File         /home/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=2100))(Presentation=FTP)(Session=RAW))

Services Summary...

Service "orcl" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orcl.blueice.com" has 1 instance(s).

Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

root用户运行netstat -lnp|grep tns结果如下

blueice:/home/oracle/product/9.2.0# netstat -lnp|grep tns

tcp        0      0 0.0.0.0:8080            0.0.0.0:*               LISTEN     10583/tnslsnr

tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN     10583/tnslsnr

tcp        0      0 0.0.0.0:2100            0.0.0.0:*               LISTEN     10583/tnslsnr

unix  2      [ ACC ]     STREAM     LISTENING     88815    10583/tnslsnr       /var/tmp/.oracle/s#10583.1

但是有些情况下, 我们并不希望8080或者2100端口被oracle使用, 这就需要修改修改oracle XDB的监听端口来达到这样的目标.

在linux下使用ftp databasehost 2100联接到oracle, 在windows下可以使用ftp://databasehost:2100/联接到oracle, 输入用户名system, 密码system的密码. 下载xdbconfig.xml文件, 使用兼容unix的编辑工具如vi或者写字板对这个文件进行修改, 如需修改ftp监听端口, 则修改

2100

local_listener

tcp

6000

中的2100为目的端口. 如许修改http监听的端口则修改

8080

local_listener

tcp

6000

XDB HTTP Server

16384

中的8080为目的端口. 修改完毕后, 上传回原来的位置. 比如我们将http监听的端口修改为8081后, 使用lsnrctl和netstat -lnp|grep tns结果如下

blue_stone@blueice:~$ lsnrctl stat

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUL-2006 09:46:06

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=blueice.blueice.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production

Start Date                15-JUL-2006 09:31:16

Uptime                    0 days 0 hr. 14 min. 50 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /home/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File         /home/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=2100))(Presentation=FTP)(Session=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blueice.blueice.com)(PORT=8081))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "orcl" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orcl.blueice.com" has 1 instance(s).

Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

Service "orclXDB" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

blueice:/home/oracle/product/9.2.0# netstat -lnp|grep tns

tcp        0      0 0.0.0.0:8081            0.0.0.0:*               LISTEN     10583/tnslsnr

tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN     10583/tnslsnr

tcp        0      0 0.0.0.0:2100            0.0.0.0:*               LISTEN     10583/tnslsnr

unix  2      [ ACC ]     STREAM     LISTENING     88815    10583/tnslsnr       /var/tmp/.oracle/s#10583.1

监听的端口已经发生了改变.

也可以使用SYSTEM用户登录运行如下语句修改http, ftp端口

BEGIN

DBMS_XDB.CFG_UPDATE(UPDATEXML(DBMS_XDB.CFG_GET(),'/xdbconfig/descendant::ftp-port/text()','2121'));

DBMS_XDB.CFG_UPDATE(UPDATEXML(DBMS_XDB.CFG_GET(),'/xdbconfig/descendant::http-port/text()','8085'));

DBMS_XDB.CFG_REFRESH();

END;

但我在运行上面语句的时候提示PLS-00201: identifier 'UPDATEXML' must be declared

原因未知.

如果不需要使用xml db, 也可以删除xdb用户, 使oracle不监听http和ftp端口

drop user xdb cascade;