Modify the 1521, 8080 ports used by Oracle XE Listener

Modifying the 1521, 8080 ports used by Oracle XE Listener today, when helping developers demon install Oraclexe, there is a hint: [SQL]

1. Destination folder:d:\oraclexe\
2. Port for ' Oracle Database Listener ': 1521
3. Port for ' Oracle Services for Microsoft Transaction Server ': 2030
4. Port for HTTP listener:8080

As you can see, the Default Web console service port is 8080 and cannot be changed at installation time. After installation conflicts with servers such as Tomcat, JBoss, and so on, you will encounter many problems. There is a SQL in the XE installation file that can be used to change the port of HTTP.
In the D:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\postDBCreation.sql file. There is a SQL code like this:

[SQL]

1. Begin
2. Dbms_xdb.sethttpport (' 8080 ');
3. Dbms_xdb.setftpport (' 0 ');
4. End
5. /

Look at the log file D:\oraclexe\app\oracle\product\10.2.0\server\config\log\postDBCreation.log, there is a record: [SQL]

1. Sql> begin
2. 2 Dbms_xdb.sethttpport (' 8080 ');
3. 3 Dbms_xdb.setftpport (' 0 ');
4. 4 End;
5. 5/pl/sql procedure successfully completed.

You can see that Oracle XE is using it to set up an HTTP port and open the Sql*plus console. Log in with SYS or system. Then run: [SQL]

1. Begin
2. Dbms_xdb.sethttpport (' 8081 ');
3. Dbms_xdb.setftpport (' 0 ');
4. End
5. /

This will set the port to 8081.

http://my.oschina.net/liuhuiweb/blog/203012

Modify 1521, 8080 ports used by Oracle XE Listener