Changing XML DB Default Ports (8080,2100)

When we installed oracle XMLDB. By default ports for HTTP(8080) and FTP(2100)

So sometime we want to change default port to another port

SQL> -- Change the HTTP/WEBDAV port from 8080 to 8089

SQL> call dbms_xdb.cfg_update(updateXML(
2 dbms_xdb.cfg_get()
3 , '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()'
4 , 8089))
5 /

Call completed.


SQL> -- Change the FTP port from 2100 to 2111

SQL> call dbms_xdb.cfg_update(updateXML(
2 dbms_xdb.cfg_get()
3 , '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()'
4 , 2111))
5 /

Call completed.


SQL> COMMIT;

Commit complete.


SQL> EXEC dbms_xdb.cfg_refresh;

PL/SQL procedure successfully completed.


SQL> -- Verify the change

SQL> set long 100000
SQL> set pagesize 9000
SQL> SELECT dbms_xdb.cfg_get FROM dual;

Change HTMLDB port default

port defaults are 8080 for HTTP and 2100 for FTP. problem, it same with some application.

So
if the package dbms_xdb is granted to PUBLIC you need DBA privileges to change the ports.

-- change HTTP port from 8080 to 8083 call

SQL> dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));

-- change FTP port From 2100 to 2111 call

SQL> dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));

-- refresh settings

SQL> exec dbms_xdb.cfg_refresh;

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