Change Oracle 9i tns listener used port 8080 to another port

Edit the file listener.ora located in <ORACLE_HOME>/network/admin :

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = <server_name>)(PORT = 9090))
      )
    )
  )

You must also update TNSNAMES.ORA on all clients.

And don't forget to bounce the service for changes to take effect...

Here's a detailed note from Metalink dealing with creation of multiple listeners : http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=232010.1

This could help you to make a progressive migration of your clients.

Not that I think.
The current listener.ora contains the right default port 1521.
But looking with tcpview tool, I see that it is also listening on other ports like 2481, 2482, 4351, 4419 and the one I need for something else : 8080 and 9090 !
So ?

So you mean change range of ports allowed for established connections ?
Follow this link http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:21685475744243

LeTay,

TCPview tool will display all the ports that are listened on this Server that could be by many applications.

are you sure 8080 and 9090 are listened by Oracle TNS listener? they usually don't go that higher in ports.


can you elaborate what exactly you want to do...?

based on the above posts, I am not the ONLY on got confused...

Oracle 9 comes with XDB configured by default on port 8080, you will need to remove the service from the dispatchers initialisation parameter in your init.ora and bounce the instance.

Are you running 9iAS /apache - it has a hanit of reserving ports - check your *.conf files

HTH
Bob

LeTay,
In Windows the listener listens on one port (1521 by default) but redirects every session to other ports. This is the reason for so many ports Oracle listens.
Sometimes one needs to reduce the listening ports (firewall, etc.)
In this special case you have to use the Windows option "USE_SHARED_SOCKET".

The net8 connection to a Windows NT/2000 database server normally redirects the port number to a random number when a user process connects to a ORACLE shadow process. It does not use the TCP/IP port sharing like on UNIX systems where the clients only need to know the TNS listener port.
In order to make Oracle connection to work in a firewall environment, the customers had to get a firewall that has a SQL*Net proxy built in or  with the newest TCP/IP Socket implementation of Windows NT 4.0 (available with  Service Pack#3) and Windows 2000 this can now be handled by the use of the  parameter "USE_SHARED_SOCKET".

Ports 8080 and 9090 are clearly being listened (not established) by the tnslsnr.exe.
tcpview show the process name and the original executable without any doubt.
I find that strange anyway if, as BobMc says, this should be listened by XDB
I will have a look at that XDB...

Oracle can use more then one listener on the box. Check how many listeners do you have.

Only one listener, as far as I could see

Please post TCPView output. Here's a part of mine :

TNSLSNR.EXE:1012      TCP      <server_name>:1521                  <server_name>:0                  LISTENING      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:3697                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1532                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1542                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1450                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <server_name>.<domain_name>:1289      ESTABLISHED      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <server_name>.<domain_name>:1401      ESTABLISHED      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <server_name>.<domain_name>:1523      ESTABLISHED      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <server_name>.<domain_name>:1742      ESTABLISHED      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <server_name>.<domain_name>:2335      ESTABLISHED      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1629                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1631                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1645                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1650                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1373                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1375                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1664                  TIME_WAIT      
TNSLSNR.EXE:1012      TCP      <server_name>.<domain_name>:1521      <client>:1685                  TIME_WAIT      

Bobmc is right , XDB by default is using 8080.

And you can do this to confirm:

in dos window:


C:\>lsnrctl status


for example in mine it will show this:


Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbspare.rockefeller.edu)(PORT=1529)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbspare.rockefeller.edu)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbspare.rockefeller.edu)(PORT=2100))(Presentation=FTP)(Session=RAW))

Here is the relevant part of tcpview on that server (named radon)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
oracle.exe:1316      TCP      radon:1053      radon:0      LISTENING      
oracle.exe:1316      TCP      radon:1058      radon:0      LISTENING      
oracle.exe:1316      TCP      radon:1060      radon:0      LISTENING      
oracle.exe:1316      TCP      radon:1061      radon:0      LISTENING      
oracle.exe:1316      TCP      radon.zav.st.com:1053      radon.zav.st.com:1521      ESTABLISHED      
oracle.exe:1316      TCP      radon.zav.st.com:1169      radon:0      LISTENING      
oracle.exe:1316      TCP      radon.zav.st.com:1169      zavnt202.zav.st.com:3510      ESTABLISHED      
oracle.exe:1316      TCP      radon.zav.st.com:1189      radon:0      LISTENING      
oracle.exe:1316      TCP      radon.zav.st.com:1189      zavnt202.zav.st.com:3780      ESTABLISHED      
oracle.exe:1376      TCP      radon:1052      radon:0      LISTENING      
oracle.exe:1376      TCP      radon:1054      radon:0      LISTENING      
oracle.exe:1376      TCP      radon:1057      radon:0      LISTENING      
oracle.exe:1376      TCP      radon:1059      radon:0      LISTENING      
oracle.exe:1376      TCP      radon.zav.st.com:1052      radon.zav.st.com:1521      ESTABLISHED      
oracle.exe:1376      TCP      radon.zav.st.com:1072      radon:0      LISTENING      
oracle.exe:1376      TCP      radon.zav.st.com:1072      zavnt201.zav.st.com:2636      ESTABLISHED      
oracle.exe:1376      TCP      radon.zav.st.com:1145      radon:0      LISTENING      
oracle.exe:1376      TCP      radon.zav.st.com:1145      zavnt201.zav.st.com:2762      ESTABLISHED      
TNSLSNR.EXE:1288      TCP      radon:1521      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:2481      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:2481      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:2482      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:2482      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:8080      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:8080      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:9090      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon:9090      radon:0      LISTENING      
TNSLSNR.EXE:1288      TCP      radon.zav.st.com:1521      radon.zav.st.com:1052      ESTABLISHED      
TNSLSNR.EXE:1288      TCP      radon.zav.st.com:1521      radon.zav.st.com:1053      ESTABLISHED
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
And here lsnrctl status
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=radon)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=164.129.144.27)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=164.129.144.27)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=164.129.144.27)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=164.129.144.27)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=164.129.144.27)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=164.129.144.27)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=164.129.144.27)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=164.129.144.27)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
We can indeed see that the listener is ... listening on 8080, 9090 etc, but the listener.ora configuration file does not contains any settings of that kind.
I supposed that these are pure default value.
Now where and how to change them, no idea. That's really my original question.