My Dogs Ringworm Is Not Healing

Change http port of Oracle XE EM - (XE: Changing the default http port)

Determine the current configuration settings on your Oracle XE. Accessed through SQLPLUS with SYSTEM user (or anyone else with DBA privileges):

 
 C: \\ WINDOWS \\ system32> sqlplus system @ xe SQL * Plus 
 
: Release 10.1.0.2.0 - Production on Mi Jan 25 November : 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 port of FTP when you want only have a few precautions such as

• Note that you need special privileges for <1024>
• ports should check the ports used ( netstat -ano )
  
• httpport the parameter defines the port that will run the MS.
  

 
 SQL> - set port http and ftp port 
 SQL> begin 2 
  dbms_xdb.sethttpport ('80 ');  - The value 80 is the new parameter 
 3  dbms_xdb.setftpport ( '2100 ') ; - The value 80 is the new parameter 
 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 through HTTP or FTP, you can disable these options as follows:

 
 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