This discussion is archived
9 Replies Latest reply: Nov 29, 2012 6:05 AM by Prabodh RSS

Problems while installing Application Express Listener

Himanshu M Newbie
Currently Being Moderated
Hi
I am new to Oracle Application Express, and am installing it for the first time. I am following instructions from Installation Guide (http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm), and am stuck after installing the listener service. I think I have installed the service, but the web page is blank. In IE, I see the error icon in the status bar. When opened, I get the following error message:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; .NET CLR 1.1.4322)
Timestamp: Mon, 26 Nov 2012 09:24:50 UTC


Message: 'apex' is undefined
Line: 35
Char: 1
Code: 0
URI: http://localhost:8080/apex/f?p=4550:1:10702613836253:::::


Message: 'apex' is undefined
Line: 110
Char: 1
Code: 0
URI: http://localhost:8080/apex/f?p=4550:1:10702613836253:::::



My set up is:
Oracle DB 11g Standard running at port 1158. The APEX listener service is configured for port 1521, but when I enter http://localhost:1521/apex/ in browser, it automatically changes to http://localhost:8080/apex/.

Listener service is running fine (I guess):
C:\SW\Apex\apex_listener>java -jar apex.war
INFO: Starting: C:\SW\Apex\apex_listener\apex.war
+See: 'java -jar apex.war --help' for full range of configuration options+
INFO: Extracting to: C:\Users\hm\AppData\Local\Temp\apex
INFO: Using classpath: file:/C:/Users/hm/AppData/Local/Temp/apex/apex/____
embedded/start.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/
lib/apex.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/co
mmons-fileupload-1.2.1.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/
WEB-INF/lib/je-4.0.103.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/
WEB-INF/lib/ojdbc6.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-
INF/lib/ojmisc.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/
lib/poi-3.6-20091214.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WE
B-INF/lib/ucp.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/l
ib/xdb-11.2.0.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/l
ib/xmlparserv2-11.2.0.jar:
INFO: Starting Embedded Web Container in: C:\Users\hm\AppData\Local\Temp\a
pex
Nov 26, 2012 2:16:30 AM ____bootstrap.Deployer deploy
INFO: Will deploy application path=C:\Users\hm\AppData\Local\Temp\apex\ape
x\WEB-INF\web.xml
Nov 26, 2012 2:16:31 AM ____bootstrap.Deployer deploy
INFO: deployed application path=C:\Users\hm\AppData\Local\Temp\apex\apex\W
EB-INF\web.xml
Using config file: C:\Users\hm\AppData\Local\Temp\apex\apex-config.xml
+-- listing properties --+
PropertyCheckInterval=60
ValidateConnection=true
MinLimit=1
MaxLimit=10
InitialLimit=3
AbandonedConnectionTimeout=900
MaxStatementsLimit=10
InactivityTimeout=1800
MaxConnectionReuseCount=1000
APEX Listener version : 1.1.4.195.00.12
APEX Listener server info: Grizzly/1.9.18-o
Nov 26, 2012 2:16:53 AM com.sun.grizzly.Controller logVersion
INFO: Starting Grizzly Framework 1.9.18-o - Mon Nov 26 02:16:53 MST 2012
INFO: http://localhost:8080/apex started.
Using JDBC driver: Oracle JDBC driver version: 11.2.0.2.0


Here is the output from lsnrctl status+ command:

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 26-NOV-2012 02:40:42

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 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                25-NOV-2012 23:16:01
Uptime                    0 days 3 hr. 24 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\hm\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         c:\app\hm\diag\tnslsnr\dummy\listener\alert\log.xml
Listening Endpoints Summary...
+(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))+
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dummy.com)(PORT=1521)))+
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xxxx" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "xxxx" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully


Could you please help me resolve the issue?



------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One more thing. I tried installing the APEX and Listener service on another machine with Oracle 10g Express Edition. There too, I could install APEX (as per http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BABHHIJB), but while installing Listener Service, some config went wrong and now when I start the database, the OracleXETNSListener does not start.

C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleXETNSListener
The OracleXETNSListener service is starting.
The OracleXETNSListener service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.


C:\oraclexe\app\oracle\product\10.2.0\server\BIN>net start OracleServiceXE
The OracleServiceXE service is starting..
The OracleServiceXE service was started successfully.

The lsnrctl status+ gets stuck too:
C:\Users\hm>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-NOV-2012 15:11
+:55+

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
+32-bit Windows Error: 2: No such file or directory+
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dummy
+)(PORT=1521)))+
+^C+
C:\Users\hm>


How can I revert back to original settings of Oracle XE database?

Edited by: user783239 on Nov 27, 2012 6:47 AM
  • 1. Re: Problems while installing Application Express Listener
    Prabodh Guru
    Currently Being Moderated
    user783239

    Welcome to Oracle Forums!
    Please acquaint yourself with the FAQ and forum etiquette if you haven't already done so.
    ApexListener version?
    >
    My set up is:
    Oracle DB 11g Standard running at port 1158. The APEX listener service is configured for port 1521, but when I enter http://localhost:1521/apex/ in browser, it automatically changes to http://localhost:8080/apex/.
    >
    I think you are confusing the use of ports. 1158 is your Db port, your listener.ora uses this port, so that is the port you specify in the connection settings of ApexListener for JDBC to use.
    In your setup port 1521 does not appear to have any significance and hence should not be used anywhere.

    The 8080 is the ApexListener port on which the browser will access Apex and that what must be specified in the URL.

    To be on the safer side, when using ApexListener, disable the EPG by running the following command when connected to DB as SYSDBA
    SQL>EXEC DBMS_XDB.SETHTTPPORT(0);
    SQL>COMMIT;
    Cheers,
  • 2. Re: Problems while installing Application Express Listener
    Himanshu M Newbie
    Currently Being Moderated
    Thanks for replying, and clearing the port confusion. But, I am still stuck at the blank page. Is there a solution for the following error:

    Webpage error details

    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; .NET CLR 1.1.4322)
    Timestamp: Mon, 26 Nov 2012 09:24:50 UTC

    Message: 'apex' is undefined
    Line: 35
    Char: 1
    Code: 0
    URI: http://localhost:8080/apex/f?p=4550:1:10702613836253:::::

    Message: 'apex' is undefined
    Line: 110
    Char: 1
    Code: 0
    URI: http://localhost:8080/apex/f?p=4550:1:10702613836253:::::
  • 3. Re: Problems while installing Application Express Listener
    Prabodh Guru
    Currently Being Moderated
    A. Is your ApexListener actually listening on port 8080?
    B. Is there any other process that is already using 8080? EPG is a candidate, therefore needs to be disabled.
    C. Is Apex installed?
    D. Are your config files pinned to a fixed directory , not temp? See documentation

    You still have not mentioned your ApexListener version.
  • 4. Re: Problems while installing Application Express Listener
    Himanshu M Newbie
    Currently Being Moderated
    I am using Apex 4.2, and the installation is fresh not an upgrade. I am not a technical person, so my understanding of the concepts and configuration might not be as good as a technical person, my apologies for that.

    APEX is installed at C:\SW\Apex\apex_4.2_en\apex, and Listener is installed at C:\SW\Apex\apex_listener. APEX_HOME is set to APEX_HOME=C:\SW\Apex\apex_4.2_en\apex.

    * I installed APEX using +@apexins.sql SYSAUX SYSAUX TEMP /i/+ command, and didn't face any issue with the installation.
    * In DB, I unlocked the APEX_REST_PUBLIC_USER account, and changed its password.
    * Installed Listener in standalone mode as per instructions here: http://download.oracle.com/otn/java/appexpress/1.1/docs/AELIG/E21058_01.pdf
    * Configured Listener on http://localhost:8080/apex/listenerConfigure.
    * I run the listener with java -jar apex.war command:

    C:\SW\Apex\apex_listener>java -jar apex.war
    INFO: Starting: C:\SW\Apex\apex_listener\apex.war
    See: 'java -jar apex.war --help' for full range of configuration options
    INFO: Extracting to: C:\Users\hm\AppData\Local\Temp\apex
    INFO: Using classpath: file:/C:/Users/hm/AppData/Local/Temp/apex/apex/____embedded/start.jar:file:/C:/Users/hmarat
    he/AppData/Local/Temp/apex/apex/WEB-INF/lib/apex.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/co
    mmons-fileupload-1.2.1.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/je-4.0.103.jar:file:/C:/User
    s/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-
    INF/lib/ojmisc.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/C:/Users/
    hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/ucp.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/l
    ib/xdb-11.2.0.jar:file:/C:/Users/hm/AppData/Local/Temp/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:
    INFO: Starting Embedded Web Container in: C:\Users\hm\AppData\Local\Temp\apex
    Nov 27, 2012 2:26:31 AM ____bootstrap.Deployer deploy
    INFO: Will deploy application path=C:\Users\hm\AppData\Local\Temp\apex\apex\WEB-INF\web.xml
    Nov 27, 2012 2:26:31 AM ____bootstrap.Deployer deploy
    INFO: deployed application path=C:\Users\hm\AppData\Local\Temp\apex\apex\WEB-INF\web.xml
    Using config file: C:\Users\hm\AppData\Local\Temp\apex\apex-config.xml
    -- listing properties --
    PropertyCheckInterval=60
    ValidateConnection=true
    MinLimit=1
    MaxLimit=10
    InitialLimit=3
    AbandonedConnectionTimeout=900
    MaxStatementsLimit=10
    InactivityTimeout=1800
    MaxConnectionReuseCount=1000
    APEX Listener version : 1.1.4.195.00.12
    APEX Listener server info: Grizzly/1.9.18-o
    Nov 27, 2012 2:26:54 AM com.sun.grizzly.Controller logVersion
    INFO: Starting Grizzly Framework 1.9.18-o - Tue Nov 27 02:26:54 MST 2012
    INFO: http://localhost:8080/apex started.


    * After starting the listener, if I open http://localhost:8080/apex/listenerConfigure, I get
    The APEX Listener is already configured. Please login as Administrator to access APEX Listener Administration.

    * At http://localhost:8080/apex/listenerAdmin, I am prompted for username and password, and now I can't remember the default username of admin. How can I find that out?

    Edited by: user783239 on Nov 27, 2012 6:52 AM
  • 5. Re: Problems while installing Application Express Listener
    Prabodh Guru
    Currently Being Moderated
    user783239

    Apex version and details do not affect ApexListener

    Problem area:
    Nov 27, 2012 2:26:31 AM ____bootstrap.Deployer deploy
    INFO: deployed application path=C:\Users\hm\AppData\Local\Temp\apex\apex\WEB-INF\web.xml
    Using config file: <b>C:\Users\hm\AppData\Local\Temp\apex\apex-config.xml</b>>
    Read the About the Listener Configuration File -> Locating the Configuration File . Use the -Dapex.home parameter for standalone mode.
    --From the Installation doc:
    -Dapex.home=/path/to/apex : Path to the folder used to store the web container runtime, defaults to: ${java.io.tmpdir}/apex>

    Steps:
    1. Stop ApexListener
    2. Pin the location of config file as mentioned above
    3. Start listener
    4. Configure listener again using apex/listenerConfigure

    Cheers,
  • 6. Error : Message: 'apex' is undefined
    Himanshu M Newbie
    Currently Being Moderated
    Thanks, but I couldn't get it to work, so I thought of starting fresh. On my laptop, I uninstalled the database, restarted the laptop, and reinstalled Oracle Database 10g Express Edition.

    After a fresh installation of Database, I did the following:

    1. Verified the DB home page (http://127.0.0.1:8080/apex) opens.

    2. Installed APEX with the following command:
    *@apexins.sql SYSAUX SYSAUX TEMP /i/*

    Installation successful.

    3. Without installing the listener_, tried opening http://127.0.0.1:8080/apex, but this time faced the same blank page problem. The page loads, I can see "Application Express Login" in the browser title bar, there is a source code when I do View Source, but the same two errors:

    Message: 'apex' is undefined
    Line: 35
    Char: 1
    Code: 0
    URI: http://127.0.0.1:8080/apex/f?p=4550:1:22301135410489:::::


    Message: 'apex' is undefined
    Line: 110
    Char: 1
    Code: 0
    URI: http://127.0.0.1:8080/apex/f?p=4550:1:22301135410489:::::


    The file that gets loaded on http://127.0.0.1:8080/apex is f.htm and here is its source code of line 34-36:
    +<script type="text/javascript">+
    apex.security.framebreaker("D");
    +</script>+

    and line 109-11 is :
    +<script type="text/javascript">+
    +apex.jQuery( document ).ready( function() {+
    +(function(){+

    FYI .. In the source code, there are several references to /i/ folder:

    +<link rel="stylesheet" href="/i/libraries/jquery-ui/1.8.22/themes/base/jquery-ui.min.css" type="text/css" />+
    +<link rel="stylesheet" href="/i/css/apex_builder.min.css?v=4.2.0.00.27" type="text/css" />+
    +<link rel="stylesheet" href="/i/css/apex_ui.min.css?v=4.2.0.00.27" type="text/css" />+


    The apex.properties file point to correct location:
    apex.images=D\:\\Work\\OtherMisc\\APEX\\apex_4.2_en\\apex


    I found some related threads with the same problem but different solutions and none worked in my favor:
    https://forums.oracle.com/forums/thread.jspa?messageID=9887891
    https://kr.forums.oracle.com/forums/thread.jspa?threadID=1255676
  • 7. Re: Error : Message: 'apex' is undefined
    Prabodh Guru
    Currently Being Moderated
    Thanks, but I couldn't get it to work, so I thought of starting fresh. On my laptop, I uninstalled the database, restarted the laptop, and reinstalled Oracle Database 10g Express Edition.
    After a fresh installation of Database, I did the following:

    1. Verified the DB home page (http://127.0.0.1:8080/apex) opens.
    >
    Oracle XE Home Page , ok. URL given is wrong, it should have been http://127.0.0.1:8080. I.e. without /apex at the end.
    >
    2. Installed APEX with the following command:
    @apexins.sql SYSAUX SYSAUX TEMP /i/

    Installation successful.

    3. Without installing the listener, tried opening http://127.0.0.1:8080/apex, but this time faced the same blank page problem. The page loads, I can see "Application Express Login" in the browser title bar, there is a source code when I do View Source, but the same two errors:
    >
    That is because you did not run apxldimg.sql. It is this script that creates and load images folder (/i/)
    >
    Message: 'apex' is undefined
    Line: 35
    Char: 1
    Code: 0
    URI: http://127.0.0.1:8080/apex/f?p=4550:1:22301135410489:::::

    Message: 'apex' is undefined
    Line: 110
    Char: 1
    Code: 0
    URI: http://127.0.0.1:8080/apex/f?p=4550:1:22301135410489:::::

    The file that gets loaded on http://127.0.0.1:8080/apex is f.htm and here is its source code of line 34-36:
    <script type="text/javascript">
    apex.security.framebreaker("D");
    </script>

    and line 109-11 is :
    <script type="text/javascript">
    apex.jQuery( document ).ready( function() {
    (function(){

    FYI .. In the source code, there are several references to /i/ folder:
    >
    /i/ folder is critical part of Apex installation.
    The apxldimg.sql referred to above loads the images folder to Embedded PL/SQL Gateway (EPG). EPG is the default web server of Oracle XE.

    >
    <link rel="stylesheet" href="/i/libraries/jquery-ui/1.8.22/themes/base/jquery-ui.min.css" type="text/css" />
    <link rel="stylesheet" href="/i/css/apex_builder.min.css?v=4.2.0.00.27" type="text/css" />
    <link rel="stylesheet" href="/i/css/apex_ui.min.css?v=4.2.0.00.27" type="text/css" />

    The apex.properties file point to correct location:
    apex.images=D\:\\Work\\OtherMisc\\APEX\\apex_4.2_en
    apex

    I found some related threads with the same problem but different solutions and none worked in my favor:
    https://forums.oracle.com/forums/thread.jspa?messageID=9887891
    https://kr.forums.oracle.com/forums/thread.jspa?threadID=1255676>
    apxldimg.sql is for EPG alone, not for apexlistener.
    If you want to run your ApexListener on port 8080 then you must disable EPG with
    SQL>EXEC DBMS_XDB.SETHTTPPORT(0);
    SQL>COMMIT; -- Important
    When ApexListener is started in Standalone mode the port it will use for accessing the Apex URL is displayed, and you have to use the same port.
  • 8. Re: Error : Message: 'apex' is undefined
    Himanshu M Newbie
    Currently Being Moderated
    Thanks again for helping me, it worked, and I can see the login page. Where can I find the default workspace and login/pwd details?

    ... and how to get my DB login page back? The http://127.0.0.1:8080 url opens DB licence agreement page.

    Update: Updated the admin username and pwd. Now, I need help to get my DB login page back.

    Edited by: user783239 on Nov 29, 2012 5:36 AM
  • 9. Re: Error : Message: 'apex' is undefined
    Prabodh Guru
    Currently Being Moderated
    Thanks again for helping me, it worked, and I can see the login page. Where can I find the default workspace and login/pwd details?
    1. Create a tablespace
    2. Create a user with the above tablespace as the DEFAULT TABLESPACE. This ensures Db objects do not get created in SYSAUX,etc.
    3. Open http://127.0.0.1:8080/apex
    4. Login as Workspace=Internal, User=Admin and Password = password you specified when you ran apxchpwd.sql. If you have forgotten, run than script again to change the password.
    5. Create Workspace , use the above schema as the default schema. Follow the wizard.

    >
    ... and how to get my DB login page back? The http://127.0.0.1:8080 url opens DB licence agreement page.
    >
    That URL only shows the license agreement. No login to DB from here.

    For login to DB use SQLPlus, SQLDeveloer, Apex - SQL Worksop or any of the other tools available.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points