Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5087
  • Last Modified:

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

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!

  • 2
1 Solution
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?
iluomo227Author Commented:
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...

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now