Mar 28, 2011

Change Oracle 9i TNS Listener port from 8080

The Oracle XMLDB port listens on the port 8080.



To change this port to e.g. 8083 you need to login as SYSDBA and execute the following scripts:
( the first call changes the port number, the second refreshes the settings )

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

exec dbms_xdb.cfg_refresh;

Done!
Real Time Web Analytics