【转】Oracle数据库修改端口

最新推荐文章于 2025-01-06 13:23:35 发布

转载最新推荐文章于 2025-01-06 13:23:35 发布 · 1k 阅读

文章标签：

#oracle #数据库 #database #express #access #system

本文介绍如何在Oracle XE中更改HTTP默认端口8080及FTP端口，并提供禁用这两个端口的方法。通过SQL*Plus执行PL/SQL块，可以轻松实现端口设置。

Wednesday, January 25, 2006

XE: Changing the default http port

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@xeSQL*Plus:
Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006Copyright (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