Friday, July 21, 2006

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;

No comments: