Where to change the oracle port number

Oracle port number modification

Question: Where to modify the Oracle port number?

Answer: The Oracle port number can be modified by modifying the listener configuration file or initialization parameter file.

Detailed steps:

1. Modify the listener configuration file (applies to all sessions)

• Open Listener configuration file: listener.ora (usually located in the ORACLE_HOME\network\admin directory).
• Find the PORT parameter containing the port number.
• Modify the PORT parameter value and specify a new port number.
• Save changes and exit file.

2. Modify the initialization parameter file (only applicable to specific instances)

• Open the initialization parameter file: init.ora (usually located in the ORACLE_HOME\database directory).

• Find and modify the following parameters:

  • LISTENER: Specify the name of the listener.
  • PORT: Specify the port number.
• Save changes and exit the file.

Note: After modifying the port number, you need to restart the Oracle service for the change to take effect.

Restart the Oracle service:

• In Windows: Run net start oracle-service-name## in the command prompt #.
In Linux/UNIX: Run
• sudo systemctl restart oracle-service-name in the terminal.

Other tips:

Make sure that the new port number is not occupied by other services.
• If you encounter connection problems after modifying the port number, try refreshing the TNSNAMES.ORA file or clearing the Oracle network cache.

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