Friday, August 21, 2015

how to change port number of Oracle 10g xe

If you have port conflict and you want to change Oracle 10G XE's HTTP port (default is 8080) you can change it. 

This is what you do in the Windows XP machine. 

Make sure OracleServiceXE and OracleXETNSListener have started in the Control Panel. 

From Start | Run open a command window. 
Assuming your environmental variables are set correctly start with the following: (Reds are what you type-in and blues are what the computer writes to screen) 

SQL> connect 
Enter user-name: system 
Enter password: <enter password if will not be visible> 
Connected. 
SQL> Exec DBMS_XDB.SETHTTPPORT(8087); [Assuming you want to have HTTP going to this port] 

PL/SQL procedure successfully completed. 

SQL>quit