• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Two listeners running: Port 8080 and Port 1521

 
Shannon Sims
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good day all and thanks for viewing my post.
I installed Oracle 11gXE 32 bit installation on a Windows 7 x64 platform. I have had no problems connecting to the database using Sql Developer; everything seems to be running fine. However, when the listeners are started, in the Resource Monitor I see the following: IPv4 shows two instances running on Port 8080 and Port 1521. IPv6 shows two instances running on Port 8080 and Port 1521.

I modified the tnsnames.ora and the listener.ora files as follows:

**** tnsnames.ora ****
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Experian-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

and

**** listener.ora ****
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Experian-PC)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

How can I get Oracle to use only port 1521? Is there something else I need to do? I need port 8080 for JBoss Application Server.

Thank you for your help!
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By default, Oracle XE installs with the usual port 1521 for the listener, but also uses port 8080 for the built-in web server in the database, which is used by tools like XMLDB or APEX. You can change the HTTP port easily via a packaged procedure:

http://www.sachinmore.com/2006/11/change-default-port-8080-in-oracle-xe.html
 
Shannon Sims
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Chris, thanks for your reply.

I did as instructed per the link you provided, however, it just created another listener on port 22 (I meant it to be 1522). Please see the attached image (cmd window and resource monitor window) which you can see that I now have three listeners. How can I get rid of port 8080 and modified 22 as 1522?

Thanks for your feedback.
Listeners.PNG
[Thumbnail for Listeners.PNG]
Resource Monitor and cmd view
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just use the same technique to set the HTTP port to 0.
 
Shannon Sims
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Chris, I'll give it a try. But I'm confused how will I keep the port 1521 and get rid of port 8080? How do I identify getting rid of the listener running on port 8080? The command only show how to set a port, not modify. Sorry, am I missing something?
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The package only changes the HTTP port in the database. It doesn't affect the TNS listener. Just set the HTTP port to 0, which turns off the HTTP listener, or set it to e.g. 8081 so it doesn't conflict with your Java server. You should still be able to connect to the DB via the usual Oracle port 1521.
 
Shannon Sims
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Got it...thanks Chris!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic