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
username:
password:
sql>

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s