Apex Login Page not comming.
799923Oct 17 2011 — edited Oct 17 2011Hi,
We have installed 11g R2 database in linux then installed Apex 4.2, when i am trying to log in Apex,page is not displaying,any suggestions to check, i am using pl/sql gateway to connect APEX.
default installation wich was with 11g R2 installation..
SELECT COMP_ID, COMP_NAME, VERSION, STATUS from DBA_REGISTRY WHERE COMP_ID='APEX';
COMP_ID COMP_NAME VERSION STATUS
--------------- ----------------------------------- --------------- -----------
APEX Oracle Application Express 3.2.1.00.10 VALID
unlocked Apex user
SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
User altered.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
User altered
SQL> ALTER USER APEX_PUBLIC_USER identified by apex123;
User altered.
SQL> ALTER USER ANONYMOUS identified by apex123;
User altered.
and
- Enable Oracle XML DB HTTP Server:
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
-----------
0
SQL> EXEC DBMS_XDB.SETHTTPPORT(8080);
PL/SQL procedure successfully completed.
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
-----------
8080
after this step, port added to listener also
lsnrctl status LISTENER_APEX
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-OCT-2011 16:49:01
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apex.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 05-DEC-2010 18:37:06
Uptime 312 days 21 hr. 11 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/apex/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apex)(PORT=1521)))
(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apex.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
i don't know what went wrong, any suggestions.