Change default port 8080 in Oracle XE
When two services in system running with the same port, example “8080″, you cant able to get access to those services. For this we have to change the listening port number of any services to other than “8080″ port.
Here I have given how to change the listening port number of Oracle XE Database.
1. To get the current HTTP Listener Port number and FTP Port number, use the below query
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Room>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 22 19:05:48 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> select dbms_xdb.gethttpport as "HTTP-Port",dbms_xdb.getftpport as "FTP-Port " from dual; HTTP-Port FTP-Port ---------- ---------- 8090 0 SQL>
2. To change the HTTP Listener Port number, use the below single command in SQL window.
SQL> begin 2 dbms_xdb.sethttpport('80'); 3 end; 4 /