Monday, August 02, 2010

how to change oracle xe default http port number?

login to sqlpus with system account.
sqlplus system@xe

see the present value

select dbms_xdb.gethttpport as "HTTP-Port", bms_xdb.getftpport as "FTP-Port" from dual;

--it shows actual value. now u want to change them, use the following?

begin

dbms_xdb.sethttpport('9999');
dbms_xdb.setftpport('2100');
end;
/