1 2 Previous Next 23 Replies Latest reply on Aug 18, 2009 6:52 PM by 717963

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

    706415
      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
        • 1. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
          SanjayRs
          By any chance do you have a firewall installed that is blocking the port.

          SS
          • 2. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
            706415
            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.
            • 3. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
              706415
              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
              • 4. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                713087
                Did you ever get this resolved? I am having the same issue.
                • 5. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                  Laurent.B
                  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.
                  • 6. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                    714341
                    I have the same problem, reinstalling did not fix it. Any solutions?
                    • 7. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                      Florian W.
                      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
                      • 8. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                        714341
                        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
                        • 9. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                          Florian W.
                          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.
                          • 10. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                            714341
                            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
                            • 11. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                              Florian W.
                              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.
                              • 12. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                                714341
                                I'll try that. thanks!
                                Einat
                                • 13. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                                  713087
                                  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
                                  • 14. Re: Cannot access http://127.0.0.1:8080/apex on Windows XP
                                    714341
                                    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
                                    1 2 Previous Next