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

Posted on 2011-03-16
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
  • 2
LVL 73

Accepted Solution

sdstuber earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
statspack purge automate 7 53
Oracle - Create Procedure with Paramater 16 57
Fastest way to replace data in Oracle 5 51
Use of Exception to end a Loop 3 20
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now