Solution to the default port conflict between Oracle XDB and various App servers

XDBProvides an XDB Server Service for Oracle databases to operate XML Object objects, including XML structure management and XML access control management. But XDB is actually quite familiar, but XDB Server Service, because of itsDefault portThe setting is 8080, which is in conflict with various application servers (the http port of most app servers is 8080). Change the default port of XDB Server. Unfortunately, unlike most software, many ORACLE configurations are not stored in plain text configuration files, but in databases (/sys/xdbconfig. xml ). this requires you to modify the configuration through database operations.

Solution:

1. Log On As sysdba.

2. run the dbms_xdb.mongo_update () method SQL> call dbms_xdb.mongo_update (updateXML (batch (), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text ()', 9090 )); call completed.

3. SQL> commit; Commit complete. This statement is not necessary because dbms_xdb.cfg_update is auto-commit.

4. SQL> EXEC dbms_xdb.cfg_refresh; PL/SQL procedure successfully completed.

0-Production

The statement With the Partitioning, OLAP and Data Mining options is also unnecessary. This statement makes the current change take effect immediately in this session. even if this statement is not added, you can log on to sqlplus again (equivalent to re-opening an oracle session) to see the effect of oracle changes.

Many oracle configurations are "Hot change" (runtime config). After the changes, the changes will be made in other newly opened sessions.

5. view the results:

Here, we see an XMLType field:

 
 

  
  
SQL> SELECT dbms_xdb.cfg_get FROM dual; pai_get
  
  
 
  
  
<Xdbconfig xmlns = "http://xmlns.oracle.com/xdb/xdbconfig.xsd" xmlns: xsi = "http: // w-only show this point, you need to reset the row mode page Mode
  
  
 
  
  
SQL> set long 100
  
  
 
  
  
SQL> set pagesize 100 SQL> SELECT dbms_xdb.pai_get FROM dual; pai_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>
  
  
 
  
  
<Protocolconfig>
  
  
 
  
  
<Ftpconfig>
  
  
 
  
  
<Ftp-port> 0 </ftp-port>
  
  
 
  
  
<Ftp-listener> local_listener </ftp-listener>
  
  
 
  
  
<Ftp-protocol> tcp </ftp-protocol>
  
  
 
  
  
<Logfile-path/>
  
  
 
  
  
<Log-level> 0 </log-level>
  
  
 
  
  
<Session-Time Out> 6000 </session-timeout>
  
  
 
  
  
<Buffer-size> 8192 </buffer-size>
  
  
 
  
  
</Ftpconfig>
  
  
 
  
  
<Httpconfig>
  
  
 
  
  
<Http-port> 9090  
  
 
  
  
<Http-listener> local_listener  
  
 
  
  
<Http-protocol> tcp  
  
 
  
  
<Max-http-headers> 64 </max-http-headers>
  
  
 
  
  
<Max-header-size> 16384 </max-header-size>
  
  
 
  
  
<Max-request-body> 2000000000 </max-request-body>
  
  
 
  
  
<Session-Time Out> 6000 </session-timeout>
  
  
 
  
  
<Server-name> xdb http Server </server-name>
  
  
 
  
  
</Protocolconfig>
  
  
 
  
  
<Xdbcore-xobmem-bound> 1024 </xdbcore-xobmem-bound>
  
  
 
  
  
<Xdbcore-loadableunit-size> 16 </xdbcore-loadableunit-size>
  
  
 
  
  
</Sysconfig>
  
  
 
  
  
</Xdbconfig>
 
 

The solution to the conflict between the XDB and the default port of the APP Server of the Oracle database is described here. I hope this introduction will bring you some benefits. Thank you!