Oracle XE change HTTP and FTP Port

Login on SQL*Plus with the system user:

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 11:40:05 2009

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

SQL> conn system/[PASSWORD]
Connected.
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
            , dbms_xdb.getftpport as "FTP-Port" from dual;

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

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

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
---------- ----------
     8585          0

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Install Oracle XE on Linux and configure database XE

Download the rpm from the Oracle Website:
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

Execute the RPM

rpm -ihv oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Configure the database

su - root
cd /etc/init.d
./oracle-xe configure

Refer:
http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.