修改oracle監聽佔用的8080埠(轉)

修改oracle監聽佔用的8080埠(轉)[@more@]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
--------------------------------------------------------------------------------

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]$