2 Replies Latest reply: Oct 10, 2012 4:48 PM by 933475 RSS

    A strange problem after installation of apex 4.1.1 on oracle 11gr2.

    933475
      I had installed a oracle11gR2 on my windows 7, and created a default DB "orcl".

      After I finished oracle dba course, I decided to create a new DB by using scripts.
      then, I drop the DB "orcl" and successfully added EM with dbca and apex..

      finally, I installed apex to 4.1.1 on my new database,

      SQL> @apexins APEX APEX_FILES TEMP /i/
      SQL> @apxldimg.sql c:\
      @apxchpwd
      @apex_epg_config c:\app
      ALTER USER ANONYMOUS ACCOUNT UNLOCK;
      EXEC DBMS_XDB.SETHTTPPORT(8080);
      EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
      SQL> SELECT STATUS FROM DBA_REGISTRY
      2 WHERE COMP_ID = 'APEX';

      STATUS
      -----------
      VALID

      add this to my listener.ora
      (DESCRIPTION=
      (ADDRESS = (PROTOCOL=tcp)(HOST=my-PC)(PORT=8080))(Presentation=HTTP)(Session=RAW)
      )
      )

      C:\Windows\system32>lsnrctl start

      LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-JUL-2012 21:07:13

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

      Starting tnslsnr: please wait...

      TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
      System parameter file is D:\app\my\product\11.2.0\dbhome_2\network\admin\listener.ora
      Log messages written to d:\app\my\diag\tnslsnr\my-PC\listener\alert\log.xml
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my-PC)(PORT=1521)))
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my-PC)(PORT=8080))(Presentation=HTTP)(Session=RAW))

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
      Start Date 30-JUL-2012 21:07:18
      Uptime 0 days 0 hr. 0 min. 5 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File D:\app\my\product\11.2.0\dbhome_2\network\admin\listener.ora
      Listener Log File d:\app\my\diag\tnslsnr\my-PC\listener\alert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my-PC)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=my-PC)(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...
      The command completed successfully

      Then I was trying to access http://localhost:8080/apex/

      No data received
      Unable to load the webpage because the server sent no data.
      Here are some suggestions:
      Reload this webpage later.
      Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data.

      then I found another way by downloading a new listener.
      http://blog.terrencemiao.com/archives/step-by-step-to-install-oracle-application-express-apex-4-1-1

      now I can connect to apex though http://localhost:8585/apex/
      but, I need to manually start the service by this command:

      c:\app\apex>java -Dapex.home=d:\app\apex\tmp -Dapex.images=d:\app\apex\images -Dapex.port=8585 -jar apex.war

      So, did there anyone know how to make it start normally???

      Edited by: 930472 on Jul 30, 2012 8:51 PM