博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
XE: Changing the default http port
阅读量:4561 次
发布时间:2019-06-08

本文共 1812 字,大约阅读时间需要 6 分钟。

Oracle XE uses the embedded http listener that comes with the XML DB (XDB) to serve http requests. The default port for HTTP access is 8080.

It also supports the WebDAV protocol just as well as FTP.
You can determine the current configuration using the following commands when you connect to XE as the oracle user SYSTEM (or any other DBA):

C:\WINDOWS\system32>sqlplus system@xe SQL*Plus: Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006 Copyright (c) 1982, 2004, Oracle.  All rights reserved. Enter password: Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta SQL> -- get current status SQL> select dbms_xdb.gethttpport as "HTTP-Port"             , dbms_xdb.getftpport as "FTP-Port" from dual; HTTP-Port   FTP-Port ---------- ----------      8080          0

You can change the http port and the ftp port to whatever you like (keep in mind that you need special privileges for ports < 1024 on Unix/Linux systems).

SQL> -- set http port and ftp port SQL> begin  2    dbms_xdb.sethttpport('80');  3    dbms_xdb.setftpport('2100');  4  end;  5  / PL/SQL procedure successfully completed. SQL> select dbms_xdb.gethttpport as "HTTP-Port"             , dbms_xdb.getftpport as "FTP-Port" from dual; HTTP-Port   FTP-Port ---------- ----------        80       2100

If you only want to use the database without allowing access via http or ftp then you can disable both:

SQL> -- disable http and ftp access SQL> begin  2    dbms_xdb.sethttpport('0');  3    dbms_xdb.setftpport('0');  4  end;  5  / PL/SQL procedure successfully completed. SQL> -- get current status SQL> select dbms_xdb.gethttpport as "HTTP-Port"             , dbms_xdb.getftpport as "FTP-Port" from dual; HTTP-Port   FTP-Port ---------- ----------         0          0

转载于:https://www.cnblogs.com/sos-blue/p/3398693.html

你可能感兴趣的文章
微信开发 笔记1
查看>>
SQL server 删除日志文件 秒删
查看>>
MethodChannel 实现flutter 与 原生通信
查看>>
lua的性能优化
查看>>
vs2012 出现断点无法命中 解决方案。
查看>>
weex图片加载更多方法loadmore的使用
查看>>
创建您的 ActiveReports Web端在线报表设计器
查看>>
项目复审
查看>>
FreeMarker学习
查看>>
hihocoder 1631
查看>>
2018大都会赛 A Fruit Ninja【随机数】
查看>>
【实战HTML5与CSS3】用HTML5和CSS3制作页面(上)
查看>>
小公司的一年,一起看看小公司的前端可以怎么做
查看>>
oracle数据批处理
查看>>
Json网络解析
查看>>
[转]Google Chrome/IE/FireFox查看HTTP请求头request header响应头
查看>>
Harris角点检测
查看>>
Struts2的处理流程及为Action的属性注入值
查看>>
设计中最常用的CSS选择器
查看>>
Maven项目打包成可执行Jar文件
查看>>