This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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:
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:
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?
Just use the same technique to set the HTTP port to 0.
Joined: Jul 03, 2003
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?
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.