DBMS_XDB_CONFIG用来配置Enterprise Manager Database Express(EM)通过自定义用HTTPS,HTTP的什么端口来连接,还可以配置FTP来连接数据库。。

DBMS_XDB_CONFIG的配置:

查看端口:

               select dbms_xdb_config.gethttpport() from dual;

              select dbms_xdb_config.gethttpsport () from dual;

             select dbms_xdb_config.getftpport () from dual;

开启并设置一个端口:

              exec DBMS_XDB_CONFIG.setHTTPPort(8888);

              exec DBMS_XDB_CONFIG.setHTTPsPort(8888);

              exec DBMS_XDB_CONFIG.setFTPPort(8888);

关闭:

              exec DBMS_XDB_CONFIG.setHTTPPort(0);

              exec DBMS_XDB_CONFIG.setHTTPsPort(0);

              exec DBMS_XDB_CONFIG.setFTPPort(0);

 

看全部的信息:

SELECT DBMS_XDB.cfg_get() FROM DUAL;

 

DBMS_XDB: Configuration Management Functions and Procedures

Function/Procedure Description

cfg_get

Returns the configuration information for the current session.

cfg_refresh

Refreshes the session configuration information using the current Oracle XML DB configuration file, xdbconfig.xml.

cfg_update

Updates the Oracle XML DB configuration information. This writes the configuration file, xdbconfig.xml.

getFTPPort

Returns the current FTP port number.

getHTTPPort

Returns the current HTTP port number.

setFTPPort

Sets the Oracle XML DB FTP port to the specified port number.

setHTTPPort

Sets the Oracle XML DB HTTP port to the specified port number.