Oracle's default xml db sets the default http port to 8080, which is a very common port. Many other webservers use this port, so we need to modify it. Three methods:
1. Dbca, select your database, and then select standard database features-> Customize-> Oracle xml db option. You should know how to change this screen.
2. OEM console, which is modified in the XML Database Configuration
3. Packages provided by Oracle:
-- Change HTTP/WebDAV port from 8080 to 8081
SQL> call dbms_xdb.cfg_update (updatexml (dbms_xdb.cfg_get (),
'/Xdbconfig/sysconfig/protocolconfig/httpconfig/HTTP-Port/text ()', 8081 ))
/
-- Change FTP port from 2100 to 2111
SQL> call dbms_xdb.cfg_update (updatexml (dbms_xdb.cfg_get (),
'/Xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-Port/text ()', 2111 ))
/
SQL> commit;
SQL> exec dbms_xdb.mongo_refresh;
-- Check whether the modification is successful
SQL> set long 100000
SQL> set pagesize 1000
SQL> select dbms_xdb.get _get from dual;
The following is my Method
SQL> -- change the HTTP/WebDAV port from 8080 to 8081
SQL>Call dbms_xdb.cfg_update (updatexml (
2Dbms_xdb.mongo_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 (
2Dbms_xdb.mongo_get ()
3, '/Xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-Port/text ()'
4, 2111 ))
5/
Call completed.
SQL>Commit;
Commit complete.
SQL>Exec dbms_xdb.mongo_refresh;
PL/SQL procedure successfully completed.
SQL> -- verify the change
SQL>Sets long 100000
SQL>Set pagesize 9000
SQL>Select dbms_xdb.get _get from dual;