9 Replies Latest reply: Nov 29, 2012 8:05 AM by Prabodh RSS

    Problems while installing Application Express Listener

    Himanshu M-Oracle
      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
          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-Oracle
            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
              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-Oracle
                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
                  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-Oracle
                    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
                      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-Oracle
                        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
                          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.