The following section describes the syntax that can be used to alter XML DB configuration information from within SQL*Plus. Ensure that you are logged into the database from a DBA account. In the following example, the default HTTP/WebDAV and FTP ports are changed from 8080 and 2100 to 8081 and 2111 respectively:
SQL -- Change the HTTP/WEBDAV port from 8080 to 8081
SQL call dbms_xdb.cfg_update(updateXML(
2
dbms_xdb.cfg_get()
3
, '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()'
4
, 8081))
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;
CFG_GET
--------------------------------------------------------------------------------
<xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
ww.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/x
db/xdbconfig.xsd
http://xmlns.oracle.com/xdb
/xdbconfig.xsd"
<sysconfig
<acl-max-age900</acl-max-age
<acl-cache-size32</acl-cache-size
<invalid-pathname-chars,</invalid-pathname-chars
<call-timeout300</call-timeout
<max-session-use100</max-session-use
<default-lock-timeout3600</default-lock-timeout
<resource-view-cache-size1048576</resource-view-cache-size
<protocolconfig
<common
<extension-mappings
<mime-mappings
<mime-mapping
<extensionau</extension
<mime-typeaudio/basic</mime-type
</mime-mapping
<mime-mapping
<extensionavi</extension
<mime-typevideo/x-msvideo</mime-type
</mime-mapping
<mime-mapping
<extensionbin</extension
<mime-typeapplication/octet-stream</mime-type
</mime-mapping
<mime-mapping
<extensionbmp</extension
<mime-typeimage/bmp</mime-type
</mime-mapping
<mime-mapping
<extensiondoc</extension
<mime-typeapplication/msword</mime-type
</mime-mapping
<mime-mapping
<extensioneml</extension
<mime-typemessage/rfc822</mime-type
</mime-mapping
<mime-mapping
<extensiongif</extension
<mime-typeimage/gif</mime-type
</mime-mapping
<mime-mapping
<extensionhtm</extension
<mime-typetext/html</mime-type
</mime-mapping
<mime-mapping
<extensionhtml</extension
<mime-typetext/html</mime-type
</mime-mapping
<mime-mapping
<extensionjpe</extension
<mime-typeimage/jpeg</mime-type
</mime-mapping
<mime-mapping
<extensionjpeg</extension
<mime-typeimage/jpeg</mime-type
</mime-mapping
<mime-mapping
<extensionjpg</extension
<mime-typeimage/jpeg</mime-type
</mime-mapping
<mime-mapping
<extensionjsp</extension
<mime-typetext/html</mime-type
</mime-mapping
<mime-mapping
<extensionmid</extension
<mime-typeaudio/mid</mime-type
</mime-mapping
<mime-mapping
<extensionmov</extension
<mime-typevideo/quicktime</mime-type
</mime-mapping
<mime-mapping
<extensionmovie</extension
<mime-typevideo/x-sgi-movie</mime-type
</mime-mapping
<mime-mapping
<extensionmp3</extension
<mime-typeaudio/mpeg</mime-type
</mime-mapping
<mime-mapping
<extensionmpe</extension
<mime-typevideo/mpg</mime-type
</mime-mapping
<mime-mapping
<extensionmpeg</extension
<mime-typevideo/mpg</mime-type
</mime-mapping
<mime-mapping
<extensionmpg</extension
<mime-typevideo/mpg</mime-type
</mime-mapping
<mime-mapping
<extensionmsa</extension
<mime-typeapplication/x-msaccess</mime-type
</mime-mapping
<mime-mapping
<extensionmsw</extension
<mime-typeapplication/x-msworks-wp</mime-type
</mime-mapping
<mime-mapping
<extensionpcx</extension
<mime-typeapplication/x-pc-paintbrush</mime-type
</mime-mapping
<mime-mapping
<extensionpdf</extension
<mime-typeapplication/pdf</mime-type
</mime-mapping
<mime-mapping
<extensionppt</extension
<mime-typeapplication/vnd.ms-powerpoint</mime-type
</mime-mapping
<mime-mapping
<extensionps</extension
<mime-typeapplication/postscript</mime-type
</mime-mapping
<mime-mapping
<extensionqt</extension
<mime-typevideo/quicktime</mime-type
</mime-mapping
<mime-mapping
<extensionra</extension
<mime-typeaudio/x-realaudio</mime-type
</mime-mapping
<mime-mapping
<extensionram</extension
<mime-typeaudio/x-realaudio</mime-type
</mime-mapping
<mime-mapping
<extensionrm</extension
<mime-typeaudio/x-realaudio</mime-type
</mime-mapping
<mime-mapping
<extensionrtf</extension
<mime-typeapplication/rtf</mime-type
</mime-mapping
<mime-mapping
<extensionrv</extension
<mime-typevideo/x-realvideo</mime-type
</mime-mapping
<mime-mapping
<extensionsgml</extension
<mime-typetext/sgml</mime-type
</mime-mapping
<mime-mapping
<extensiontif</extension
<mime-typeimage/tiff</mime-type
</mime-mapping
<mime-mapping
<extensiontiff</extension
<mime-typeimage/tiff</mime-type
</mime-mapping
<mime-mapping
<extensiontxt</extension
<mime-typetext/plain</mime-type
</mime-mapping
<mime-mapping
<extensionurl</extension
<mime-typetext/plain</mime-type
</mime-mapping
<mime-mapping
<extensionvrml</extension
<mime-typex-world/x-vrml</mime-type
</mime-mapping
<mime-mapping
<extensionwav</extension
<mime-typeaudio/wav</mime-type
</mime-mapping
<mime-mapping
<extensionwpd</extension
<mime-typeapplication/wordperfect5.1</mime-type
</mime-mapping
<mime-mapping
<extensionxls</extension
<mime-typeapplication/vnd.ms-excel</mime-type
</mime-mapping
<mime-mapp