修改oracle xe的8080端口

1.用sys管理员身份登录,利用dbms_xdb修改端口设置

 SQL> -- Change the HTTP/WEBDAV port from 8080 to 8081
  SQL> call dbms_xdb.cfg_update(updateXML(
    2        dbms_xdb.cfg_get()
    3      , '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()'
    4      , 8081))
    5  /

 SQL> -- Change the FTP port from 2100 to 2111
  SQL> call dbms_xdb.cfg_update(updateXML(
    2         dbms_xdb.cfg_get()
    3       , '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()'
    4       , 2111))
    5  /
  Call completed.

  SQL> COMMIT;

  Commit complete.

  SQL> EXEC dbms_xdb.cfg_refresh;

  PL/SQL procedure successfully completed.

2. 执行services.msc,进入服务,重启Oracle数据库相关的几个服务

3. 修改D:oraclexeapporacleproduct11.2.0server下的Get_Started快捷方式的值为http://127.0.0.1:8081/apex/f?p=4950

  

原文地址:https://www.cnblogs.com/startnow/p/7448905.html