6 Replies Latest reply: Apr 8, 2013 11:32 AM by manei RSS

    Oracle APEX admin screen is blank

    user1779355
      Hi Guys
      steps done so far:

      1. @apexins SYSAUX SYSAUX TEMP /i/
      2. @apxchpwd
      3. install standalone listener :
      java -jar apex.war
      4. start listener:
      java –Dapex.home=apex_location –Dapex.images=images_location –Dapex.port=8088 –jar apex.war
      5. go to admin screen
      http://servername:8088/apex/listenerAdmin
      6. Admin screen is blank.
      7. @apex_epg_config /tmp
      8. Admin screen is still blank.

      Any ideas why?
        • 1. Re: Oracle APEX admin screen is blank
          Udo
          Hi,
          1. @apexins SYSAUX SYSAUX TEMP /i/
          Which APEX version did you install? I assume the current one, which would be 4.1...
          3. install standalone listener :
          java -jar apex.war
          What did you enter during this (initial) configuration? Did you receive any error? Did you run "listenerConfigure"?
          4. start listener:
          java –Dapex.home=apex_location –Dapex.images=images_location –Dapex.port=8088 –jar apex.war
          Could you post the console output from startup...
          5. go to admin screen
          http://servername:8088/apex/listenerAdmin
          ... up to that action?
          7. @apex_epg_config /tmp
          This doesn't change anything, as this is only relevant when you use the Embedded PL/SQL Gateway, which is another option to host your APEX Instance. It uses the database internal XDB HTTP Server and the script you've executed loads the static contents into the XDB...
          8. Admin screen is still blank.
          Could you check the page source if it's really blank?

          -Udo
          • 2. Re: Oracle APEX admin screen is blank
            user1779355
            1. Which APEX version did you install? I assume the current one, which would be 4.1...
            Yes it is 4.1
            2. What did you enter during this (initial) configuration? Did you receive any error? Did you run "listenerConfigure"?
            entered admin pwd and manager pwd. No error. I did not run listenerConfigure
            3. Could you post the console output from startup...
            INFO: Starting: /home/test/scripts/apex/apex.war
            See: 'java -jar apex.war --help' for full range of configuration options
            INFO: Extracting to: /home/test/scripts/apex
            INFO: Using classpath: file:/home/test/scripts/apex/apex/____embedded/start.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/je-4.0.103.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/ojmisc.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/ucp.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:file:/home/test/scripts/apex/apex/WEB-INF/lib/apex.jar:
            INFO: Starting Embedded Web Container in: /home/ormerck/scripts/apex
            Jul 18, 2012 9:51:59 AM ____bootstrap.Deployer deploy
            INFO: Will deploy application path=/home/test/scripts/apex/apex/WEB-INF/web.xml
            Jul 18, 2012 9:51:59 AM ____bootstrap.Deployer deploy
            INFO: deployed application path=/home/test/scripts/apex/apex/WEB-INF/web.xml
            Using config file: /home/test/scripts/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.3.243.11.40
            APEX Listener server info: Grizzly/1.9.18-o
            Jul 18, 2012 9:52:00 AM com.sun.grizzly.Controller logVersion
            INFO: Starting Grizzly Framework 1.9.18-o - Wed Jul 18 09:52:00 EDT 2012
            INFO: http://localhost:8088/apex started.
            Using JDBC driver: Oracle JDBC driver version: 11.2.0.2.0

            4. ... up to that action?
            Now the admin screen comes up . But everything is greyed out. Cannot change anything
            5. Could you check the page source if it's really blank?
            Now its coming up but the screen is greyed out . You cannot change anything
            thanks
            • 3. Re: Oracle APEX admin screen is blank
              Udo
              entered admin pwd and manager pwd. No error. I did not run listenerConfigure
              You should have. This is the place for creating the initial configuration...
              But seeing your log, I think you have completed this step at least once.
              Now its coming up but the screen is greyed out . You cannot change anything
              That's only true for the database connection parameters and is the intended behaviour. In the current release of APEX Listener, you can't change these parameters while the application is running. There are two options to reconfigure:
              1. erase the current configuration (e.g. by setting the parameter Dapex.erase=true at startup or by deleting at least the apex-config.xml which is located in +/home/test/scripts/apex/apex-config.xml+ corresponding to your log)
              2. stopping APEX Listener and edit the apex-config.xml manually (again, +/home/test/scripts/apex/apex-config.xml+ would be the place to look at).

              But you should be able to change other parameters, e.g. the JDBC pool parameters, and you should be able to change to a different tag, e.g. to change security or caching settings or to view the current status of the APEX Listener. Is that possible?

              -Udo

              Edited by: Udo on 18.07.2012 17:00
              • 4. Re: Oracle APEX admin screen is blank
                user1779355
                I ran option 1
                erase the current configuration (e.g. by setting the parameter Dapex.erase=true at startup or by deleting at least the apex-config.xml which is located in /home/test/scripts/apex/apex-config.xml corresponding to your log)

                But now
                cd /home/test/apex
                ls -ltr
                there are no files.

                So I am trying to remove apex and reinstall. How do I do it?

                Thanks
                • 5. Re: Oracle APEX admin screen is blank
                  Udo
                  cd /home/test/apex
                  ls -ltr
                  there are no files
                  That's what you would expect after erasing, right?
                  No you should be asked to enter credentials for admin and manager as well as the path to your images again. You should then able to rerun listenerConfigure where you can enter your database connection parameters.
                  So I am trying to remove apex and reinstall. How do I do it?
                  Basically this is using "erase".

                  -Udo
                  • 6. Re: Oracle APEX admin screen is blank
                    manei
                    Hi !!,

                    run the "apxldimg.sql" script to load the images,

                    SQL> @apxldimg.sql

                    saludos!!!
                    manei