Wednesday, January 25, 2006

XE: Changing the default http port

Oracle XE uses the embedded http listener that comes with the XML DB (XDB) to serve http requests. The default port for HTTP access is 8080.

It also supports the WebDAV protocol just as well as FTP.

You can determine the current configuration using the following commands when you connect to XE as the oracle user SYSTEM (or any other DBA):

C:\WINDOWS\system32>sqlplus system@xe

SQL*Plus: Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL> -- get current status
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8080 0

You can change the http port and the ftp port to whatever you like (keep in mind that you need special privileges for ports < 1024 on Unix/Linux systems).

SQL> -- set http port and ftp port
SQL> begin
2 dbms_xdb.sethttpport('80');
3 dbms_xdb.setftpport('2100');
4 end;
5 /

PL/SQL procedure successfully completed.

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

HTTP-Port FTP-Port
---------- ----------
80 2100

If you only want to use the database without allowing access via http or ftp then you can disable both:

SQL> -- disable http and ftp access
SQL> begin
2 dbms_xdb.sethttpport('0');
3 dbms_xdb.setftpport('0');
4 end;
5 /

PL/SQL procedure successfully completed.

SQL> -- get current status
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
0 0

~Dietmar

XE: Where in the World is Oracle XE Being Used?

Mark Townsend from Oracle XE Marketing invites us to join the Oracle XE group on http://www.frappr.com:
Oracle Database 10g Express Edition (Oracle XE) is being used all over the world. If you are using Oracle XE why not add yourself to the map - see the OracleXE group on frapper - http://www.frappr.com/oraclexe.
You can also find other people in your area using Oracle XE as well.


Simply add yourself to the map (no registration required) and join the community!



You can also check out the Frappr group for HTML DB users ( http://www.frappr.com/htmldbusers ) and see who is using it in the world.

~Dietmar.

Tuesday, January 10, 2006

I have started this BLOG to spread the word on the really cool web development framework HTML DB and the free Oracle database Oracle Express Edition (XE) .

Enjoy the ride!

~Dietmar.