Changing default oracle XE http port

Default port after installation in oracle is 8080; You can check and change it it by doing the following on the command prompt:

 
sqlplus system@xe 

Enter password:

Verbunden mit:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>select dbms_xdb.gethttpport as "httpport" from DUAL;  

  httpport
----------
      8080

Change the port:

 
SQL>begin
2 dbms_xdb.sethttpport('8085');
3 end;
4 /

SQL> select dbms_xdb.gethttpport as "httpport" from dual;
  httpport
----------
      8085
 

There you go! cheers!

Advertisements