CODEWITHSUNDEEP
javalinuxoracle11g
Gokul Kulkarni
Gokul Kulkarni

Reputation: 2259

how to find oracle listener port in linux

I have Oracle 11.2.0 installed in my Linux system, on which we are running one tool(developed in java), which needs as an input the port number where the oracle listener is running.

Is there any way to get the port number.

Upvotes: 3

Views: 26375

Answers (3)

Starksky
Starksky

Reputation: 41

You can see in listener.ora located at $ORACLE_HOME/network/admin folder. or You can see lists of ports configured in portlist.ini located at $ORACLE_HOME/install folder

Upvotes: 2

user2587106
user2587106

Reputation: 325

You can typically see the port number you need in listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = DS-1)(PORT = 1521))
    )
  )

To find you listener.ora, you can use eg

find . -type f -name listener.ora

Upvotes: 9

Marco Baldelli
Marco Baldelli

Reputation: 3728

From the command prompt you can use lsnrctl status, here is the relevant documentation.

You can also use the Oracle Enterprise Manager web interface under General -> Listener.

Upvotes: 2

Related Questions