Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Cannot access http://127.0.0.1:8080/apex on Windows XP

706415
Member Posts: 3
After installing oracle10gXE on windows XP, I am not able to access apex hitting http://127.0.0.1:8080/apex.
I tried the following:
- checked using netstat -a to see if other process was listening on 8080
- double check again using telnet localhost 8080
- verified that oracle was running
- re-installed oracle10Gxe
- lsnrctl status shows that the HTTP listener is not listening
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JUN-2009 10:04
:40
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 - Produ
ction
Start Date 11-JUN-2009 09:16:31
Uptime 0 days 0 hr. 48 min. 13 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\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sysbios3.americas.hpqcorp.net)(PORT=
1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 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
What should I do next?
Thanks in advance for the help,
Eric
I tried the following:
- checked using netstat -a to see if other process was listening on 8080
- double check again using telnet localhost 8080
- verified that oracle was running
- re-installed oracle10Gxe
- lsnrctl status shows that the HTTP listener is not listening
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JUN-2009 10:04
:40
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 - Produ
ction
Start Date 11-JUN-2009 09:16:31
Uptime 0 days 0 hr. 48 min. 13 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\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sysbios3.americas.hpqcorp.net)(PORT=
1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 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
What should I do next?
Thanks in advance for the help,
Eric
Tagged:
Answers
-
By any chance do you have a firewall installed that is blocking the port.
SS -
I am runnin Symantec End Point protection 11.0.2010.25:
Logs does not show it has blocked the port 8080
and I tried to setup Apache to listen to 8080 as troubleshooting step toward "firewall potential issue", and it worked.
So I don't think my personnal firewall is in the way. -
looking at the logs after install I see this css.log uner C:\oraclexe\app\oracle\product\10.2.0\server\log\sysbios3\client
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
[ OCRUTL][8508]u_set_comp_error: Parameter was NULL
[ OCRUTL][8508]u_set_ocr_error: Parameter was NULL
2009-06-11 14:55:59.513: [ OCROSD][8508]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.
[ OCRUTL][8508]u_set_gbl_comp_error: Parameter was NULL
[ OCRUTL][8508]u_set_gbl_comp_error: Parameter was NULL
2009-06-11 14:55:59.513: [ OCRRAW][8508]proprinit: Could not open raw device
2009-06-11 14:55:59.513: [ default][8508]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][8508]u_set_ocr_error: Parameter was NULL
2009-06-11 14:55:59.513: [ CSSCLNT][8508]clsssinit: error(33 ) in OCR initialization
[ OCRUTL][8508]u_set_comp_error: Parameter was NULL
[ OCRUTL][8508]u_set_ocr_error: Parameter was NULL
2009-06-11 14:56:01.216: [ OCROSD][8508]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.
[ OCRUTL][8508]u_set_gbl_comp_error: Parameter was NULL
[ OCRUTL][8508]u_set_gbl_comp_error: Parameter was NULL
2009-06-11 14:56:01.216: [ OCRRAW][8508]proprinit: Could not open raw device
2009-06-11 14:56:01.216: [ default][8508]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][8508]u_set_ocr_error: Parameter was NULL
2009-06-11 14:56:01.216: [ CSSCLNT][8508]clsssinit: error(33 ) in OCR initialization
[ OCRUTL][4644]u_set_comp_error: Parameter was NULL
[ OCRUTL][4644]u_set_ocr_error: Parameter was NULL
2009-06-11 14:56:06.136: [ OCROSD][4644]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.
[ OCRUTL][4644]u_set_gbl_comp_error: Parameter was NULL
[ OCRUTL][4644]u_set_gbl_comp_error: Parameter was NULL
2009-06-11 14:56:06.136: [ OCRRAW][4644]proprinit: Could not open raw device
2009-06-11 14:56:06.136: [ default][4644]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][4644]u_set_ocr_error: Parameter was NULL
2009-06-11 14:56:06.136: [ CSSCLNT][4644]clsssinit: error(33 ) in OCR initialization
and I do see other logs: sqlnet.log is full of:
***********************************************************************
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 11-JUN-2009 14:56:46
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
could this be related?
Also I see that the install progress bar jump from 60% to the fisnish page, so I wonder if the install really succeded?
Eric -
Did you ever get this resolved? I am having the same issue.
-
I had the same issue...
After a reinstall of Oracle Database XE, the home page is finally working.
If I take a look into the css.log file, I still have the mentioned errors above. Then, it seems there is no relation with the 8080 service issue. -
I have the same problem, reinstalling did not fix it. Any solutions?
-
Hi to all those have trouble with Oracle XE and APEX!
After successfully installing Oracle XE the listener should show an output like this:LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-JUL-2009 15:51:57 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 Linux: Version 10.2.0.1.0 - Production Start Date 27-JUL-2009 17:06:02 Uptime 0 days 22 hr. 45 min. 54 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=FE-VS-26-16-MAT.IT-TRAINING.FUS)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=FE-VS-26-16-MAT.IT-TRAINING.FUS)(PORT=8080))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "XE" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "XEXDB" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "XE_XPT" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... The command completed successfully
It does not matter that I've shown the output of an Oracle XE running on Linux. The listener should show the same output on Windows too. The important lines in this output are the following ones:Service "XE" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "XEXDB" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Service "XE_XPT" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service...
The XEXDB service is the one that is responsible for connections with APEX. If this service is not running then no one can connect to APEX.
One approach to get things running is to comment out the following line in the %ORACLE_HOME%\network\admin\sqlnet.ora file:#SQLNET.AUTHENTICATION_SERVICES= (NTS)
After commenting out this line please restart the listener and register your oracle instance with the listener.lsnrctl stop lsnrctl start sqlplus / as sysdba ALTER SYSTEM REGISTER; exit lsnrctl status
Now the listener should show the XEXDB service and you can try to connect to APEX with your browser.
If this does not work then again change your sqlnet.ora file like this:#SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.AUTHENTICATION_SERVICES= (NONE)
Yours sincerely
Florian W.
Edited by: Florian W. on 28.07.2009 16:08 -
thanks for your fast reply! unfortunately it did not work. I got:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 28-JUL-2009 17:30:27
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 28-JUL-2009 17:29:57
Uptime 0 days 0 hr. 0 min. 33 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=einatsi.rosettagenomics.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 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 -
Hi again!
OK, Another approach is tell your instance the name of the listener where it should dynamically register.
1.) Edit your %ORACLE_HOME%\network\admin\tnsname.ora# tnsnames.ora Network Configuration File: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = einatsi.rosettagenomics.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) XE_LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = einatsi.rosettagenomics.com)(PORT = 1521)) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
2.) Start SQL*Plus as sysdba and register your instance with your listener.sqlplus sys/password as sysdba ALTER SYSTEM SET local_listener=XE_LISTENER; ALTER SYSTEM REGISTER; exit
3.) Check the listener status if it is correct.
I hope that this one will help you along.
Best Regards
Florian W. -
Hi,
After replacing the script in tnsnames.ora with that you provided in 1)
and running:
sqlplus sys/password as sysdba
I got:
C:\Documents and Settings\einat_si>sqlplus sys/password as sysdba
Error 46 initializing SQL*Plus
HTTP proxy setting has incorrect value
SP2-1502: The HTTP proxy server specified by http_proxy is not accessible
Since we do not have a proxy here, I'm puzzled...
thanks,
Einat
This discussion has been closed.