This discussion is archived
7 Replies Latest reply: Aug 23, 2013 12:41 PM by Arun# RSS

Unable to connect to Database Homepage OracleXE 10.2.0.1.0

xysOra Newbie
Currently Being Moderated

Hi Oracle Experts,

 

I have installed OracleXE 10g on a server for an application and has been running for 3 years. The installation is based on default configuration where:

 

Destination Folder: C:\oraclexe\

Port for Oracle Database Listener: 1521

Port for Oracle Services for Microsoft Transaction Server: 2030

Port for HTTP Listener: 8080

 

The installation work well and able to view the database homepage. The problem arises when local ICT urge to change the Oracle Database Listener port to another port instead of 1521 in order to comply with their security policy.

 

I have changed the port using below method:

 

1) Update the port number in listener.ora to desired port

2) Ensure that SID_name(XE) is registered in listener.ora by adding this line to SID_LIST

 

(SID_DESC =

(SID_NAME = XE)

(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)

)

)  

 

3) Reload the listener and restart the service.

 

I am able to connect to the database using SQL Plus using port the assigned port but when I tried to view the database homepage, I cannot load the page with Internet Explorer connection problem error.

 

I have changed the default HTTP port to 8089 but still unable to connect. But when I switched to the default listener port(1521), I am able to view the database homepage.

 

Does anyone know how to solve this issue?

 

Thank you in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points