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