Showing posts with label oraclexe. Show all posts
Showing posts with label oraclexe. Show all posts

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;
/