Oracle® Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide 10g Release 2 (10.2) for Microsoft Windows Part Number B14207-05 |
|
|
View PDF |
This appendix lists the default port numbers and describes how to change the assigned port after installation:
During installation, Oracle Universal Installer assigns port numbers to components from a set of default port numbers. Many Oracle Database 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. Every component and service has an allotted port range, which is the set of port numbers Oracle Database attempts to use when assigning a port. Oracle Database 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, even a non-Oracle Database process.
If the answer to any of the preceding questions is yes, Oracle Database moves to the next highest port in the allotted port range and continues checking until it finds a free port.
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 ORACLE_BASE
\
ORACLE_HOME
\install
.
If you change a port number, 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.
Table G-1 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 G-1 Ports Used in Oracle Components
Component and Description | Default Port Number | Port Range | Protocol |
---|---|---|---|
Allows Oracle client connections to the database over Oracle's SQL*Net protocol. You can configure it during installation. To reconfigure this port, use Net Configuration Assistant. |
1521 |
1521 |
TCP |
Shares the SQL*Net port and is configured during installation. To reconfigure this port, use Net Configuration Assistant to reconfigure the Oracle SQL*Net listener. |
1521 (same value as the listener) |
1521 |
TCP |
Listening port for Oracle client connections to Oracle Connection Manager. It is not configured during installation, but can be configured using Net Configuration Assistant. |
1630 |
1630 |
TCP |
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 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 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 |
Enterprise Manager Database Console JMS port for 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 |
HTTP port for iSQL*Plus. The port number is automatically assigned during installation. "Changing the iSQL*Plus Ports" explains how to change its port number. |
5560 |
5560–5579 |
TCP/HTTP |
iSQL*Plus RMI port for iSQL*Plus. The port number is automatically assigned during installation."Changing the iSQL*Plus Ports" explains how to change its port number. |
5580 |
5580–5599 |
TCP |
iSQL*Plus JMS port for iSQL*Plus. The port number is automatically assigned during installation. "Changing the iSQL*Plus Ports" explains how to change its port number. |
5600 |
5600–5619 |
TCP |
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. |
Dynamic |
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. |
Dynamic |
Dynamic |
FTP |
Oracle Services for Microsoft Transaction Server The port number for Microsoft Transaction Server is configured when you enter its value in Oracle Universal Installer during a Custom installation the first time you install it on a particular computer. If you install it in multiple Oracle homes on the same computer, 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 do need to, you can edit its value in the |
2030 |
2030 |
TCP |
Oracle Real Application Clusters (Local Host: Windows only) The port number is assigned automatically during installation. You cannot view or modify it afterward. |
61000 |
61000–61300 |
TCP |
Oracle Real Application Clusters (Cluster Interconnect: Windows only) The port number is assigned automatically during installation. You cannot view or modify it afterward. |
11000 |
11000–26000 |
TCP |
Oracle Real Application Clusters (UNIX) The port number is assigned automatically during installation. You cannot view or modify it afterward. |
Dynamic |
Dynamic |
UDP |
CRS daemon internode connection. The port number is assigned automatically during installation. You cannot view or modify it afterward. |
49896 |
49896 |
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. |
49895 |
49895 |
TCP |
The port number is assigned automatically during installation. You cannot view or modify it afterward. |
Dynamic |
Dynamic |
TCP |
The port number is assigned automatically during installation. You cannot view or modify it afterward. |
49897 |
49897–49898 |
TCP |
The port number is assigned automatically during installation. You cannot view or modify it afterward. |
Dynamic |
Dynamic |
TCP |
To find the current setting for the Oracle Management agent port, search for EMD_URL
in the ORACLE_BASE
\
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
To find the current HTTP, RMI, and JMS port settings, search in the following files:
HTTP port: Search for REPOSITORY_URL
in the ORACLE_BASE
\
ORACLE_HOME
\
host_sid
\sysman\config\emd.properties
file.
RMI port: Search for the port
attribute in the rmi-server
tag in the ORACLE_BASE
\
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_BASE
\
ORACLE_HOME
\
oc4j\j2ee\OC4J_DBConsole_
host_sid
\config\jms.xml
file.
To change the Oracle Enterprise Manager Database Console ports, use the emca -reconfig
ports command:
ORACLE_BASE\ORACLE_HOME\bin> 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
The following sections describe how to change the iSQL*Plus ports.
Changing the HTTP Port
To change the HTTP port, edit the following files:
ORACLE_BASE\ORACLE_HOME
\host
_
sid
\sysman\config\emoms.properties
Modify the following port
parameters (for example, 5560
) in the file:
oracle.sysman.db.isqlplusUrl=http\://host.domain\:5560/isqlplus/dynamic oracle.sysman.db.isqlplusWebDBAUrl=http\://host.domain\:5560/isqlplus/dynamic
ORACLE_BASE\ORACLE_HOME
\oc4j\j2ee\isqlplus\config\http-web-site.xml
Modify the port
attribute of the web-site
element:
<web-site port="5560" ...>
Changing the RMI Port
To change the RMI port, modify the port
attribute of the rmi-server
element in the ORACLE_BASE\ORACLE_HOME
\oc4j\j2ee\isqlplus\config\rmi.xml
file:
<rmi-server port="5580"...>
Changing the JMS Port
To change the JMS port, modify the port
attribute of the jms-server
element in the ORACLE_BASE\ORACLE_HOME
\oc4j\j2ee\isqlplus\config\jms.xml
file:
<jms-server port="5600"...>
To change the Oracle XML DB FTP and HTTP ports, you need to run the catxdbdbca.sql
script, which in a default installation is located in ORACLE_BASE
\
ORACLE_HOME
\rdbms\admin
.
To change the Oracle XML DB ports:
Check that the Oracle listener is running. To do so, in the Windows Services utility, make sure that the Oracle TNS Listener service (for example, OracleOraDb10g_home1TNSListener
) is set to Started.
If you cannot start the listener, refer to Oracle Database Net Services Administrator's Guide.
Log in to SQL*Plus or iSQL*Plus as SYS
or XDB
using the SYSDBA
role.
For example, to log in to SQL*Plus as SYS
using the password welcome
:
C:\> sqlplus sys/welcome 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:\oracle\product\10.20.0\db_1\rdbms\admin\catxdbdbca.sql 2200 8200
Exit SQL*Plus or iSQL*Plus.