7 Replies Latest reply on Sep 30, 2011 12:25 PM by user12117543

    Is there any problem with installing the Listener with APEX 4.1

    fatehcis-JavaNet
      Hi Udo,

      With your help, I have already installed the listener on apex 4.0.2.
      Now I tried doing the same steps, but as I click apply, in the "listenerConfigure" page, I get an empty page...
      I visited :
      http://localhost:5555/apex/apex_admin
      http://localhost:5555/apex/
      Yet, I still get an empty page....
      What could be the problem ????

      Regards,
      Fateh
        • 1. Re: Is there any problem with installing the Listener with APEX 4.1
          Udo
          Hi Fateh,

          I assume you get a database error in the console. Did you run the complete upgrade procedure described in the Installation Guide? This would include unlocking the APEX_PUBLIC_USER and (re)setting its password. Note that this doesn't only apply for new installations, as the values are reset upon the upgrade installation.

          If that's not the reason, could you post the log from console/application log? There has to be some stack trace giving us a hint on what might be wrong...

          -Udo
          • 2. Re: Is there any problem with installing the Listener with APEX 4.1
            fatehcis-JavaNet
            Thank Udo,

            Actually, I already unlocked APEX_PUBLIC_USER and rested the password.

            That is what I got on the CMD:
            Microsoft Windows [Version 6.1.7601]
            Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
            
            C:\Program Files (x86)\Java\jre6\bin>java -Dapex.port=3333 -Dapex.home=F:\listen
            er -Dapex.images=C:\images -jar F:\listener\apex.war
            INFO: Starting: F:\Listener\apex.war
             See: 'java -jar apex.war --help' for full range of configuration options
            INFO: Extracting to: F:\listener
            INFO: Using classpath: file:/F:/listener/apex/____embedded/start.jar:file:/F:/li
            stener/apex/WEB-INF/lib/apex.jar:file:/F:/listener/apex/WEB-INF/lib/commons-file
            upload-1.2.1.jar:file:/F:/listener/apex/WEB-INF/lib/je-4.0.103.jar:file:/F:/list
            ener/apex/WEB-INF/lib/ojdbc6.jar:file:/F:/listener/apex/WEB-INF/lib/ojmisc.jar:f
            ile:/F:/listener/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/F:/listener/apex/WE
            B-INF/lib/ucp.jar:file:/F:/listener/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/F:/lis
            tener/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:
            INFO: Starting Embedded Web Container in: F:\listener
            Enter a username for the APEX Listener Administrator [adminlistener]: admin
            Enter a password for admin:
            Confirm password for admin:
            Enter a username for the APEX Listener Manager [managerlistener]: man
            Enter a password for man:
            Confirm password for man:
            20-Sep-2011 8:22:30 AM ____bootstrap.Deployer deploy
            INFO: Will deploy application path=F:\listener\apex\WEB-INF\web.xml
            20-Sep-2011 8:22:31 AM ____bootstrap.Deployer deploy
            INFO: deployed application path=F:\listener\apex\WEB-INF\web.xml
            Using config file: F:\listener\apex-config.xml
            APEX Listener version : 1.1.3.243.11.40
            APEX Listener server info: Grizzly/1.9.18-o
            20-Sep-2011 8:22:31 AM com.sun.grizzly.Controller logVersion
            INFO: Starting Grizzly Framework 1.9.18-o - Tue Sep 20 08:22:31 GST 2011
            INFO: Please complete configuration at: http://localhost:3333/apex/listenerConfi
            gure
            Database connection not yet configured
            -- listing properties --
            PropertyCheckInterval=60
            ValidateConnection=true
            MinLimit=1
            MaxLimit=10
            InitialLimit=3
            AbandonedConnectionTimeout=900
            MaxStatementsLimit=10
            InactivityTimeout=1800
            MaxConnectionReuseCount=1000
            Best Regards,
            Fateh
            • 3. Re: Is there any problem with installing the Listener with APEX 4.1
              Udo
              Hi Fateh,

              okay, but it seems you haven't run listenerConfigure after this yet or any configuration was lost. The latter often happens when the configuration file is stored in a temporary location. Let's go backwards through your log:
              INFO: Please complete configuration at: http://localhost:3333/apex/listenerConfigure
              Database connection not yet configured
              This tells you, no matter what you may have configured before, that the APEX Listener didn't find any information on the database connection.
              Using config file: F:\listener\apex-config.xml
              That's where the config file is supposed to be, which fits to the apex.home you've entered in the startup command.
              As you had to enter values for Administrator and Manager as well I suppose that this was a "fresh" home. So you should run listenerConfigure by calling the suggested URL http://localhost:3333/apex/listenerConfigure

              -Udo
              • 4. Re: Is there any problem with installing the Listener with APEX 4.1
                fatehcis-JavaNet
                Thanks Udo,

                As I mentioned in the beginning of the thread. After I configure the listener on http://localhost:3333/apex/listenerConfigure , I get an empty page.
                Now, if I visit this page http://localhost:3333/apex/listenerConfigure:
                I get this message:
                The APEX Listener is already configured. Please login as Administrator to access APEX Listener Administration.
                If I visit : http://localhost:3333/apex/listenerAdmin, I get the configuration page. When I click apply, I get an empty page...

                if I visit http://localhost:3333/apex/ or http://localhost:3333/apex/apex_admin, I get an empty page....

                Best Regards,
                Fateh.

                In the CMD, I am getting this message: Connection Pool destroyed
                Microsoft Windows [Version 6.1.7601]
                Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
                
                C:\Users\Mohammad Fateh\Desktop>cd C:\Program Files (x86)\Java\jre6\bin
                
                C:\Program Files (x86)\Java\jre6\bin>java -Dapex.port=3333 -Dapex.home=F:\listen
                er -Dapex.images=C:\images -jar F:\listener\apex.war
                INFO: Starting: F:\Listener\apex.war
                 See: 'java -jar apex.war --help' for full range of configuration options
                INFO: Extracting to: F:\listener
                INFO: Using classpath: file:/F:/listener/apex/____embedded/start.jar:file:/F:/li
                stener/apex/WEB-INF/lib/apex.jar:file:/F:/listener/apex/WEB-INF/lib/commons-file
                upload-1.2.1.jar:file:/F:/listener/apex/WEB-INF/lib/je-4.0.103.jar:file:/F:/list
                ener/apex/WEB-INF/lib/ojdbc6.jar:file:/F:/listener/apex/WEB-INF/lib/ojmisc.jar:f
                ile:/F:/listener/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/F:/listener/apex/WE
                B-INF/lib/ucp.jar:file:/F:/listener/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/F:/lis
                tener/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:
                INFO: Starting Embedded Web Container in: F:\listener
                21-Sep-2011 7:58:54 AM ____bootstrap.Deployer deploy
                INFO: Will deploy application path=F:\listener\apex\WEB-INF\web.xml
                21-Sep-2011 7:58:54 AM ____bootstrap.Deployer deploy
                INFO: deployed application path=F:\listener\apex\WEB-INF\web.xml
                Using config file: F:\listener\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.3.243.11.40
                APEX Listener server info: Grizzly/1.9.18-o
                21-Sep-2011 7:58:56 AM com.sun.grizzly.Controller logVersion
                INFO: Starting Grizzly Framework 1.9.18-o - Wed Sep 21 07:58:56 GST 2011
                INFO: http://localhost:3333/apex started.
                Using JDBC driver: Oracle JDBC driver version: 11.2.0.2.0
                Connection Pool destroyed
                -- listing properties --
                PropertyCheckInterval=60
                ValidateConnection=true
                MinLimit=1
                MaxLimit=10
                InitialLimit=3
                AbandonedConnectionTimeout=900
                MaxStatementsLimit=10
                InactivityTimeout=1800
                MaxConnectionReuseCount=1000
                this is apex-config.xml file

                <?xml version="1.0" encoding="UTF-8"?>
                <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
                <properties>
                
                <comment> Created: Tue Sep 20 08:23:20 GST 2011  Version: 1.1.3.243.11.40 </comment>
                
                <entry key="apex.db.username">APEX_PUBLIC_USER</entry>
                <entry key="apex.db.password">@0553026F9472B479B40252036B93F9DE7F</entry>
                <entry key="apex.db.connectionType">basic</entry>
                <entry key="apex.db.hostname">192.168.1.19</entry>
                <entry key="apex.db.port">1521</entry>
                <entry key="apex.db.sid">xe</entry>
                <entry key="apex.db.servicename"></entry>
                <entry key="apex.db.tnsAliasName"></entry>
                <entry key="apex.db.tnsDirectory"></entry>
                <entry key="apex.db.customURL"></entry>
                <entry key="apex.jdbc.DriverType">thin</entry>
                <entry key="apex.jdbc.InitialLimit">3</entry>
                <entry key="apex.jdbc.MinLimit">1</entry>
                <entry key="apex.jdbc.MaxLimit">10</entry>
                <entry key="apex.jdbc.MaxStatementsLimit">10</entry>
                <entry key="apex.jdbc.InactivityTimeout">1800</entry>
                <entry key="apex.jdbc.AbandonedConnectionTimeout">900</entry>
                <entry key="apex.jdbc.MaxConnectionReuseCount">1000</entry>
                
                <entry key="apex.jdbc.DriverType">thin</entry>
                <entry key="apex.jdbc.InitialLimit">3</entry>
                <entry key="apex.jdbc.MinLimit">1</entry>
                <entry key="apex.jdbc.MaxLimit">10</entry>
                <entry key="apex.jdbc.MaxStatementsLimit">10</entry>
                <entry key="apex.jdbc.InactivityTimeout">1800</entry>
                <entry key="apex.jdbc.AbandonedConnectionTimeout">900</entry>
                
                <entry key="apex.security.inclusionList"></entry>
                <entry key="apex.security.exclusionList"></entry>
                <entry key="apex.security.disableDefaultExclusionList">false</entry>
                <entry key="apex.security.requestValidationFunction"></entry>
                <entry key="apex.security.maxEntries">2000</entry>
                <entry key="apex.security.trustedProxies"></entry>
                
                <entry key="apex.cache.caching">false</entry>
                <entry key="apex.cache.procedureNameList"></entry>
                <entry key="apex.cache.type">lru</entry>
                <entry key="apex.cache.maxEntries">500</entry>
                <entry key="apex.cache.expiration">7</entry>
                <entry key="apex.cache.duration">days</entry>
                <entry key="apex.cache.monitorInterval">60</entry>
                <entry key="apex.cache.directory">C:\Users\MOHAMM~1\AppData\Local\Temp\apex\cache</entry>
                
                <entry key="apex.procedure.preProcess"></entry>
                <entry key="apex.procedure.postProcess"></entry>
                
                <entry key="apex.misc.defaultPage">apex</entry>
                <entry key="apex.misc.compress"></entry>
                <entry key="apex.debug.debugger">false</entry>
                <entry key="apex.debug.printDebugToScreen">false</entry>
                <entry key="apex.error.keepErrorMessages">true</entry>
                <entry key="apex.error.maxEntries">50</entry>
                
                <entry key="apex.log.logging">false</entry>
                <entry key="apex.log.maxEntries">50</entry>
                
                </properties>
                Edited by: Fateh on Sep 20, 2011 9:11 PM
                • 5. Re: Is there any problem with installing the Listener with APEX 4.1
                  Udo
                  As I mentioned in the beginning of the thread. After I configure the listener on http://localhost:3333/apex/listenerConfigure , I get an empty page.
                  I wasn't sure about that, as the output you posted said the APEX Listener wasn't configured, so it could have been some problem with the config file location.
                  The APEX Listener is already configured. Please login as Administrator to access APEX Listener Administration.
                  That's okay.
                  If I visit : http://localhost:3333/apex/listenerAdmin, I get the configuration page. When I click apply, I get an empty page...
                  if I visit http://localhost:3333/apex/ or http://localhost:3333/apex/apex_admin, I get an empty page....
                  This, of course, is not okay. But I don't see any hint on what might be wrong in the console log.
                  In the CMD, I am getting this message: Connection Pool destroyed
                  That's not unusual if you call listenerAdmin before: The pool is being reset because there may be new parameters, especially concerning the JDBC setting, that should get effective at that time. You could argue if this is necessary if you didn't change anything, but it doesn't do any harm at this point. The pool is then created with the properties listed afterwards, which seems to be okay.

                  I don't see any problem in the config file either.
                  As you say, you've unlocked the APEX_PUBLIC_USER and changed its password. Since there are no errors in the log, I don't see any problem that can be analysed from the APEX Listener. My current guess would be some so far unrecognized error during your APEX upgrade.
                  Did you ever see that APEX upgrade working? Do you have the installation log from the APEX upgrade so you could check for any anomaly in there.

                  -Udo
                  1 person found this helpful
                  • 6. Re: Is there any problem with installing the Listener with APEX 4.1
                    user12117543
                    Hi,

                    I have the same issue. Below are the steps I performed:
                    Environment:
                    - Oracle 11g R2 RAC Standard Edition v11.2.0.2.0 on OL 5.6
                    - Glassfishv3.1.1 on OL 5.6 (on VMWare)
                    - Oracle Apex 4.1
                    - Oracle Apex Listener 1.1.3

                    1) Uninstalled the default Apex installation using apxremov scripts - Apex was never used earlier in this database, so, no ports were enabled
                    2) Dropped APEX related user schemas
                    3) Downloaded Apex 4.1 from OTN and installed successfully without any errors
                    4) Downloaded Apex Listener 1.1.3 and GlassfishServerV3 from OTN
                    5) Installed GlassfishV3 as per guidelines in the glassfish documentation
                    6) Unzipped Apex Listener to extract the apex war file and deployed to glassfish server as per Oracle Apex Listener deployment guidelines successfully.
                    7) Opened the Apex Listener configuration web site and configured to include the relevant inclusion list for stored procedures - www_flow*, p, n, cust*, apex*, f
                    8) After pressing the "Apply" button, the page navigates to an empty Oracle Apex page :(
                    9) I tried to connect to the apex_admin page, but, again end up with a empty page - http://192.168.1.20:8080/apex/f?p=4550:10:3880309940021806

                    All through the above steps, I did not encounter any kind of error messages. Am I missing something here? I am lost :(

                    Here is the apex_config.xml file:

                    <?xml version="1.0" encoding="UTF-8"?>
                    <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
                    <properties>

                    <comment> Created: Wed Sep 28 11:23:26 EDT 2011 Version: 1.1.3.243.11.40 </comment>

                    <entry key="apex.db.username">APEX_PUBLIC_USER</entry>
                    <entry key="apex.db.password">@876546789553354321D4D1D7A8C6F90234</entry>
                    <entry key="apex.db.connectionType">basic</entry>
                    <entry key="apex.db.hostname">PROD_RAC_SCAN.DOMAIN.COM</entry>
                    <entry key="apex.db.port">1521</entry>
                    <entry key="apex.db.sid"></entry>
                    <entry key="apex.db.servicename">PROD.DOMAIN.COM</entry>
                    <entry key="apex.db.tnsAliasName"></entry>
                    <entry key="apex.db.tnsDirectory"></entry>
                    <entry key="apex.db.customURL"></entry>
                    <entry key="apex.jdbc.DriverType">thin</entry>
                    <entry key="apex.jdbc.InitialLimit">3</entry>
                    <entry key="apex.jdbc.MinLimit">1</entry>
                    <entry key="apex.jdbc.MaxLimit">10</entry>
                    <entry key="apex.jdbc.MaxStatementsLimit">10</entry>
                    <entry key="apex.jdbc.InactivityTimeout">1800</entry>
                    <entry key="apex.jdbc.AbandonedConnectionTimeout">900</entry>
                    <entry key="apex.jdbc.MaxConnectionReuseCount">1000</entry>

                    <entry key="apex.jdbc.DriverType">thin</entry>
                    <entry key="apex.jdbc.InitialLimit">3</entry>
                    <entry key="apex.jdbc.MinLimit">1</entry>
                    <entry key="apex.jdbc.MaxLimit">10</entry>
                    <entry key="apex.jdbc.MaxStatementsLimit">10</entry>
                    <entry key="apex.jdbc.InactivityTimeout">1800</entry>
                    <entry key="apex.jdbc.AbandonedConnectionTimeout">900</entry>

                    <entry key="apex.security.inclusionList">www_flow*, p, n, cust*, apex*, f</entry>
                    <entry key="apex.security.exclusionList"></entry>
                    <entry key="apex.security.disableDefaultExclusionList">false</entry>
                    <entry key="apex.security.requestValidationFunction"></entry>
                    <entry key="apex.security.maxEntries">2000</entry>
                    <entry key="apex.security.trustedProxies"></entry>

                    <entry key="apex.cache.caching">true</entry>
                    <entry key="apex.cache.procedureNameList"></entry>
                    <entry key="apex.cache.type">lru</entry>
                    <entry key="apex.cache.maxEntries">500</entry>
                    <entry key="apex.cache.expiration">7</entry>
                    <entry key="apex.cache.duration">days</entry>
                    <entry key="apex.cache.monitorInterval">60</entry>
                    <entry key="apex.cache.directory">/tmp/apex/cache</entry>

                    <entry key="apex.procedure.preProcess"></entry>
                    <entry key="apex.procedure.postProcess"></entry>

                    <entry key="apex.misc.defaultPage">apex</entry>
                    <entry key="apex.misc.compress"></entry>
                    <entry key="apex.debug.debugger">false</entry>
                    <entry key="apex.debug.printDebugToScreen">false</entry>
                    <entry key="apex.error.keepErrorMessages">true</entry>
                    <entry key="apex.error.maxEntries">50</entry>

                    <entry key="apex.log.logging">false</entry>
                    <entry key="apex.log.maxEntries">50</entry>

                    </properties>


                    I have tried using both Mozilla and IE. There are couple of observations from the source (Source snippet from the blank page).
                    img src="/i/apex/builder/apex-logo-white.gif" width="300" height="30" alt="Application Express"
                         progid:DXImageTransform.Microsoft.AlphaImageLoader(src='/i/apex/builder/apex-db-apps.png');"
                         img style="filter:progid:DXImageTransform.Microsoft.Alpha(opacity=0);" src="/i/apex/builder/apex-db-apps.png"
                    The path /i/apex/builder/ does not exist in both apex home (on the database server) as well as the /i/ on the glassfish server directory. Did I miss
                    some directories while copying from images directory (on the database server) to the /i/ directory on glasshfish server?


                    Thanks,
                    Purush
                    • 7. Re: Is there any problem with installing the Listener with APEX 4.1
                      user12117543
                      Hi,

                      I got it resolved. There were missing image directories in the /i/ directory on the glassfish server. Copying the missing image directories from my apex install folder resolved the issue.

                      Thanks,
                      Purush