ISSUE :
 
Profile photo
Submitted by Mark Mazerski
on February 2nd, 2012 at 15:00:34 EST

How do I change the default port of Oracle database 10g XE edtion

Hi,
I have different databases and Web servers running in my local machine.
I often get port conflicts because of Oracle XE will claim the default port 8080.
I search in net how do avoid port conflicts by changing the default port of Oracle 10g database XE edition but no luck.Any helping hands is appreciated.
Thanks,
MM


Profile photo
Replied by Yogaraj Khanal
on February 2nd, 2012 at 20:36:10 EST

SQL>begin
2 dbms_xdb.sethttpport('8888');
3 end;
4 /
Accepted Answer
Accepted
 Answer

Profile photo
Replied by Yogaraj Khanal
on February 2nd, 2012 at 20:39:46 EST
The above PL/SQL procedure will set your Oracle XE port to 8888.
If you want to verify http://localhost:8888/ or you can run following SQL:

SQL> select dbms_xdb.gethttpport as "HTTP-Port" from dual;

Profile photo
Replied by Mark Mazerski
on February 2nd, 2012 at 22:13:18 EST
Thanks.Appreciate it!
MM

Profile photo
Replied by MalayRanjan Hota
on February 25th, 2013 at 07:02:04 EST
Thanks Yogaraj. Its really Appreciate

M R Hota