Solved

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

Posted on 2011-03-16
3
4,555 Views
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 127.0.0.1 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.
      SQL>



      C:\oraclexe\app\oracle\product\10.2.0\server\BIN>lsnrctl status
      
      LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-MAR-2011 22:41:10
      
      Copyright (c) 1991, 2005, Oracle.  All rights reserved.
      
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - 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...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
      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!

Thanks,
-iluomo
0
Comment
Question by:iluomo227
  • 2
3 Comments
 
LVL 73

Accepted Solution

by:
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?
0
 

Author Comment

by:iluomo227
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...

Thanks,
-iluomo
0
 

Author Closing Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

758 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

14 Experts available now in Live!

Get 1:1 Help Now