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

> 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 > -------------------------------------------------------------------------------- >
  1<xdbconfig xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns:xsi="http://w
  2&gt;     ww.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://xmlns.oracle.com/x
  3&gt;     db/xdbconfig.xsd                                     http://xmlns.oracle.com/xdb
  4&gt;     /xdbconfig.xsd">
  5&gt;       <sysconfig>
  6&gt;         <acl-max-age>900</acl-max-age>
  7&gt;         <acl-cache-size>32</acl-cache-size>
  8&gt;         <invalid-pathname-chars>,</invalid-pathname-chars>
  9&gt;         <call-timeout>300</call-timeout>
 10&gt;         <max-session-use>100</max-session-use>
 11&gt;         <default-lock-timeout>3600</default-lock-timeout>
 12&gt;         <resource-view-cache-size>1048576</resource-view-cache-size>
 13&gt;         <protocolconfig>
 14&gt;           <common>
 15&gt;             <extension-mappings>
 16&gt;               <mime-mappings>
 17&gt;                 <mime-mapping>
 18&gt;                   <extension>au</extension>
 19&gt;                   <mime-type>audio/basic</mime-type>
 20&gt;                 </mime-mapping>
 21&gt;                 <mime-mapping>
 22&gt;                   <extension>avi</extension>
 23&gt;                   <mime-type>video/x-msvideo</mime-type>
 24&gt;                 </mime-mapping>
 25&gt;                 <mime-mapping>
 26&gt;                   <extension>bin</extension>
 27&gt;                   <mime-type>application/octet-stream</mime-type>
 28&gt;                 </mime-mapping>
 29&gt;                 <mime-mapping>
 30&gt;                   <extension>bmp</extension>
 31&gt;                   <mime-type>image/bmp</mime-type>
 32&gt;                 </mime-mapping>
 33&gt;                 <mime-mapping>
 34&gt;                   <extension>doc</extension>
 35&gt;                   <mime-type>application/msword</mime-type>
 36&gt;                 </mime-mapping>
 37&gt;                 <mime-mapping>
 38&gt;                   <extension>eml</extension>
 39&gt;                   <mime-type>message/rfc822</mime-type>
 40&gt;                 </mime-mapping>
 41&gt;                 <mime-mapping>
 42&gt;                   <extension>gif</extension>
 43&gt;                   <mime-type>image/gif</mime-type>
 44&gt;                 </mime-mapping>
 45&gt;                 <mime-mapping>
 46&gt;                   <extension>htm</extension>
 47&gt;                   <mime-type>text/html</mime-type>
 48&gt;                 </mime-mapping>
 49&gt;                 <mime-mapping>
 50&gt;                   <extension>html</extension>
 51&gt;                   <mime-type>text/html</mime-type>
 52&gt;                 </mime-mapping>
 53&gt;                 <mime-mapping>
 54&gt;                   <extension>jpe</extension>
 55&gt;                   <mime-type>image/jpeg</mime-type>
 56&gt;                 </mime-mapping>
 57&gt;                 <mime-mapping>
 58&gt;                   <extension>jpeg</extension>
 59&gt;                   <mime-type>image/jpeg</mime-type>
 60&gt;                 </mime-mapping>
 61&gt;                 <mime-mapping>
 62&gt;                   <extension>jpg</extension>
 63&gt;                   <mime-type>image/jpeg</mime-type>
 64&gt;                 </mime-mapping>
 65&gt;                 <mime-mapping>
 66&gt;                   <extension>jsp</extension>
 67&gt;                   <mime-type>text/html</mime-type>
 68&gt;                 </mime-mapping>
 69&gt;                 <mime-mapping>
 70&gt;                   <extension>mid</extension>
 71&gt;                   <mime-type>audio/mid</mime-type>
 72&gt;                 </mime-mapping>
 73&gt;                 <mime-mapping>
 74&gt;                   <extension>mov</extension>
 75&gt;                   <mime-type>video/quicktime</mime-type>
 76&gt;                 </mime-mapping>
 77&gt;                 <mime-mapping>
 78&gt;                   <extension>movie</extension>
 79&gt;                   <mime-type>video/x-sgi-movie</mime-type>
 80&gt;                 </mime-mapping>
 81&gt;                 <mime-mapping>
 82&gt;                   <extension>mp3</extension>
 83&gt;                   <mime-type>audio/mpeg</mime-type>
 84&gt;                 </mime-mapping>
 85&gt;                 <mime-mapping>
 86&gt;                   <extension>mpe</extension>
 87&gt;                   <mime-type>video/mpg</mime-type>
 88&gt;                 </mime-mapping>
 89&gt;                 <mime-mapping>
 90&gt;                   <extension>mpeg</extension>
 91&gt;                   <mime-type>video/mpg</mime-type>
 92&gt;                 </mime-mapping>
 93&gt;                 <mime-mapping>
 94&gt;                   <extension>mpg</extension>
 95&gt;                   <mime-type>video/mpg</mime-type>
 96&gt;                 </mime-mapping>
 97&gt;                 <mime-mapping>
 98&gt;                   <extension>msa</extension>
 99&gt;                   <mime-type>application/x-msaccess</mime-type>
100&gt;                 </mime-mapping>
101&gt;                 <mime-mapping>
102&gt;                   <extension>msw</extension>
103&gt;                   <mime-type>application/x-msworks-wp</mime-type>
104&gt;                 </mime-mapping>
105&gt;                 <mime-mapping>
106&gt;                   <extension>pcx</extension>
107&gt;                   <mime-type>application/x-pc-paintbrush</mime-type>
108&gt;                 </mime-mapping>
109&gt;                 <mime-mapping>
110&gt;                   <extension>pdf</extension>
111&gt;                   <mime-type>application/pdf</mime-type>
112&gt;                 </mime-mapping>
113&gt;                 <mime-mapping>
114&gt;                   <extension>ppt</extension>
115&gt;                   <mime-type>application/vnd.ms-powerpoint</mime-type>
116&gt;                 </mime-mapping>
117&gt;                 <mime-mapping>
118&gt;                   <extension>ps</extension>
119&gt;                   <mime-type>application/postscript</mime-type>
120&gt;                 </mime-mapping>
121&gt;                 <mime-mapping>
122&gt;                   <extension>qt</extension>
123&gt;                   <mime-type>video/quicktime</mime-type>
124&gt;                 </mime-mapping>
125&gt;                 <mime-mapping>
126&gt;                   <extension>ra</extension>
127&gt;                   <mime-type>audio/x-realaudio</mime-type>
128&gt;                 </mime-mapping>
129&gt;                 <mime-mapping>
130&gt;                   <extension>ram</extension>
131&gt;                   <mime-type>audio/x-realaudio</mime-type>
132&gt;                 </mime-mapping>
133&gt;                 <mime-mapping>
134&gt;                   <extension>rm</extension>
135&gt;                   <mime-type>audio/x-realaudio</mime-type>
136&gt;                 </mime-mapping>
137&gt;                 <mime-mapping>
138&gt;                   <extension>rtf</extension>
139&gt;                   <mime-type>application/rtf</mime-type>
140&gt;                 </mime-mapping>
141&gt;                 <mime-mapping>
142&gt;                   <extension>rv</extension>
143&gt;                   <mime-type>video/x-realvideo</mime-type>
144&gt;                 </mime-mapping>
145&gt;                 <mime-mapping>
146&gt;                   <extension>sgml</extension>
147&gt;                   <mime-type>text/sgml</mime-type>
148&gt;                 </mime-mapping>
149&gt;                 <mime-mapping>
150&gt;                   <extension>tif</extension>
151&gt;                   <mime-type>image/tiff</mime-type>
152&gt;                 </mime-mapping>
153&gt;                 <mime-mapping>
154&gt;                   <extension>tiff</extension>
155&gt;                   <mime-type>image/tiff</mime-type>
156&gt;                 </mime-mapping>
157&gt;                 <mime-mapping>
158&gt;                   <extension>txt</extension>
159&gt;                   <mime-type>text/plain</mime-type>
160&gt;                 </mime-mapping>
161&gt;                 <mime-mapping>
162&gt;                   <extension>url</extension>
163&gt;                   <mime-type>text/plain</mime-type>
164&gt;                 </mime-mapping>
165&gt;                 <mime-mapping>
166&gt;                   <extension>vrml</extension>
167&gt;                   <mime-type>x-world/x-vrml</mime-type>
168&gt;                 </mime-mapping>
169&gt;                 <mime-mapping>
170&gt;                   <extension>wav</extension>
171&gt;                   <mime-type>audio/wav</mime-type>
172&gt;                 </mime-mapping>
173&gt;                 <mime-mapping>
174&gt;                   <extension>wpd</extension>
175&gt;                   <mime-type>application/wordperfect5.1</mime-type>
176&gt;                 </mime-mapping>
177&gt;                 <mime-mapping>
178&gt;                   <extension>xls</extension>
179&gt;                   <mime-type>application/vnd.ms-excel</mime-type>
180&gt;                 </mime-mapping>
181&gt;                 <mime-mapping>
182&gt;                   <extension>xml</extension>
183&gt;                   <mime-type>text/xml</mime-type>
184&gt;                 </mime-mapping>
185&gt;                 <mime-mapping>
186&gt;                   <extension>zip</extension>
187&gt;                   <mime-type>application/x-zip-compressed</mime-type>
188&gt;                 </mime-mapping>
189&gt;               </mime-mappings>
190&gt;               <lang-mappings>
191&gt;                 <lang-mapping>
192&gt;                   <extension>en</extension>
193&gt;                   <lang>english</lang>
194&gt;                 </lang-mapping>
195&gt;               </lang-mappings>
196&gt;               <charset-mappings></charset-mappings>
197&gt;               <encoding-mappings>
198&gt;                 <encoding-mapping>
199&gt;                   <extension>gzip</extension>
200&gt;                   <encoding>zip file</encoding>
201&gt;                 </encoding-mapping>
202&gt;                 <encoding-mapping>
203&gt;                   <extension>tar</extension>
204&gt;                   <encoding>tar file</encoding>
205&gt;                 </encoding-mapping>
206&gt;               </encoding-mappings>
207&gt;             </extension-mappings>
208&gt;             <session-pool-size>50</session-pool-size>
209&gt;             <session-timeout>6000</session-timeout>
210&gt;           </common>
211&gt;           <ftpconfig>
212&gt;             **&lt; ftp-port&gt;2111**
213&gt;             <ftp-listener>local_listener</ftp-listener>
214&gt;             <ftp-protocol>tcp</ftp-protocol>
215&gt;             <session-timeout>6000</session-timeout>
216&gt;           </ftpconfig>
217&gt;           <httpconfig>
218&gt;             **&lt; http-port&gt;8081**
219&gt;             <http-listener>local_listener</http-listener>
220&gt;             <http-protocol>tcp</http-protocol>
221&gt;             <session-timeout>6000</session-timeout>
222&gt;             <server-name>XDB HTTP Server</server-name>
223&gt;             <max-header-size>16384</max-header-size>
224&gt;             <max-request-body>2000000000</max-request-body>
225&gt;             <servlet-realm>Basic realm="XDB"</servlet-realm>
226&gt;             <webappconfig>
227&gt;               <welcome-file-list>
228&gt;                 <welcome-file>index.html</welcome-file>
229&gt;                 <welcome-file>index.htm</welcome-file>
230&gt;               </welcome-file-list>
231&gt;               <error-pages></error-pages>
232&gt;               <servletconfig>
233&gt;                 <servlet-mappings>
234&gt;                   <servlet-mapping>
235&gt;                     <servlet-pattern>/Test</servlet-pattern>
236&gt;                     <servlet-name>TestServlet</servlet-name>
237&gt;                   </servlet-mapping>
238&gt;                   <servlet-mapping>
239&gt;                     <servlet-pattern>/oradb/*</servlet-pattern>
240&gt;                     <servlet-name>DBURIServlet</servlet-name>
241&gt;                   </servlet-mapping>
242&gt;                 </servlet-mappings>
243&gt;                 <servlet-list>
244&gt;                   <servlet>
245&gt;                     <servlet-name>TestServlet</servlet-name>
246&gt;                     <servlet-language>Java</servlet-language>
247&gt;                     <display-name>XDB Test Servlet</display-name>
248&gt;                     <description>A servlet to test the internals of the XDB Servlet API</description>
249&gt;                     <servlet-class>xdbtserv</servlet-class>
250&gt;                     <servlet-schema>xdb</servlet-schema>
251&gt;                   </servlet>
252&gt;                   <servlet>
253&gt;                     <servlet-name>DBURIServlet</servlet-name>
254&gt;                     <display-name>DBURI</display-name>
255&gt;                     <servlet-language>C</servlet-language>
256&gt;                     <description>Servlet for accessing DBURIs</description>
257&gt;                     <security-role-ref>
258&gt;                       <role-name>authenticatedUser</role-name>
259&gt;                       <role-link>authenticatedUser</role-link>
260&gt;                     </security-role-ref>
261&gt;                   </servlet>
262&gt;                 </servlet-list>
263&gt;               </servletconfig>
264&gt;             </webappconfig>
265&gt;           </httpconfig>
266&gt;         </protocolconfig>
267&gt;       </sysconfig>
268&gt;     </xdbconfig>