Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Why won't Oracle XE http interface listener (apex) open a port and listen?

Posted on 2011-03-16
Medium Priority
Last Modified: 2012-05-11
Going a little crazy here...

I just installed Oracle 10g XE on my Windows 7 laptop.  This was after a complete uninstall of an installation of the same software that WAS working two days ago.  I DID remove all the registry entries and environment variables associated with the original installation.

Basically, the DB seems to be up... I can connect to port 1521 etc.... netstat NEVER shows use of port 8080 for the web interface listener.

Following is what I've done thus far, in order...

• Run OracleXEUniv.exe to do install (10g Express… 11g Express doesn't seem to exist)
      ¿ Destination Folder: C:\oraclexe\
      ¿ Port for 'Oracle Database Listener': 1521
      ¿ Port for 'Oracle Services for Microsoft Transaction Server': 2030
      ¿ Port for HTTP Listener: 8080
• Finished installing, checked option to open web page… wouldn't load.
• Netstat did not yield any use of 8080 port
• Changed files in C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN (ora files) to point to rather than the hostname of this laptop
* Logged into sqlplus as system
• Ran "select dbms_xdb.gethttpport() from dual;" -> returns 8080
• Ran "exec DBMS_XDB.SETHTTPPORT(8090);  to set port from 8080 to 8090 just for fun
• Ran "select dbms_xdb.gethttpport() from dual;" -> returns 8090
• Rebooted
• Ran "select dbms_xdb.gethttpport() from dual;" -> still returns 8090
• Tnslsnr.exe STILL Not listening on 8080 or 8090 (according to netstat), but IS listening on 1521
• Reboot
• Still not working
• Created McAfee Firewall rules explicitly allowing incoming/outgoing use of 8080/8090
• Created Windows Firewall rules explicitly allowing all incoming/outgoing of 8080/8090
• Stopped Listener Service OracleXETNSListener
• Started Listener Service OracleXETNSListener
• 8080/8090 ports still unused according to netstat -ab, listener still using 1521
• Ran C:\oraclexe\app\oracle\product\10.2.0\server\BIN>oracle -xe force-reload
* Still nothing...
• Ran the following
      ¿ sqlplus / as sysdba
      SQL> startup
      ORA-01081: cannot start already-running ORACLE - shut it down first

      SQL> shutdown
      Database closed.
      Database dismounted.
      ORACLE instance shut down.

      SQL> startup
      ORACLE instance started.
      Total System Global Area  805306368 bytes
      Fixed Size                  1289996 bytes
      Variable Size             209715444 bytes
      Database Buffers          591396864 bytes
      Redo Buffers                2904064 bytes
      Database mounted.
      Database opened.

      C:\oraclexe\app\oracle\product\10.2.0\server\BIN>lsnrctl status
      LSNRCTL for 32-bit Windows: Version - Production on 16-MAR-2011 22:41:10
      Copyright (c) 1991, 2005, Oracle.  All rights reserved.
      STATUS of the LISTENER
      Alias                     LISTENER
      Version                   TNSLSNR for 32-bit Windows: Version - Production
      Start Date                16-MAR-2011 22:27:03
      Uptime                    0 days 0 hr. 14 min. 7 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Default Service           XE
      Listener Parameter File   C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
      Listener Log File         C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
      Listening Endpoints Summary...
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
        Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

Please help!

Question by:iluomo227
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 74

Accepted Solution

sdstuber earned 1000 total points
ID: 35162750
I just installed XE on my windows 7 and worked fine.
Check for any errors in the install logs.
Also, did you install it as an administrator?

Author Comment

ID: 35166775
I did install as admin......  I spent another couple hours on this, went to bed.... next day I uninstalled AGAIN and reinstalled using the same MSI.....  and it all worked.  I'm glad of it, though regretful that I didn't really learn anything.

I did not originally check for errors in the install logs that I recall...


Author Closing Comment

ID: 35166786
Didn't really hit at the root of the problem, but at least reminded us to check install logs in the future.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question