Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

933475Jul 30 2012 — edited Oct 10 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2012
Added on Jul 30 2012
2 comments
475 views