A strange problem after installation of apex 4.1.1 on oracle 11gr2.
933475Jul 30 2012 — edited Oct 10 2012I 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