A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
how to change port number of Oracle 10g xe
Joined: Jun 04, 2008
Oct 16, 2008 09:54:00
I am using Oracle 10g XE. It is working well. This is using port 8080.
Now i am getting problems with
running on the same port.
I want to change Oracle port number.
For this i followed a tutorial.
But when i am following this tutorial i am getting a problem,
C:\WINDOWS\system32>sqlplus system@xe SQL*Plus: Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006 Copyright (c) 1982, 2004, Oracle. All rights reserved. Enter password:
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.
Joined: Jan 24, 2006
Oct 17, 2008 10:01:00
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
Joined: Jul 29, 2011
Sep 26, 2011 08:39:44
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*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 10:40:44 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password: <enter password if will not be visible>
SQL> Exec DBMS_XDB.SETHTTPPORT(8087); [Assuming you want to have HTTP going to this port]
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
I agree. Here's the link:
subject: how to change port number of Oracle 10g xe
trigger to check if a row can be inserted or not
Connectio pool: Oracle and Glassfishv3
IIS Plugin for weblogic throwing connection pool errors
Connection Pool between Oracle10g Express Edition and Glassfish V3
Not able to store ukrainian characters in Oracle 10g database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014