Home > Database, Oracle > Stop Oracle XE from listening on port 8080

Stop Oracle XE from listening on port 8080

A default installation of Oracle Express Edition 11g has a web interface on port 8080 and listens for database connections on port 1521. When the database is used in a development environment this is often less than ideal, as port 8080 tends to clash with other web servers. To disable APEX and get rid of the web interface, set the port number to 0. Connect as a DBA user and run:

BEGIN
  -- Disable the web interface
  DBMS_XDB.SETHTTPPORT(0);
  -- Disable FTP just in case
  DBMS_XDB.SETFTPPORT(0);
END;

There are similarly named functions for getting the current ports as well.

Advertisements
Categories: Database, Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: