1 2 3 4 5 6 Previous Next 75 Replies Latest reply: Nov 20, 2012 2: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
        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