Link to home
Start Free TrialLog in
Avatar of iluomo227
iluomo227

asked on

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 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
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of iluomo227
iluomo227

ASKER

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
Didn't really hit at the root of the problem, but at least reminded us to check install logs in the future.