Forum Stats

  • 3,722,519 Users
  • 2,244,327 Discussions
  • 7,849,902 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Cannot access http://127.0.0.1:8080/apex on Windows XP

706415
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
Tagged:

Answers

  • SanjayRs
    SanjayRs Member Posts: 3,024
    By any chance do you have a firewall installed that is blocking the port.

    SS
  • 706415
    706415 Member Posts: 3
    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.
  • 706415
    706415 Member Posts: 3
    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
  • 713087
    713087 Member Posts: 2
    Did you ever get this resolved? I am having the same issue.
  • Laurent.B
    Laurent.B Member Posts: 4
    edited July 2009
    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.
  • 714341
    714341 Member Posts: 5
    I have the same problem, reinstalling did not fix it. Any solutions?
  • Florian W.
    Florian W. Member Posts: 1,324
    edited July 2009
    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
  • 714341
    714341 Member Posts: 5
    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
  • Florian W.
    Florian W. Member Posts: 1,324
    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.
  • 714341
    714341 Member Posts: 5
    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
  • Florian W.
    Florian W. Member Posts: 1,324
    Hi again!

    That doesn't look very good. One last try. Please tell me have you installed Oracle XE as the user administrator or as a user with administrative rights? I must admit that I don't know why but you have to be the user Administrator to install Oracle XE correctly. Please try to uninstall your Oracle XE and reinstall again as user Administrator.

    Yours sincerely

    Florian W.
  • 714341
    714341 Member Posts: 5
    I'll try that. thanks!
    Einat
  • 713087
    713087 Member Posts: 2
    I have tried all the above as well. As company policy, I have Administrator Rights to my computer. The company has a lot of Oracle databases on the servers, could this be a cause of the problems? Or some group policy?

    Thanks
  • 714341
    714341 Member Posts: 5
    Hi,

    I tried to install as administrator, and it still doesn't work. Then changed the files as you suggested, but still no change. I keep getting:

    Error 46 initializing SQL*Plus
    HTTP proxy setting has incorrect value
    SP2-1502: The HTTP proxy server specified by http_proxy is not accessible

    any ideas?
    thanks,
    Einat
  • Florian W.
    Florian W. Member Posts: 1,324
    Hi Einat!

    If this all doesn't help anything then I've to admit that I don't have any ideas how to help you. Maybe there are some Windows Security Features that prevent you form using Oracle but this is only a wild guess from me. Sorry that I couldn't help you.

    Yours sincerely

    Florian W.
  • Johnny98
    Johnny98 Member Posts: 150
    edited July 2009
    I installed 10g express yesterday as well as APEX and developed a small application. When I tried to connect to APEX from the home page TODAY, no page comes up?! Seems like many people are having the same problem...is there a viable solution for this issue? I can connect to Oracle no problem, I just can't get to http://127.0.0.1:8080/apex.

    My listener log is failing, but have no idea why or how to fix it...here is the listener.ora log:

    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JUL-2009 08:11:27
    Copyright (c) 1991, 2005, Oracle. All rights reserved.
    System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
    Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
    Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
    Trace level is currently 0
    Started with pid=2832
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Stevens)(PORT=1521)))
    TNS-12546: TNS:permission denied
    TNS-12560: TNS:protocol adapter error
    TNS-00516: Permission denied
    32-bit Windows Error: 13: Permission denied
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))

    Here is my LISTENER.ORA:
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = Stevens)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)

    Here is my SQLNET.ORA:
    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    #NAMES.DIRECTORY_PATH= (TNSNAMES)


    Please advise

    Edited by: user3512717 on Jul 30, 2009 7:53 AM

    Edited by: user3512717 on Jul 30, 2009 10:28 AM
  • 715028
    715028 Member Posts: 19
    Before Installing Oracle,make sure to disable all the network adapters and ping in cmd prompt localhost and ur machine name, both shud refer to 127.0.0.1. Once oracle is installed,try to connect in ur web explorer and once connected,enable the network adapters. There shudnt be any firewall prob.,if it does add port 8080 as an exception to ur firewall list.
  • 717257
    717257 Member Posts: 2
    I've got the same problem.

    But, I also not sure how to disable network adaptors and to ping in to my local command...

    can you help?
  • Johnny98
    Johnny98 Member Posts: 150
    Not sure what you are trying to do...to disable the network adapters, just unplug from the network.
  • 715028
    715028 Member Posts: 19
    open control pane-->dbl click network connections-->disable all the network adapters
    also make sure in the internet options,On the security tab,add 127.0.0.1 to trusted sites if it is not added.
  • 717926
    717926 Member Posts: 1
    Hello!

    Same problem with Windows XP also. Since it seems like a common issue, is someone from Oracle can help us?

    Thank you!

    Francis
  • Johnny98
    Johnny98 Member Posts: 150
    I've tried everything imaginable and it still doesn't work...most frustrating thing about this whole experience is that it worked at one point in time! I had 10gXE running with APEX on top and developed a 3-screen application...next day "Internet explorer cannot display page".

    I've been through every thread on this issue (and there are over 20) from the past 6 months and not one solution worked for me. My latest attempts were to download the Universal version and forcing the system password to be 'system'. My listener does not recognize XE...that is my problem.
  • 717963
    717963 Member Posts: 1
    I have Win XP Pro and have the same or very similar problem. I installed Oracle SQL XE 10.2 and when I click on link
    "Go to Database Home Page" I get a pop up message that page is not available, but about 20 seconds later some sql related software finally gets 'loaded' into memory and I get a browser-based window to plug in my username and password. I just ignore the pop up message and everything works just fine.
This discussion has been closed.