Change Oracle 9i tns listener used port 8080 to another port

[Ramesh Etta]

On an server where I run Oracle 9i, I also need to run other server applications.
Those are using port 8080 and a couple of other, that I saw are already used by the unavoidable tns listener of Oracle on that machine.
What is the easiest way to have the listener using another port than 8080, but also other ports like 9090 ?

[Paul Campbell]

As you noted, the Oracle XMLDB listens on the ports (8080 for HTTP and 2100 for FTP) by default.

-- change HTTP port from 8080 to 8083
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));

-- change FTP port from 2100 to 2111
call dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));

-- refresh settings
exec dbms_xdb.cfg_refresh;

You need to have the DBA privilege to execute these commands.