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
?