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 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 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
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

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

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
Purpose
Scope
 For Versions 9.2 and 10.1
Details
 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.