Change Oracle port from port 8080

Oracle is a powerful and widely-used database management system. By default, Oracle listens for incoming connections on port 8080. However, there may be situations where you need to change the Oracle port from 8080 to a different value. This can be due to conflicts with other applications already using port 8080 or because you need to comply with security regulations requiring a different port.
Here's how you can change the Oracle port from 8080:
  1. Log in to Oracle as an administrator: To change the Oracle port, and you must have administrator privileges. Log in to Oracle as an administrator to make the change.
  2. Stop the Oracle service: Before you can change the Oracle port, you need to stop the Oracle service. To stop the Oracle service, you can use the Oracle Enterprise Manager or the lsnrctl utility.
  3. Edit the listener.ora file: After stopping the Oracle service, you need to edit the listener.ora file. This file is located in the $ORACLE_HOME/network/admin directory and contains the configuration information for the Oracle listener.
  4. Locate the LISTENER section: In the listener.ora file, locate the LISTENER section. This section contains the configuration information for the Oracle listener, including the port number.
  5. Change the port number: To change the Oracle port from 8080 to a different value, you need to change the port number in the listener.ora file. The port number is specified in the PORT parameter in the LISTENER section. Change the value of the PORT parameter to the desired value.
  6. Save and close the listener.ora file: After making the change, save the listener.ora file and close it.
  7. Restart the Oracle service: After making the change and saving the listener.ora file, restart the Oracle service. To restart the Oracle service, you can use the Oracle Enterprise Manager or the lsnrctl utility.
In conclusion, changing the Oracle port from 8080 to a different value is a simple process that can be completed in just a few steps. By editing the listener.ora file and restarting the Oracle service, you can change the port that Oracle listens on, which can be useful for avoiding conflicts with other applications or complying with security regulations.