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\pro duct\10.2. 0\server\N ETWORK\ADM IN (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\pro duct\10.2. 0\server\B IN>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\pro duct\10.2. 0\server\B IN>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=(PRO TOCOL=IPC) (KEY=EXTPR OC_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\pro duct\10.2. 0\server\n etwork\adm in\listene r.ora
Listener Log File C:\oraclexe\app\oracle\pro duct\10.2. 0\server\n etwork\log \listener. log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (PIPENAME= \\.\pipe\E XTPROC_FOR _XEipc)))
(DESCRIPTION=(ADDRESS=(PRO TOCOL=tcp) (HOST=127. 0.0.1)(POR T=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
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\pro
* Logged into sqlplus as system
• Ran "select dbms_xdb.gethttpport() from dual;" -> returns 8080
• Ran "exec DBMS_XDB.SETHTTPPORT(8090)
• 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\pro
* 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\pro
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=(PRO
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\pro
Listener Log File C:\oraclexe\app\oracle\pro
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO
(DESCRIPTION=(ADDRESS=(PRO
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Didn't really hit at the root of the problem, but at least reminded us to check install logs in the future.
ASKER
I did not originally check for errors in the install logs that I recall...
Thanks,
-iluomo