F Managing Oracle Database Port Numbers

This appendix lists the default port numbers and describes how to change the assigned port after installation.

This appendix contains the following topics:

About Managing Ports
Viewing Port Numbers and Access URLS
Port Numbers and Protocols of Oracle Components
Changing the Oracle Enterprise Management Agent Port
Changing the Oracle Enterprise Manager Database Console Ports
Changing the Oracle XML DB Ports

F.1 About Managing Ports

During installation, Oracle Universal Installer (OUI) assigns port numbers to components from a set of default port numbers. Many Oracle Real Application Clusters components and services use ports. As an administrator, it is important to know the port numbers used by these services, and to make sure that the same port number is not used by two services on your host.

Most port numbers are assigned during installation or at execution time. Every component and service has an allotted port range, which is the set of port numbers Oracle Real Application Clusters attempts to use when assigning a port. Oracle Real Application Clusters starts with the lowest number in the range and performs the following checks:

Is the port used by another Oracle Database installation on the host?

The installation may be up or down at the time; Oracle Database can still detect if the port is used.
Is the port used by a process that is currently running?

This could be any process on the host, including processes other than Oracle Database processes.

If the answer to any of the preceding questions is yes, then Oracle Real Application Clusters moves to the next highest port in the allotted port range and continues checking until it finds a free port.

F.2 Viewing Port Numbers and Access URLS

In most cases, the Oracle Database component's port number is listed in the tool used to configure the port. In addition, ports for some Oracle Database applications are listed in the portlist.ini file. This file is located in the directory Oracle_home\install.

If you change a port number, then it is not updated in the portlist.ini file, so you can only rely on this file immediately after installation. To find or change a port number, use the methods described in this appendix.

F.3 Port Numbers and Protocols of Oracle Components

The following table lists the port numbers and protocols used by components that are configured during the installation. By default, the first port in the range is assigned to the component, if it is available.

Table F-1 Ports Used in Oracle Components

Component and Description	Default Port Number	Port Range	Protocol
Oracle SQLNet Listener Allows Oracle client connections to the database over Oracle's SQLNet protocol. You can configure it during installation. To reconfigure this port, use Net Configuration Assistant.	1521	1024-65535	TCP
Oracle Data Guard Shares the SQLNet port and is configured during installation. To reconfigure this port, use Net Configuration Assistant to reconfigure the Oracle SQLNet listener.	1521 (same value as the listener)	1521	TCP
Oracle Connection Manager Listening port for Oracle client connections to Oracle Connection Manager. You can configure Oracle Connection Manager after installation using Net Configuration Assistant.	1630	1630	TCP
Oracle Enterprise Manager Database Control Agent HTTP port for Oracle Management Agent, which is part of Oracle Enterprise Manager. It is configured during installation. "Changing the Oracle Enterprise Management Agent Port" explains how to modify its port number	3938	1830–1849	HTTP
Oracle Enterprise Manager Database Console HTTP port for Oracle Enterprise Manager Database Control. It is configured during installation. "Changing the Oracle Enterprise Manager Database Console Ports" explains how to modify its port number.	1158	5500–5519	TCP/HTTP
Oracle Enterprise Manager Database Console RMI port for Oracle Enterprise Manager Database Control. It is configured during installation."Changing the Oracle Enterprise Manager Database Console Ports" explains how to modify its port number.	5520	5520–5539	TCP
Oracle Enterprise Manager Database Console JMS port for Oracle Enterprise Manager Database Control. It is configured during installation. "Changing the Oracle Enterprise Manager Database Console Ports" explains how to modify its port number.	5540	5540–5559	TCP
Oracle XML DB The Oracle XML DB HTTP port is used if Web-based applications need to access an Oracle database from an HTTP listener. It is configured during installation, but you cannot view it afterward. "Changing the Oracle XML DB Ports" explains how to change its port number.	0	Dynamic	HTTP
Oracle XML DB The Oracle XML DB FTP is used when applications need to access an Oracle database from an FTP listener. It is configured during installation, but you cannot view it afterward. "Changing the Oracle XML DB Ports"explains how to change its port number.	0	Dynamic	FTP
Oracle Real Application Clusters The port number is assigned automatically during installation. You cannot view or modify it afterward.	Dynamic	Dynamic	UDP
Oracle Clusterware CRS daemon (Oracle Cluster Ready Services Daemon) internode connection. The port number is assigned automatically during installation. You cannot view or modify it afterward.	Dynamic	Dynamic	TCP
Cluster Synchronization Service (CSS) CSS daemon internode connection for the GM layer. The port number is assigned automatically during installation. You cannot view or modify it afterward.	Dynamic	Dynamic	TCP
Oracle Cluster Registry The port number is assigned automatically during installation. You cannot view or modify it afterward.	Dynamic	Dynamic	TCP
Oracle Event Manager The port number is assigned automatically during installation. You cannot view or modify it afterward.	49897	49897–49898	TCP
Cluster Manager The port number is assigned automatically during installation. You cannot view or modify it afterward.	Dynamic	Dynamic	TCP
Oracle Services for Microsoft Transaction Server The port number for Microsoft Transaction Server is configured when you enter its value in Oracle Universal Installer the first time you install it on a particular computer. If you install it in multiple Oracle homes on the same computer, then Oracle Universal Installer uses the same port number that you specified during the first installation. In most cases, you do not need to reconfigure the port number. If you need to, you can edit its value in the `HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ OracleMTSRecoveryService\Protid_0` Registry Editor key.	2030	2030	TCP

F.4 Changing the Oracle Enterprise Management Agent Port

To find the current setting for the Oracle Management agent port, search for EMD_URL in the Oracle_home\host_sid\sysman\config\emd.properties file.

To change the Oracle Management Agent HTTP port, use the emca -reconfig ports command:

emca -reconfig ports -AGENT_PORT 1831

F.5 Changing the Oracle Enterprise Manager Database Console Ports

To find the current HTTP, RMI, and JMS port settings, search in the following files:

HTTP port: Search for REPOSITORY_URL in the ORACLE_HOME\host_sid\sysman\config\emd.properties file.
RMI port: Search for the port attribute in the rmi-server tag in the ORACLE_HOME\oc4j\j2ee\OC4J_DBConsole_host_sid\config\rmi.xml file.
JMS port: Search for the port attribute in the jms-server tag in the ORACLE_HOME\oc4j\j2ee\OC4J_DBConsole_host_sid\config\ jms.xmlfile.

To change the Oracle Enterprise Manager Database Console ports, use the emca -reconfig ports command:

emca -reconfig ports option setting

where option can be:

DBCONTROL_HTTP_PORT: Sets the HTTP port, for example:
```
emca -reconfig ports -DBCONTROL_HTTP_PORT 1820
```
RMI_PORT: Sets the RMI port, for example:
```
emca -reconfig ports -RMI_PORT 5520
```
JMS_PORT: Sets the JMS port, for example:
```
emca -reconfig ports -JMS_PORT 5521
```

You can enter multiple -reconfig port settings in one line, for example:

emca -reconfig ports -DBCONTROL_HTTP_PORT 1820 -AGENT_PORT 1821 -RMI_PORT 5520

F.6 Changing the Oracle XML DB Ports

By default, the FTP and HTTP (including HTTPS) ports for Oracle XML DB are set to 0, which disables FTP or HTTP access to the Oracle XML DB. To change the Oracle XML FTP and HTTP ports, you need to run the catxdbdbca.sql script, which in a default installation is located in Oracle_home\rdbms\admin.

To change the Oracle XML DB ports:

Check that the Oracle listener is running. In the Windows Services Control Manager, make sure that the Oracle TNS Listener service (for example, OracleOraDb11g_home1TNSListener) is set to Started.

If you cannot start the listener, then refer to Oracle Database Net Services Administrator's Guide.
Log in to SQL*Plus as the SYS or XDB user using the SYSDBA role.

For example, to log in to SQL*Plus as SYS:
```
SQL> sqlplus sys/ as sysdba
```
Run the catxdbdbca.sql script.

For example, to use 2200 for the FTP port and 8200 for the HTTP port, and assuming your Oracle home is in the following location, enter the following command:
```
SQL> C:\app\oracle\product\11.2.0\db_1\rdbms\admin/
catxdbdbca.sql 2200 8200
```
Exit SQL*Plus.