My Oracle Support Banner

Utility Package To Change The HTTP And FTP Ports Used By XML DB (Doc ID 209564.1)

Last updated on MAY 19, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.


To provide the ability to alter the ports which an XML DB uses for HTTP and FTP.


For Versions 9.2 and 10.1

By default the XML Database (XDB) comes preconfigured with the http port set to 8080 and the ftp port set to 2100.

If this conflicts with other applications on your server, or you want to run 2 database instances then you need to be able to alter the ports which xdb uses.

The recommended way of doing this is via the XML Database Parameters window of  the Oracle Enterprise Manager (OEM) console, however if you have not installed this, or do not have access to it, this package provides the ability to change the ports via SQL.

This script must be run as sys.

Once it is installed you can change the port using the commands:

call xdb_utility.set_http_port(n)


call xdb_utility.set_ftp_port(m)

To verify that this has worked, drop to the operating system prompt and issue

lsnrctl status

And look for the entries under
Listening Endpoints Sumary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=2100))(Presentation=FTP (Session=RAW))


Note that it not necessary to restart either the database or the listener for these values to change.

Note You can also set these ports to 0 if you want to disable these end-points.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 For Versions 9.2 and 10.1
 For 10.2 onwards:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.