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 10.2.0.1.0 – Production on Mon Aug 11 10:50:15 2008

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

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

PL/SQL procedure successfully completed.

SQL>

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

Advertisement