This discussion is archived
1 2 3 4 5 6 Previous Next 75 Replies Latest reply: Nov 20, 2012 12:25 AM by Roman_OCP Go to original post RSS
  • 75. Re: Cannot open APEX http://127.0.0.1:8080/apex, but Oracle 10g express working
    Roman_OCP Newbie
    Currently Being Moderated
    same problem :(
    Cannot open APEX http://127.0.0.1:8081/apex, but Oracle 10g express working

    any help will be greatly appreciated!

    following is my scenario
    =======================================
    --------------------------------------------------------------------------------
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter user-name: sys as sysdba
    Enter password:

    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

    SQL> select dbms_xdb.gethttpport() FROM dual;

    DBMS_XDB.GETHTTPPORT()
    ----------------------
    8081

    SQL> show parameter list

    NAME TYPE VALUE
    ------------------------------------ ----------- -----------------------
    local_listener string
    remote_listener string
    SQL> select value from v$parameter where name = 'dispatchers';

    VALUE
    ------------------------------------------------------------------------

    (PROTOCOL=TCP) (SERVICE=XEXDB)


    ////////////////////////////////////lsnrctl status/////////////////////////////////////////////
    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
    Start Date 20-NOV-2012 12:24:45
    Uptime 0 days 1 hr. 31 min. 10 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=tcp)(HOST=127.0.0.1)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
    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
    ///////////////////////////////tns///////////////////////////////////////////////////
    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )
    ////////////////////////////////listener//////////////////////////////////////////////////
    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 =
    (GLOBAL_NAME = XE)
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
    (SID_NAME = xe)
    )
    )

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

    DEFAULT_SERVICE_LISTENER = (XE)
    /////////////////////////////listener log////////////////////////////////////
    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-NOV-2012 12:24:45

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

    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    20-NOV-2012 12:24:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=roman))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
    20-NOV-2012 12:25:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=roman))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
    20-NOV-2012 13:31:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=roman))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
1 2 3 4 5 6 Previous Next

Legend

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