Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Two listeners running: Port 8080 and Port 1521

 
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 201
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Just use the same technique to set the HTTP port to 0.
 
Shannon Sims
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
36
Scala Python Oracle Postgres Database Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 201
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Got it...thanks Chris!
 
Water proof donuts! Eat them while reading this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic