科技行者

行者学院 转型私董会 科技行者专题报道 网红大战科技行者

知识库

知识库 安全导航

至顶网软件频道改变或关闭Oracle XDB的ftp和http端口

改变或关闭Oracle XDB的ftp和http端口

  • 扫一扫
    分享文章到微信

  • 扫一扫
    关注官方公众号
    至顶头条

ET   --------------------------------------------------------------------------------   

作者:中国IT实验室 来源:中国IT实验室 2007年9月15日

关键字: 数据库 ORACLE

  • 评论
  • 分享微博
  • 分享邮件

  The following section describes the syntax that can be used to alter XML DB configuration information from within SQL*Plus. Ensure that you are logged into the database from a DBA account. In the following example, the default HTTP/WebDAV and FTP ports are changed from 8080 and 2100 to 8081 and 2111 respectively:
  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 /
  
  Call completed.
  
  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.
  
  SQL> -- Verify the change
  SQL> set long 100000
  SQL> set pagesize 9000
  SQL> SELECT dbms_xdb.cfg_get FROM dual;
  
  CFG_GET
  --------------------------------------------------------------------------------
  <xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
  ww.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/x
  db/xdbconfig.xsd                   http://xmlns.oracle.com/xdb
  /xdbconfig.xsd">
  <sysconfig>
  <acl-max-age>900</acl-max-age>
  <acl-cache-size>32</acl-cache-size>
  <invalid-pathname-chars>,</invalid-pathname-chars>
  <call-timeout>300</call-timeout>
  <max-session-use>100</max-session-use>
  <default-lock-timeout>3600</default-lock-timeout>
  <resource-view-cache-size>1048576</resource-view-cache-size>
  <protocolconfig>
  <common>
  <extension-mappings>
  <mime-mappings>
  <mime-mapping>
  <extension>au</extension>
  <mime-type>audio/basic</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>avi</extension>
  <mime-type>video/x-msvideo</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>bin</extension>
  <mime-type>application/octet-stream</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>bmp</extension>
  <mime-type>image/bmp</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>doc</extension>
  <mime-type>application/msword</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>eml</extension>
  <mime-type>message/rfc822</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>gif</extension>
  <mime-type>image/gif</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>htm</extension>
  <mime-type>text/html</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>html</extension>
  <mime-type>text/html</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>jpe</extension>
  <mime-type>image/jpeg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>jpeg</extension>
  <mime-type>image/jpeg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>jpg</extension>
  <mime-type>image/jpeg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>jsp</extension>
  <mime-type>text/html</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mid</extension>
  <mime-type>audio/mid</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mov</extension>
  <mime-type>video/quicktime</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>movie</extension>
  <mime-type>video/x-sgi-movie</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mp3</extension>
  <mime-type>audio/mpeg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mpe</extension>
  <mime-type>video/mpg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mpeg</extension>
  <mime-type>video/mpg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>mpg</extension>
  <mime-type>video/mpg</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>msa</extension>
  <mime-type>application/x-msaccess</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>msw</extension>
  <mime-type>application/x-msworks-wp</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>pcx</extension>
  <mime-type>application/x-pc-paintbrush</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>pdf</extension>
  <mime-type>application/pdf</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>ppt</extension>
  <mime-type>application/vnd.ms-powerpoint</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>ps</extension>
  <mime-type>application/postscript</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>qt</extension>
  <mime-type>video/quicktime</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>ra</extension>
  <mime-type>audio/x-realaudio</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>ram</extension>
  <mime-type>audio/x-realaudio</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>rm</extension>
  <mime-type>audio/x-realaudio</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>rtf</extension>
  <mime-type>application/rtf</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>rv</extension>
  <mime-type>video/x-realvideo</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>sgml</extension>
  <mime-type>text/sgml</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>tif</extension>
  <mime-type>image/tiff</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>tiff</extension>
  <mime-type>image/tiff</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>txt</extension>
  <mime-type>text/plain</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>url</extension>
  <mime-type>text/plain</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>vrml</extension>
  <mime-type>x-world/x-vrml</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>wav</extension>
  <mime-type>audio/wav</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>wpd</extension>
  <mime-type>application/wordperfect5.1</mime-type>
  </mime-mapping>
  <mime-mapping>
  <extension>xls</extension>
  <mime-type>application/vnd.ms-excel</mime-type>
  </mime-mapping>
  <mime-mapp

查看本文来源

    • 评论
    • 分享微博
    • 分享邮件
    邮件订阅

    如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。

    重磅专题
    往期文章
    最新文章