Showing posts with label Oracle APEX. Show all posts
Showing posts with label Oracle APEX. Show all posts

Friday, October 21, 2011

Resolving Port 8080 issue during Oracle Application Express Install

 

Today I set out to install Oracle Application Express on my Linux desktop that also has an Oracle Database Express 10g running on it. Oracle Database Express installation will install the embedded http listener that comes with XML DB which is used to serve up http requests. This listener will use port 8080 by default. As a result when you try installing Oracle Application Express listener, you may run into the following error if you have not changed the default port (8080):

Error: Address already in use: 8080

SEVERE: doSelect IOException
java.net.BindException: Address already in use: 8080=com.sun.grizzly.http.SelectorThreadHandler@183e7de

In order to update the Oracle Embedded http listener port (8080) do the following:

Connect to the Oracle Database Express as System and run the following:

Check Port Number:

select dbms_xdb.gethttpport from dual;

// this should show 8080

Update Port Number:

begin
  dbms_xdb.sethttpport('80');
end;
/

The change is effective immediately and you don’t need to restart the database or the server. Rerun the Oracle Application Express Installation and voila:

image

until next time…