changing oracle database port

Default port of servers and services is mainly 8080, in fact oracle XE database default port is also 8080 which gets clashed and create trouble in running other applications.

The procedure to change default oracle database port is as below:

1. login oracle using c:>sqlplus

2. change 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));

3. 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));

4. refresh settings
sql>exec dbms_xdb.cfg_refresh;

5. to verify that port changed
c:>netstat -a

One thought on “changing oracle database port

  1. Pingback: full form of google yahoo icici computer oracle jpeg hsdpa gprs « Kvijayanand's Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.