Changing Oracle DB Default ports

ORACLE DB Default port number change
-----------------------------------------
If you want to change the oracle port whether Tomcat using port number 8080.

You can simply execute the following statements in SQL *Plus.

The following section desctibes the syntax that can be used to alter XML DB configuration
information from within SQL*Pus. Ensure that you are logged into the database from a DBA account. In the following example, the default HTTP and FTP ports are changed from 8080 and 2100 to 8083 and 2111 respectively:

SQL> -- Change the HTTP port from 8080 to 8083
SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),'/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8083))
/
Call completed.

SQL> -- Change the FTP port from 2011 to 2111
SQL> call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),
'/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()',2111))
/
Call completed.

SQL> COMMIT;
Commit complete.

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

-----------Verify the change---------------
You can view the xml file whatever you changed in the CALL command.

SQL> set long 100000
SQL> set pagesize 9000
SQL> SELECT dbms_xdb.cfg_get FROM dual;

Thanks,
Veera
Software Engineer,
ClimbInc,
http://www.climb.co.jp

Database replication software
DBMoto http://www.hitsw.com

Virtualization software
Veeam http://www.veeam.com