Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to change port number of Oracle 10g xe

 
sirisha kukunuri
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
I am using Oracle 10g XE. It is working well. This is using port 8080.
Now i am getting problems with Tomcat running on the same port.
I want to change Oracle port number.
For this i followed a tutorial.http://daust.blogspot.com/2006/01/xe-changing-default-http-port.html
But when i am following this tutorial i am getting a problem,


It is asking for password.But it is not allowing me to type.

Can any one please tell me any other way to change port number.

I appreciate any help.

Thanks,
Kukunuri
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually it is taking your password without showing what you have keyed.
Key in the password and press enter , you should then be connected.
 
Sandeep Kumar Arya
Greenhorn
Posts: 2
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 10:40:44 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

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
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic