Changing ports of Oracle XE Enterprise Manager

Since Oracle has released the Oracle XE database, I have been using it a lot. It makes life much easier when I want to investigate new features in Oracle software and I need a ‘simple’ database for it. Until now I had to install the complete Oracle Enterprise Database and although this process of installing has become easier and easier over the years, it still takes up a lot of my resources on my laptop when running the database.
So when I needed a database at my current project I again installed the XE database. But this time I ran into a problem: I had a port conflict on my machine. The Oracle XE Enterprise Manager is using port 8080 by default for administration of the database, but I also had another process that was using that port. So I wanted to change the port of the Enterprise Manager but it took me a while before I found out how. There isn’t a Manager that manages the Enterpise Manager….
It appeared that you can to this by performing some updates in the XE database. To do the updates you have to call some default packages. Here is the code:

SQL*Plus: Release – Production on Mon Aug 11 10:50:15 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect system/manager@xe
SQL> begin
2 dbms_xdb.sethttpport(‘8888’);
3 dbms_xdb.setftpport(‘8889’);
4 end;
5 /

PL/SQL procedure successfully completed.


After this statement the Enterprise Manager is using port 8888 instead of the default 8080.

About Pascal Alma

Pascal is a senior software developer and architect. Pascal has been designing and building applications since 2001. He is particularly interested in Open Source toolstack (Mule, Spring Framework, JBoss) and technologies like Web Services, SOA and Cloud technologies. Lately he is having great fun by building iOS apps with Swift. Specialties: JEE AWS XML/XSD/XSLT Web Services/SOA Mule ESB/ WSO2 ESB Maven Cloud Technology Swift/ iOS
This entry was posted in Technical and tagged . Bookmark the permalink.