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:

Purpose

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

Scope

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)

and

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...

e.g.
before:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=2100))(Presentation=FTP (Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=8080)(Presentation=HTTP)(Session=RAW))

after:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=2105))(Presentation=FTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=8081))(Presentation=HTTP)(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.

Details

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