国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > Oracle > 正文

Oracle XMLDB 占用了8080端口

2024-08-29 13:33:33
字體:
來源:轉載
供稿:網友
    解決辦法:
  1. 修改xmlDB的端口設置
  2. 禁止XMLDB監聽端口

Change XMLDB Ports

This document eXPlains how to change the default ports (8080 for HTTP and 2100 for FTP) in XMLDB.
Oracle XMLDB uses the ports 2100/8080 by default. Sometimes there are PRoblem with other webservers (e.g. JBOSS) running on the same port.

Even if the package dbms_xdb is granted to PUBLIC you need DBA privileges to change the ports.
用系統治理員身份登陸
-- change HTTP port from 8080 to 8083
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));

-- change FTP port from 2100 to 2111
call dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));

-- refresh settings
exec dbms_xdb.cfg_refresh; 命令示例:SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;


[oracle@test11 oracle]$ sqlplus /nolog
 
SQL*Plus: Release 9.2.0.4.0 - ProdUCtion on Sat Aug 6 14:24:49 2005
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect / as sysdba;
Connected.
-- 把HTTP/WEBDAV端口從8080改到8081
SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8081))
  3  /
Call completed.
-- 把FTP端口從2100改到2111
SQL>  call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
  2  '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()',2111))
  3  /
 
Call completed.
 
SQL> commit;
 
Commit complete.
 
SQL>  exec dbms_xdb.cfg_refresh;
 
PL/SQL procedure successfully completed.
-- 檢查修改是否已經成功
SQL>
select dbms_xdb.cfg_get from dual;
 
CFG_GET
--------------------------------------------------------------------------------
<xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
 
SQL>

[oracle@test11 oracle]$ netstat -ntlp 
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name  
tcp        0      0 0.0.0.0:32768           0.0.0.0:*               LISTEN      -                  
tcp        0      0 127.0.0.1:32769         0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2401            0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:33730           0.0.0.0:*               LISTEN      14987/ora_d000_szdb
tcp        0      0 0.0.0.0:873             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:110             0.0.0.0:*               LISTEN      -       
           
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:8081            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      -                  
tcp        0      0 0.0.0.0:2111            0.0.0.0:*               LISTEN      2473/tnslsnr       
tcp        0      0 :::11009                :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4001   :::*             
       LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:4002   :::*                    LISTEN      -                  
tcp        0      0 :::9090                 :::*                    LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:12005  :::*                    LISTEN      -                  
tcp        0      0 :::12009                :::*                    LISTEN      -                  
tcp        0      0 :::8080                 :::*                    LISTEN      -                  
tcp        0      0 :::80                   :::*                    LISTEN      -                  
tcp        0      0 :::22                   :::*   
                 LISTEN      -                  
tcp        0      0 ::ffff:127.0.0.1:11005  :::*                    LISTEN      -                  
[oracle@test11 oracle]$


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 富蕴县| 碌曲县| 黄陵县| 从化市| 民勤县| 新晃| 锡林郭勒盟| 长兴县| 察隅县| 无为县| 安丘市| 嘉鱼县| 松桃| 黎川县| 乌拉特后旗| 竹山县| 霞浦县| 进贤县| 剑川县| 朔州市| 宜昌市| 河曲县| 巴青县| 新沂市| 星座| 乡城县| 扎兰屯市| 广宁县| 邳州市| 郎溪县| 宝山区| 万宁市| 柳江县| 巩义市| 漾濞| 吉安市| 夏河县| 都安| 湘阴县| 依安县| 浮梁县|