Find Oracle Database Port Number: Quick Guide

1 year ago
Olivia Parker
1 minute

To view the port number of Oracle database, you can use one of the following methods:

  1. Look up the listener configuration file: By opening the listener configuration file listener.ora on the Oracle database server, you can find the port number of the listener.
  2. Check the status of the listener: Using the lsnrctl tool, you can check the listener’s status and port number. Input the following command in the command line:
lsnrctl status
  1. Check the port number of the Oracle database instance: Connect to the database instance and use the following SQL statement to query the port number of the database instance:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

This method can assist you in viewing the port number of an Oracle database.

bannerAds