oracle database port

The default port of Oracle database is 1521 (TCP/IP) for ONS and listening services, and 1522 (TCP/IP) for TNS listeners. To change the port, modify the registry (Windows) or listener.ora file (Linux/Unix). Open the listener port in the firewall to allow the database to receive incoming connections. Check the firewall, database service status, client application port settings or try restarting the service/application to resolve the connection issue.

Oracle Database Port

What is the port?

A port is a number in a computer network that identifies the communication endpoint used by an application. Each application uses a specific port to send and receive data.

Oracle Database Port

Oracle database uses the following ports by default:

• 1521 (TCP/IP) : for Oracle Network Services (ONS) and Oracle Listening Services
• 1522 (TCP/IP) : only for TNS listeners

How to change Oracle ports

You can change the Oracle port by modifying the following registry key:

• Windows: HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDb11g_home1\Network\ADMIN\listener.ora
• Linux/Unix: /etc/oracle/listener.ora

Open the listener port

It is necessary to open the listener port in the firewall so that the database can receive incoming connections. The following rules will allow TCP port 1521:

• Windows: netsh advfirewall firewall add rule name="Oracle Listener" dir=in action=allow protocol=tcp localport=1521
• Linux/Unix: iptables -A INPUT -p tcp --dport 1521 -j ACCEPT

troubleshooting

If you encounter problems connecting to Oracle databases, please check the following:

• Make sure the firewall has allowed the use of the listener port.
• Make sure the database service is running.
• Make sure the client application is using the correct port.
• Try restarting the database service or client application.

The above is the detailed content of oracle database port. For more information, please follow other related articles on the PHP Chinese website!