How to change the port number for iSQL*PLUS in Oracle

The default port to access iSQL*PLUS is 5560. You can access iSQL*PLUS with the following URL given that the oracle is installed on the local host ‘http://localhost:5560/isqlplus/’

To change the port number, modify the file “http-web-site.xml” as given below:

E:\oracle\product\10.1.0\db_1\oc4j\j2ee\isqlplus\config>dir

02/11/2011  11:12 PM    <DIR>          .
02/11/2011  11:12 PM    <DIR>          ..
02/11/2011  10:57 PM             2,648 application.xml
02/11/2011  10:57 PM               969 data-sources.xml
02/11/2011  10:57 PM             4,222 global-web-application.xml
02/11/2011  11:12 PM             1,338 http-web-site.xml
02/11/2011  10:57 PM               944 internal-settings.xml
02/11/2011  10:57 PM             7,596 java2.policy
02/12/2011  12:58 AM             6,969 jazn-data.xml
02/11/2011  10:57 PM               270 jazn.xml
02/11/2011  11:12 PM             1,726 jms.xml
02/11/2011  10:57 PM             2,755 mime.types
02/11/2011  10:57 PM               466 oc4j-connectors.xml
02/11/2011  10:57 PM             1,751 principals.xml
02/11/2011  11:12 PM               596 rmi.xml
02/11/2011  11:12 PM             2,322 server.xml
              14 File(s)         34,572 bytes
               2 Dir(s)   3,013,214,208 bytes free

E:\oracle\product\10.1.0\db_1\oc4j\j2ee\isqlplus\config>
E:\oracle\product\10.1.0\db_1\oc4j\j2ee\isqlplus\config>
E:\oracle\product\10.1.0\db_1\oc4j\j2ee\isqlplus\config>notepad http-web-site.xml

Find the following line in this file and change the port to the desired one and save the file.

<web-site port=”5560″ display-name=”OC4J Java HTTP Web Site”>

After that access iSQL*PLUS with the new port number. I changed it to 5550 and accessed iSQL as follows:

Adnan Khurshid

Adnan Khurshid, the author of this article, has been working in a telecommunication sector since 2007. He has worked there as a VAS (Value Added Services) engineer and has excelled remarkably in the field. Working in this field has been his passion and he has always made efforts to keep himself up to date. Find more about him on LinkedIn

More Posts

Tags: iSQL plus port, isqlplus url