1 2 3 4 Previous Next 75 Replies Latest reply: Nov 20, 2012 2:25 AM by Roman_OCP Go to original post RSS
      • 15. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
        Johnny98
        Hello Varad,
        Here is the output from a LSNRCTL -> Start:

        TNS-12546: TNS:permission denied
        TNS-12560: TNS:protocol adapter error
        TNS-00516: Permission denied
        32-bit Windows Error: 13: Permission denied

        Thanks,
        John
        • 16. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
          438381
          OK. Restore listener.ora to its usual name. Change the 'host' in the listener address to 'localhost' instead or 'stevens'. Try starting the listener.
          • 17. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
            Johnny98
            Hello Varad,
            I have to step out for a bit, but will perform this change as soon as I get back. Thank you in advance for all of your help thus far...I have been trying everything I could find for the past week!

            Thanks,
            John
            • 18. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
              Johnny98
              Hello Varad -
              I got the TNSListener working so I'm able to hit data via SQLPlus and my listener is turned on...however I still can't get to the http://127.0.0.1:8080/apex "Database Home Page". It just says "Internet Explorer cannot display page"

              Here is the output for my listener.log:
              TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-AUG-2009 17:20:09

              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=1384
              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)))

              TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-AUG-2009 17:28:50

              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=816
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
              Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
              Listener completed notification to CRS on start

              TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
              05-AUG-2009 17:28:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Beth Stevens))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
              05-AUG-2009 17:29:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Beth Stevens))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0



              Help! I'm almost there!

              Thanks,
              john

              Edited by: user3512717 on Aug 5, 2009 4:36 PM
              • 19. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                438381
                John:

                Yes, it does appear that you have made progress with getting the issue resolved. Let's take a look at a few more settings.

                From the cmd line execute

                lsnrctl serv

                From sqlplus as the sys user

                show parmater dispatcher

                select dbms_xdb.gethttpport from dual;

                Paste the output from the above commands back to this thread.

                Varad
                • 20. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                  Johnny98
                  Microsoft Windows XP [Version 5.1.2600]
                  (C) Copyright 1985-2001 Microsoft Corp.

                  C:\Documents and Settings\Beth Stevens>lsnrctl serv

                  LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-AUG-2009 19:59
                  :13

                  Copyright (c) 1991, 2005, Oracle. All rights reserved.

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                  Services Summary...
                  Service "CLRExtProc" has 1 instance(s).
                  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  Handler(s):
                  "DEDICATED" established:0 refused:0
                  LOCAL SERVER
                  Service "PLSExtProc" has 1 instance(s).
                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  Handler(s):
                  "DEDICATED" established:0 refused:0
                  LOCAL SERVER
                  The command completed successfully

                  C:\Documents and Settings\Beth Stevens>

                  GETHTTPPORT: 8080

                  Edited by: user3512717 on Aug 5, 2009 7:00 PM
                  • 21. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                    438381
                    John:

                    Please post your current 'listener.ora' and the value of the 'dispatchers' parameter which you can obtain as follows

                    From sqlplus as the sys user

                    show parmater dispatcher

                    Varad
                    • 22. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                      Johnny98
                      Hello Varad,
                      Sorry I didn't know the dispatchers was a command the first time...here you go:
                      SQL> show parameter dispatcher

                      NAME TYPE VALUE
                      ------------------------------------ ----------- ------------------------------
                      dispatchers string (PROTOCOL=TCP) (SERVICE=XEXDB)
                      max_dispatchers integer


                      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 = localhost)(PORT = 1521))
                      )
                      )

                      DEFAULT_SERVICE_LISTENER = (XE)
                      • 23. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                        438381
                        John:

                        Add a HTTP listening end-point to the listener.ora file as show below and then


                        LISTENER =
                        (DESCRIPTION_LIST =
                        (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                        )
                        (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = tcp)(HOST =localhost )(PORT = 8080))
                        (Presentation = HTTP)(Session = RAW)
                        )
                        )


                        Start and stop the listener
                        From SQLplus as the sys user
                        alter system register ;
                        exit;


                        Check if you access the APEX home page. If not, post the output from running

                        lsnrctl status
                        • 24. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                          Johnny98
                          Hello Varad,
                          Performed those actions but could not hit the APEX page...here is my lsnrctl status. Also, do I need to do anything with my hosts file?

                          LSNRCTL> status
                          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 06-AUG-2009 07:27:33
                          Uptime 0 days 0 hr. 0 min. 57 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=127.0.0.1)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
                          HTTP)(Session=RAW))
                          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
                          LSNRCTL>
                          • 25. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                            438381
                            John:

                            You should be able to address 'localhost' without having to make any change to the 'hosts' file.
                            Now, modify the SID_LIST in listener.ora as below. Stop and start the listener. Post the result of executing 'lsnrctl status'


                            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)
                            )
                            (SID_DESC =
                            (SID_NAME = XE)
                            (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
                            (PROGRAM = oracle)
                            )
                            )
                            • 26. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                              Johnny98
                              Hello Varad:
                              Here is the output after your SID_DESC change and lsnrctl status:

                              LSNRCTL> status
                              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 06-AUG-2009 07:50:22
                              Uptime 0 days 0 hr. 0 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\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=127.0.0.1)(PORT=1521)))
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
                              HTTP)(Session=RAW))
                              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...
                              Service "XE" has 1 instance(s).
                              Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
                              The command completed successfully
                              • 27. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                                438381
                                John:

                                All of this looks good. What happens if you enter 'http://localhost:8080' into the browser's URL window ?

                                Varad
                                • 28. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                                  Johnny98
                                  Hello Varad,
                                  Unfortunately, the same thing. If I enter http://localhost:8080/ into the browser, it still says "Internet Explorer cannot display page"

                                  Thanks,
                                  John
                                  • 29. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
                                    438381
                                    John

                                    How about http://127.0.0.1:8080 ?

                                    Does the listener log file report anything suspicious ?
                                    1 2 3 4 Previous Next