This discussion is archived
1 2 3 4 6 Previous Next 75 Replies Latest reply: Nov 20, 2012 12: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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    John

    How about http://127.0.0.1:8080 ?

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points