修改Oracle Express的HTTP port

Oracle database express edition default http port是8080,容易與其他的web server衝到，以下指令可將其改為8087

C:\>sqlplus /nolog

SQL> connect
Enter user-name: system
Enter password: <輸入密碼>
Connected.
SQL> Exec DBMS_XDB.SETHTTPPORT(8087);

PL/SQL procedure successfully completed.

SQL>quit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 – Production

修改後立即生效。