0 Replies Latest reply: Apr 23, 2013 5:20 PM by 887684 RSS

    Can't Access Apex After 11G Install

    887684
      Hi, I've installed 11G on a Windows Server 2008 environment and can connect to the database via SQL Plus. I've followed the configuration steps to set up Apex (3.2) but so far I can't access it via http://host:9080/apex The request is sent out via my browser and then it times out saying the page cannot be found.

      Here are the results of lsnrctl status
      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-APR-2013 23:09
      :55
      
      Copyright (c) 1991, 2010, Oracle.  All rights reserved.
      
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
      ction
      Start Date                23-APR-2013 18:33:12
      Uptime                    0 days 4 hr. 36 min. 47 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   D:\app\Oracle\product\11.2.0\dbhome_1\network\admin\li
      stener.ora
      Listener Log File         d:\app\oracle\diag\tnslsnr\s16725185\listener\alert\lo
      g.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s16725185)(PORT=9080))(Presentation=
      HTTP)(Session=RAW))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "orcl.onlinehome-server.info" has 1 instance(s).
        Instance "orcl", status READY, has 1 handler(s) for this service...
      Service "orclXDB.onlinehome-server.info" has 1 instance(s).
        Instance "orcl", status READY, has 1 handler(s) for this service...
      The command completed successfully
      s16725185 is the machine name. Here is the output I get from the listener trace file.
      Tue Apr 23 23:13:46 2013
      23-APR-2013 23:13:46 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=D:\app\Oracle\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=S16725185)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=55572)) * establish * orcl * 0
      Tue Apr 23 23:13:57 2013
      23-APR-2013 23:13:57 * service_update * orcl * 0
      23-APR-2013 23:14:05 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=55567)) * handoff * http * 12518
      TNS-12518: TNS:listener could not hand off client connection
       TNS-12541: TNS:no listener
        TNS-12541: TNS:no listener
      Tue Apr 23 23:14:07 2013
      23-APR-2013 23:14:07 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=55568)) * handoff * http * 12518
      TNS-12518: TNS:listener could not hand off client connection
       TNS-12541: TNS:no listener
        TNS-12541: TNS:no listener
      Tue Apr 23 23:14:27 2013
      23-APR-2013 23:14:27 * service_update * orcl * 0
      The listener is up and running, I'm not sure if it's something to do with the host names being different in the endpoints summary? I can ping both and receive a response.

      I'm at a loss with this at the moment any help is appreciated!