H.Tonguç YILMAZ Blog

One of my colegues asked this, if you run this with sys at XE;

begin
DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
COMMIT ;
end;

it is done to check the ip and port status netstat from command prompt can be used, initially;

D:\>netstat -an

Active Connections

Proto  Local Address          Foreign Address        State
..
TCP    127.0.0.1:8080         0.0.0.0:0              LISTENING
..

Then

..
TCP    0.0.0.0:8080           0.0.0.0:0              LISTENING
..

Or instead of SQL you can use XE administration frontend as mentioned in the below documentation to change this http setting.

References
Oracle® Database Express Edition Installation Guide
http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm
OTN Discussion Forums » Oracle Database XE » Oracle Database 10g Express Edition
http://forums.oracle.com/forums/forum.jspa?forumID=251&start=0
OTN Discussion Forums » Database » Application Express
http://forums.oracle.com/forums/forum.jspa?forumID=137